chapter 4 quiz

Question 1

A database logical design

Is independent of any DBMS

Does not concern entities and attributes

Is dependent on the features and functionality of a particular DBMS

Is what is used to produce ‘create table’ statements

Answer 1

Is independent of any DBMS

Question 2

In crow’s foot notation for a 1:N relationship, which way does the three-prong crow’s foot point?

To the primary key side of the relationship

To the foreign key side of the relationship

In the direction of the program flow

None of the above

Answer 2

To the foreign key side of the relationship

Question 3

Which of the following is true of 1:1 relationships?

Each row in the PK entity can be related to many rows in the FK entity

Each row in the PK entity is related to zero or one row in the FK entity

Each relationship in the PK entity can have many related rows in the FK entity

The relationship is usually not created in a DBMS

Answer 3

Each row in the PK entity is related to zero or one row in the FK entity

Question 4

Which of the following is true of a N:M relationship?

A. Each row in the PK entity can have many related rows in the FK entity and each row in the FK table can have many related rows in the PK entity

B. The relationship is usually not created in a DBMS

C. Both A and B

D. None of the above

Answer 4

C. Both A and B

Question 5

Which of the following is true of 1:M relationships?

Each row in the PK entity can be related to zero or many rows in the FK entity

Each row in the PK entity is related to zero or one rows in the FK entity

Each relationship in the PK entity can have many related rows in the FK entity and each row in the FK entity can have many related rows in the PK entity

The relationship is usually not created in a DBMS

Answer 5

Each row in the PK entity can be related to zero or many rows in the FK entity

Question 6

The number of entity classes in the relationship is known as the _______ of the relationship

Answer 6

degree