# Normalisation

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

Question description

Table 1: GRADE REPORT relation

 Student_ID Student_Name Campus_Address Major Course_ID Course_title Instructor_Name Instructor_Location Grade 16830058 Williams Albury BIT ITC114 Database Sys Peter B104 HD 16830058 Williams Albury BIT ITC211 Sys Analysis John B115 D 543291073 Baker Wagga Acct ITC200 Database Mgt David H310 D 543291073 Baker Wagga Acct Acc11 Fund Acct William A120 C 543291073 Baker Wagga Acct Mkg21 Intro Mkt Mike A112 P

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:

 Task HD DI CR PS Draw a dependency diagram to show the functional dependencies in the relation The dependency diagram accurately identifies and correctly shows all PKs and all functional, partial, and transitive dependencies The dependency diagram accurately identifies and correctly shows all PKs and most functional, partial, and transitive dependencies The dependency diagram identifies and shows most PKs and some functional, partial, and transitive dependencies The dependency diagram identifies and shows few PKs and few functional, partial, and transitive dependencies Decompose GRADE REPORT into a set of 3NF relations The set of 3NF relations accurately identifies and correctly shows all PKs and all the relevant attributes The set of 3NF relations accurately identifies and correctly shows all PKs and most of the relevant attributes The set of 3NF relations identifies and shows most PKs and some of the relevant attributes The 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 constraints The relational schema accurately identifies and correctly shows all of the referential integrity constraints The relational schema accurately identifies and correctly shows most of the referential integrity constraints The relational schema identifies and shows some of the referential integrity constraints The 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

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

Normalization
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!!!!

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