Exam 2: The Relational Model

In SQL Server,the starting value of a surrogate key is called the:

The use of surrogate keys usually complicates application programming since most DBMS products require the application program to generate surrogate key values.

When used to represent a relationship,the primary key must have the same name as the corresponding foreign key.

To create a relationship in Microsoft Access,we drag and drop the ________ of a table.

Any table that meets the definition of a relation is said to be in second normal form.

A key must be unique.

A candidate key is:

A rule that requires that the values in a foreign key must have a matching value in the primary key to which the foreign key corresponds is called:

In Microsoft Access,relationships between tables are built in the ________.

Distinguish between the primary key and a candidate key.

Given the below functional dependency, MedicineCode ? (MedicineName,ShelfLife,Manufacturer,Dosage) Which of the following statements is not known to be true?

In Microsoft Access,relationships between tables are created in the Relationships window.

In Microsoft Access,referential integrity constraints are created:

Which of the following is true about a relation?

Which of the following is not true about a relation?

Since surrogate keys are used to uniquely identify rows,their values are normally displayed prominently on all forms and reports for the users to see.

A surrogate key may be appropriate under which of the following circumstances?

Every table is a relation,but not every relation is a table.

Null values can cause problems because they are ambiguous.

In Microsoft Access,the Relationships window is accessed by using the ________ button on the Database tools command tab.