DDB5321 DATABASE SYSTEMS TUTORIAL 4 FOR D16A - TOPIC 5: Normalisation 1. What is Normalisation? 2. What is Denormalisation? 3. State the steps in each of the Normal Forms.

Document Content and Description Below

DDB5321 DATABASE SYSTEMS TUTORIAL 4 FOR D16A - TOPIC 5: Normalisation 1. What is Normalisation?  Evaluating and correcting table structures to minimize data redundancies and reduces data anomal... ies. Assigns attributes to tables based on determination 2. What is Denormalisation?  Produces a lower normal form. Results in increased performance and greater data redundancy 3. State the steps in each of the Normal Forms.  First Normal Form(1NF) - i. Eliminate the repeating groups. ii. Identify the primary key. iii. Identify all dependencies.  Second Normal Form(2NF) - i. Make new tables to eliminate partial dependencies. ii. Reassign corresponding dependent attributes.  Third Normal Form(3NF) - i. Make new tables to eliminate transitive dependencies. ii. Determinant: Any attribute whose value determines other values within a row. 4. Based on the following table, write the relational schema that meets 1NF, 2NF and 3NF requirements. You are also required to draw the dependency diagram for each normal form. TABLE 1: STUDENT RECORDS SAMPLE ATTRIBUTE NAME SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE SAMPLE VALUE Student_Number 1051105286 1052003815 105200520 0 105112879 6 Student_Name Julia Roberts Hans Isaac Paul Walker Julia Hana Major IT IT ENG IT Status Active Active Active Active Course_Number DCS5078 DCS5078 DTE6028 DBS5028 Course_Title Database Systems Database Systems Networking E- Commerce Term 3 6 3 6 Professor_Name Robert Robert Weller Shaari Professor_Department FIST FIST FET FBL Grade C+ B F B+  1NF STUDENT (Student_Number, Student_Name, Major, Status, Course_Number, Course_Title, Term, Professor_Name, Professor_Department, Grade) [Show More]

Last updated: 10 months ago

Preview 1 out of 11 pages