IS315_3_Homework7

IS 315 Analysis and Design Techniques

Homework Assignment 7

Mike’s Bikes (continued)

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

In the course of those assignments, 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 DFD:

And the following as the ERD and data:

create a CRUD (Creates-Reads-Updates-Deletes) matrix for Mike’s Bikes. Note that in the matrix, every entity should have at least one C, one R, one U, and one D entry for system completeness. If not, one or more processes may have been omitted. If that’s the case, and it probably is, add the missing processes to the CRUD matrix. For assistance, you may want to refer to the CRUD matrix online notes accessible through the ‘CRUD analysis’ link in week 8 of the online syllabus, reached from the IS315 402 Syllabus class line on my http://condor.depaul.edu/~jbernste web site, or by clicking CRUD Analysis here.