Milestone 2 & final
AstronomerMS SQL ---
In Module Four, submit asystemsanalysisforyour project, including a comprehensiveentity-relationshipdiagram(ERD).Although youmayuse anytooltocomplete theERD, itis strongly recommended thatyou useMicrosoftVisioandthen save thediagramintoanimageformat(GIFor JPG) and thencopy andpaste the image into yoursystemsanalysis.
All sectionsof thismilestone shouldbecompiled intoa single Word document. Furthermore,allofMilestone Oneshouldbeincluded in MilestoneTwo.This milestonewill be graded using theMilestone Two Rubric(below). Themilestoneshouldincludethe following:
· A comprehensiveentity-relationship diagram(ERD)
o This must include an appropriate setof attributes foreach entity.
· A relationalmodel
o Your relational modelshould be logical,should reflect strong understanding of the overallfunctionofyourdatabase,andmustcomply with eachofthe requirementslaidout in theERD.
· A functional dependenciesdiagram normalized into 3NF
o Based uponthe ERD you create,devise dependency diagrams andnormalize thedata into3NF.
o This stepwill require you tocompile acollective listof all the functional dependencies inorderto createthemodel.
o The data inthis sectionmustreflect the listoffunctional dependenciesandmustbe accuratelynormalized into3NF.
· A functional relational schema normalized into 3NF
o Based uponthe ERD and the dependency diagrams, createthe relational schemaand normalize thedata into3NF.
· A listof proposed queries
o Basedon thesix questionsthatmost concernthe bookstoreowners, develop a single query that willanswereachquestion
- 8 years ago
- 30
Purchase the answer to view it
- milestone1.docx
- MHA 5001 Unit I Assessment
- Help with computer discussion homework
- PF 406203
- Discussion question accounting, 100 word minimum
- ACC 561 Week 3 Assignment and Quiz As Discussed
- << Strayer BUS 302 Week Strayer BUS 302 Quiz Week 1,2,3,5,6,8,9 Quiz >>
- 320 6
- Human Services ACADAMICK Only
- BTM8107-8 Week 5 Activity Apply ANCOVA & Factorial ANOVA Rated A++
- WEEK 5 PAPER FOR EXPERT_RESEARCHER ONLY