Exam 5: Database Design

A(n)________ is a relationship among entities of the same class.

To create a 1:1 relationship between two tables in Microsoft Access,the Indexed property of the foreign key column must be set to ________.

When creating a table in the relational database design from an entity in the extended E-R model,the attributes of the entity become the rows of the table.

One of the important properties of a column is whether or not it is ________.

Explain the representation of a one-to-many strong entity relationship in a relational database design.

Recursive relationships can be represented in the relational model using the same techniques that are used for binary relationships.

By default,Microsoft Access creates 1:1 relationships between tables.

To create a 1:1 relationship between two tables in Microsoft Access:

To normalize a relation,the determinant of every functional dependency should be a(n)________.

In many-to-many relationships in a relational database design,________.

Which of the following is not true of recursive relationships?

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

The technique for representing E-R relationships in the relational model is dependent on the minimum cardinality.

There are cases where it is possible to normalize a table too far,in which case there may be a need for ________.

The key for an intersection relation is always the combination of the keys of the parent entities.

All recursive relationships are 1:1.

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?

When applied to 1:N relationships,the term "parent" refers to the many side of the relationship since a child may have many parents.

By default,the identifier of the entity becomes the foreign key of the corresponding table.

In many-to-many relationships in a relational database design,________.