Expert answer:Normalisation

Expert answer:TaskTable 1: GRADE REPORT relationStudent_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGrade16830058WilliamsAlburyBITITC114Database SysPeterB104HD16830058WilliamsAlburyBITITC211Sys AnalysisJohnB115D543291073BakerWaggaAcctITC200Database MgtDavidH310D543291073BakerWaggaAcctAcc11Fund AcctWilliamA120C543291073BakerWaggaAcctMkg21Intro MktMikeA112PUsing above table1. Draw a dependency diagram to show the functional dependencies in the relation 2. Decompose the GRADE REPORT relation into a set of 3NF relations3. Draw a relational schema for your 3NF relations and show the referential integrity constraintsNOTEFor guidance on how to normalise database relations from a dependency diagram, watch this very short YouTube video: Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable. RationaleThis assessment aligns with the following subject outcomes:be able to analyse a database design and apply normalisation theory and techniquesMarking criteriaEach task is worth 5 marks. The marking criteria for this assignment is: TaskHDDICRPSDraw a dependency diagram to show the functional dependencies in the relationThe dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependenciesThe dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependenciesThe dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependenciesThe dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependenciesDecompose GRADE REPORT into a set of 3NF relationsThe set of 3NF relations accurately identifies and correctly shows all PKs and all the relevant attributesThe set of 3NF relations accurately identifies and correctly shows all PKs and most of the relevant attributesThe set of 3NF relations identifies and shows most PKs and some of the relevant attributesThe set of 3NF relations identifies and shows few PKs and few of the relevant attributesDraw a relational schema for your 3NF relations and show the referential integrity constraintsThe relational schema accurately identifies and correctly shows all of the referential integrity constraintsThe relational schema accurately identifies and correctly shows most of the referential integrity constraintsThe relational schema identifies and shows some of the referential integrity constraintsThe relational schema identifies and shows few of the referential integrity constraintsRequirementsEither save your diagrams in a PDF file or embed them in a Word document.Don’t use any other file formats

How it works

1. Paste your instructions in the instructions box. You can also attach an instructions file
2. Select the writer category, deadline, education level and review the instructions 
3. Make a payment for the order to be assignment to a writer
4.  Download the paper after the writer uploads it 

Will the writer plagiarize my essay?

You will get a plagiarism-free paper and you can get an originality report upon request.

Is this service safe?

All the personal information is confidential and we have 100% safe payment methods. We also guarantee good grades