Your relational modelshould be logical,should reflect strong understanding of the overallfunctionofyourdatabase,andmustcomply with eachofthe requirementslaidout in theERD.

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

Are you looking for a similar paper or any other quality academic essay? Then look no further. Our research paper writing service is what you require. Our team of experienced writers is on standby to deliver to you an original paper as per your specified instructions with zero plagiarism guaranteed. This is the perfect way you can prepare your own unique academic paper and score the grades you deserve.

Use the order calculator below and get started! Contact our live support team for any assistance or inquiry.