Quiz # 5 – Section 1 – CS 474

Name ______________________________

E.2.1.         Define semantic object.

 

 

 

2.      Give an example of each of the following in a semantic object named  APARTMENT:

a.                  a simple, single-value attribute:

 

b.                  a simple, multivalue attribute

 

c.                  a group, multivalue attribute

 

d.                  a simple object attribute

 

 

  1. What type of object is shown below?  

 

 

E.16.4.       Show how to represent this object by means of relations.

 

 

 

 

 

5.   Identify any necessary referential integrity constraints

 

 

 

E.9.6..        What is minimum cardinality?

 

 

 

7.      Which types of attributes have minimum cardinality?

 

 

 

 

8.      What type of object is shown below?   

 

9.      Show how to represent the above object by means of relations

 

 

 

 

 

 

 

10.  Identify any necessary referential integrity constraints: