A multi national company has offices around the world The company has various

A multi national company has offices around the world

This preview shows page 3 - 5 out of 8 pages.

17.A multi-national company has offices around the world. The company has various departments (e.g., Finance, IT, Marketing) in each country. The department names are in each country but notacross countries. The company stores quarterly performance scores for each department from every country in its central database that has two tables named “Department” and “Performance.” Which of these is most likely to be true?
Background image
a.The primary key of the Department table is department nameb.The foreign key in the Performance table include department name and countryc.The primary key of the Performance table includes the performance scored.The foreign key in the Department table is country18.A table named “Employee” in a database contains information about Employees. Each employeeworks for one department. Each department has multiple employees. The field/column named “DeptNum” in the Employee table links each employee to another table called “Department” that contains the information about departments. Which of these is most likely to be true?19.Ina relational database, the link between two tables by a primary key and a foreign key is known as:20.A table with details of students from different universities has two attributes, University ID and University Name, as its composite primary key. Hence:21.When a many-to-many relationship is found between two tables in a relational database it is necessary to create a ___________ to link the two tables together to eliminate the many-to-many relationship.a.New columnb.New rowc.New tabled.New database
Background image
Image of page 5

You've reached the end of your free preview.

Want to read all 8 pages?

  • Spring '13
  • Unknown
  • Relational model, Foreign key, Candidate key, relation, University Name

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture