HW#1 --- last modified January 01 1970 00:00:00..
Solution set.
Due date: Sep 11
Files to be submitted:
Problems.doc
RequirementsER.doc
Pet.mdb
Purpose: The purpose of this assignment is to
refresh our memories about
database design from CS157a as wells as do some simple problems related to OO
databases.
Specification:
Do problems 11.14 and 11.15 from E&N. Submit these in the file
Problems.doc. Then pretend that you have been put in charge of
designing the database for an on-line pet store. (Please do not turn in a sock-puppet with this assignment.)
In the file RequirementsER.doc come up with a list of requirements such
a retailer might have. Then in the same file suggest an E-R diagram
for this retailer. Do the E-R to relational model mapping (make
sure to give foreign key constraints clearly!)
and give the result in your file.
Say which of the normal forms 1-5 and BCNF the resulting schema satisfies.
Implement the resulting schema in Access (adding 3 rows to each table).
Submit the database as Pet.mdb.
Point Breakdown
11.14 | 2pts |
11.15 |
2pts |
List of requirements | 1/2pt |
E-R schema | 1/2pt |
E-R --> mapping | 1pt |
Saying normal forms satisfied | 3pts (1/2pt each) |
Access implementation | 1pt |
Total | 10pts |
|