IS 315 Analysis and Design Techniques

Homework Assignment 6

Mike’s Bikes (continued)

In Homework Assignment 5 we were introduced to Mike’s Bikes, a bicycle rental business on the lakeshore path.

In the course of that assignment, we created an origin level data flow diagram (DFD) of the system; an entity relationship diagram (ERD) for the system, including associative entities and cardinality; and noted which data fields applied to each entity, including showing primary keys (PKs) and foreign keys (FKs) designations.

Given the following as the solution to the ERD and data parts of the assignment:  

Using the 3 steps of Data Normalization:

1. Remove the repeating fields

2. Remove the fields that are dependent on part of the primary key

3. Remove the fields that are dependent on another nonprimary key field

Normalize the data shown above to third normal form (3NF). Add additional fields and expand the ERD to accommodate the 3NF normalized data. Indicate Primary and Foreign keys by placing ‘PK’ and ‘FK’ next to the appropriate data fields.

© 2003 by Joel E. Bernstein
All rights reserved
Last updated October 23, 2003