Information Technology > QUESTIONS & ANSWERS > DDB5321 DATABASE SYSTEMS TUTORIAL 4 FOR D16A - TOPIC 5: Normalisation 1. What is Normalisation? 2. W (All)

# 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

OR

OR

## Reviews( 0 )

### \$4.00

Can't find what you want? Try our AI powered Search

OR

191
0

### Document information

Connected school, study & course

Jan 17, 2023

Number of pages

11

Written in

#### Seller

##### PAPERS UNLIMITED™

Member since 1 year

471 Documents Sold

This document has been written for:

Jan 17, 2023

0

Views

191

## THE BEST STUDY GUIDES

Avoid resits and achieve higher grades with the best study guides, textbook notes, and class notes written by your fellow students

#### Avoid examination resits

Your fellow students know the appropriate material to use to deliver high quality content. With this great service and assistance from fellow students, you can become well prepared and avoid having to resits exams.

Your fellow student knows the best materials to research on and use. This guarantee you the best grades in your examination. Your fellow students use high quality materials, textbooks and notes to ensure high quality

Get paid by selling your notes and study materials to other students. Earn alot of cash and help other students in study by providing them with appropriate and high quality study materials.

\$4.00

## WHAT STUDENTS SAY ABOUT US

In Browsegrades, a student can earn by offering help to other student. Students can help other students with materials by upploading their notes and earn money.