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
Astronomer
milestone_two_guidelines_rubric.docx
0
