1. Convert the following data models to diagrams.
1a.
1b.
| CITY | |
| CITYNAME | CITYPOP |
| STREET | ||
| STNAME | STLENGTH | CITYNAME |
| HOUSE | ||||
| HNUM | HSIZE | HCOLOR | STNAME | CITYNAME |
| PERSON | |||
| PSSN | PFNAME | PLNAME | PDOB |
| APARTMENT | |||||
| APNUMBER | APSIZE | APBEDROOMS | HNUMBER | STNAME | CITYNAME |
| DOMICILE | ||||
| PSSN | APNUMBER | HNUMBER | STNAME | CITYNAME |
| CAR | |
| CARID | … |
| OWNER | |
| OWNERID | ... |
| OWNERSHIP | ||
| PERCENTAGE | CARID | OWNERID |
| RESERVATION | |||||
| RESVBEGDATE | RESVBEGTIME | RESVENDDATE | RESVENDTIME | CARID | OWNERID |
| This page is part of the promotional and support
material for Data Management (open edition) by Richard T. Watson For questions and comments please contact the author |