The questions which follow refer to this ERD:

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

MC1a.  _B__                                                   This is a __ relationship.

 

a.      unary                                                       d.      simple

b.      binary                                                      e.      complex

c.      ternary

 

MC1b.  _B__ This is a __ relationship.

 

a.      1:1                                                           d.      1:1:M

b.      1:M                                                         e.      M:M:M

c.      M:M    

 

MC1c.  _A__                                                   Which of the following is a primary key?

 

a.   employee_ID                                              d.      depart_id

b.   employee_name                                          e.      skill

c.   address

 

 

MC1d.  _D__                                                   Which of the following is a foreign key?

 

a.   employee_ID                                              d.      depart_id

b.   employee_name                                          e.      skill

c.   address

 

MC1e.  _B__ Which of the following is a composite attribute?

 

a.   employee_ID                                              d.      yrs_employeed

b.   address                                                       e.      skill

c.   depart_id

 

MC1f.  _E__ Which of the following is a multivalued attribute?

 

a.   employee_ID                                              d.      yrs_employeed

b.   address                                                       e.      skill

c.   depart_id

 

MC1g.  _D__                                                   Which of the following is a derived attribute?

 

a.   employee_ID                                              d.      yrs_employeed

b.   address                                                       e.      skill

c.   depart_id