Sukhisingh Essay

649 Words Jun 1st, 2015 3 Pages
Faculty of Science and Technology
ITECH1006/5006
Database Management Systems
Database Management Systems
Tutorial Week 3
Tasks
1. Given the following table, convert the table into normalised data structure showing all attributes and identifying primary keys. Show your normalisation process from the un-normalised form to the third normal form.

2. Given the following table, convert the above table into normalized data structures showing all attributes and identifying primary keys. Show your normalisation process from the un-normalised form to the third normal form.
Customer
Number
148

148

282
356
356
408

608

608

608

Customer
Name
AI’s
Appliance
and Sport
AI’s
Appliance and Sport
Brookings
Direct
…show more content…
131-323

13 Luck Rd

14 Jan

Gizmo

120

F. Nurk Inc.

666-999

11 Bushy Ave

Case 1:
 Each client makes no more than one order per day
 No two clients have the same name
 Each order consists of a single product
Case 2:
Assuming that in any single day,
 Clients sometimes make several orders
 Each order is for a different product
Case 3:
Assuming that that clients sometimes can order the same product several times in a single day.
4. Given the following table and the following business documentation:



Each employee belongs to one department only.
An employee is assigned to at least one project and a project must have at least one employee. a) Convert the table into normalized data structures showing all attributes and identifying primary keys.
b) Present your normalized relations as an ER diagram.
Employee No: 01267
Employee Name: Graham Clark
Employee Address: 12 Smith Street Richmond VIC 3456
Hire Date: 02/03/1980
Salary: 30,000
Project(s) assigned to:
Project no:
Project Start Date:
Marketing project
123
12/01/2002
Payroll project
175
13/06/2002
Leave: 03/03/1999 - 17/03/1999
15/12/1999 - 29/12/1999
Department No: 05
Department Name:
Department Location: MEL
Computing

CRICOS Provider No. 00103D

Page 2 of 3

5. For the following relations, determine what normal form each is

Related Documents