Normalisation

Anonymous
timer Asked: Jan 6th, 2018
account_balance_wallet $30

Question description

Task

Table 1: GRADE REPORT relation

Student_IDStudent_NameCampus_AddressMajorCourse_IDCourse_titleInstructor_NameInstructor_LocationGrade
16830058WilliamsAlburyBITITC114Database SysPeterB104HD
16830058WilliamsAlburyBITITC211Sys AnalysisJohnB115D
543291073BakerWaggaAcctITC200Database MgtDavidH310D
543291073BakerWaggaAcctAcc11Fund AcctWilliamA120C
543291073BakerWaggaAcctMkg21Intro MktMikeA112P

Using above table

1. Draw a dependency diagram to show the functional dependencies in the relation
2. Decompose the GRADE REPORT relation into a set of 3NF relations
3. Draw a relational schema for your 3NF relations and show the referential integrity constraints

NOTE

For 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.

Rationale

This assessment aligns with the following subject outcomes:

  • be able to analyse a database design and apply normalisation theory and techniques

Marking criteria

Each task is worth 5 marks. The marking criteria for this assignment is:

TaskHDDICRPS
Draw 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 dependencies
Decompose 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 attributes
Draw 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 constraints

Requirements

Either save your diagrams in a PDF file or embed them in a Word document.

Don't use any other file formats

Tutor Answer

criss53
School: UC Berkeley

Hello, here is your assingment. Please check it. I check your video and I add the necessary data.If you need changes contact me.

1

Running head: Normalization

Normalization
Your Name
Course Number – Name of Course
University Name
Instructor’s Name
January 6, 2018

2

Normalization
Normalization
Student_ID Student_N a m e Ca m pus _Addres s Ma j or Cours e_ID Cours e_ti tl e

Ins tructor_N a m e

Ins truc...

flag Report DMCA
Review

Anonymous
Outstanding Job!!!!

Similar Questions
Hot Questions
Related Tags

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors