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

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.