Milestone 2 & final

IT 330 Milestone Two Guidelines and Rubric

In Module Four, submit a systems analysis for your project, including a comprehensive entity-relationship diagram (ERD). Although you may use any tool to complete the ERD, it is strongly recommended that you use Microsoft Visio and then save the diagram into an image format (GIF or JPG) and then copy and paste the image into your systems analysis.

All sections of this milestone should be compiled into a single Word document. Furthermore, all of Milestone One should be included in Milestone Two. This milestone will be graded using the Milestone Two Rubric (below). The milestone should include the following:

· A comprehensive entity-relationship diagram (ERD)

· This must include an appropriate set of attributes for each entity.

· A relational model

· Your relational model should be logical, should reflect strong understanding of the overall function of your database, and must comply with each of the requirements laid out in the ERD.

· A functional dependencies diagram normalized into 3NF

· Based upon the ERD you create, devise dependency diagrams and normalize the data into 3NF.

· This step will require you to compile a collective list of all the functional dependencies in order to create the model.

· The data in this section must reflect the list of functional dependencies and must be accurately normalized into 3NF.

· A functional relational schema normalized into 3NF

· Based upon the ERD and the dependency diagrams, create the relational schema and normalize the data into 3NF.

· A list of proposed queries

· Based on the six questions that most concern the bookstore owners, develop a single query that will answer each question