HW1 Solutions Page

Return to homework page.

Here are the three files that I made: [ertables.pdf] [ertables.mdb] [harddrive.pdf]. What I was expecting in an answer to the first part was some reasonable ER diagram that illustrated the major components of ER diagrams; that is, Entities, their Attributes, Relationships, and Weak Entities. Usually, ER diagrams do not allow subclassing -- these are allowed in extended ER diagrams. Our book, however, defines ER with subclassing, so I will allow it in this homework. My diagrams are done under the assumption they are not in the model. I fake them them with weak entity types. Given the diagram I was expecting that one follow the steps in the book (showing each step) to produce the tables for the relational model as well as foreign keys. For the disk size estimates you should be within an order of magnitude on the file sizes.

Return to homework page.