Quiz # 5 – Section 2 – CS 474

Name ______________________________

E.14.1. What is a semantic object view?

2. Given the example of an APARTMENTobject with the following attributes (BuildingName, ApartmentNumber, RentAmount, LastOccupiedDate ) provide two views

3. What type of object is shown below? simple object e-15

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

5. Indicate any referential integrity constraints

E.7.6. List the three types of attributes.

E.10.7. What is maximum cardinality?

8. Which types of attributes have maximum cardinality?

9. What type of object is shown below? 1:1 compound object E-17

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

11. Indicate any referential integrity constraints