Exam 5: Database Design

Given the tables PRODUCT (ProductID,Description,Cost) SUPPLIER (SupplierID,ContactName,PhoneNumber) As shown in the figure below,which of the following would represent the correct placement of foreign keys?

An entity needs to be examined according to normalization criteria before creating a table from it in the relational database design.

Given the tables TABLE_A (Attribute1,Attribute2,Attribute3) TABLE_B (Attribute4,Attribute5,Attribute6) As shown in the figure below,which of the following would display the correct placement of foreign keys in the relational model?

The ideal primary key is short,numeric,and fixed.

The first step of database design is to define a table for each ________.

The ideal primary key is ________.

Which of the following is the correct technique for representing a M:N relationship using the relational model?

Microsoft Access does not create N:M relationships because:

By default,when Microsoft Access creates a relationship between two tables,it creates a(n):

In certain circumstances,there may be a preference as to which table in a 1:1 relationship contains the foreign key.

In relational database design,ID-dependent entities are used to ________.

When transforming an ID-dependent E-R data model relationship into a relational database design and the child entity is designed to use a surrogate key,then ________.

As far as Microsoft Access is concerned,there are no ________.

Which of the following is the correct technique for representing a 1:N relationship in the relational model?

Which of the following is true about representing a weak entity with the relational model?

What is an association relationship,and how does it differ from an N:M relationship?

As far as Microsoft Access is concerned,there are no N:M relationships.

To create a 1:1 relationship in Microsoft Access,the Indexed property of the foreign key column must be set to Yes (No Duplicates).

What relationship pattern is illustrated in the following schema? VEHICLE (VehicleID,Cost) CAR (VehicleID,NumberOfSeats) TRUCK (VehicleID,CargoCapacity) VehicleID in CAR must exist in VehicleID in VEHICLE VehicleID in TRUCK must exist in VehicleID in VEHICLE

Once a table has been defined,it should be examined according to ________ criteria.