Week12LabW12Sol.docx

176 views3 pages
Using the sample report structure below perform the normalization exercise. Show the relations
first as an Un-normalized relation and then after each normalization stage i.e. 1st, 2nd and 3rd.
Document your relations as shown in the in class example. Using the final set of relations, draw
the equivalent Logical Data Model using Erwin.
An engineering consultancy firm supplies temporary specialized staff to bigger companies in the
country to work on contract for a certain amount of time. The table below lists the time spent on
contract by each of the company’s employees at other companies. The Social Insurance Number
(SIN) is unique for every member of staff.
SIN
Employee
Name
Employee
Join Date
Contract
No
Hours
Worked
Company
ID
Company
Name
Company
Location
616681
P. White
11/12/2009
SC1025
72
SC115
Acme
Belfast
SC1026
24
SC23
Balls
Dublin
SC1048
12
SC99
Peters Ltd
Belfast
SC1044
5
SC115
Acme
Belfast
323113
P. Smith
01/10/2006
SC1026
24
SC23
Balls
Dublin
SC1048
120
SC99
Peters Ltd
Belfast
SC1027
15
SC115
Acme
Belfast
674315
R. Press
05/09/2000
SC1025
48
SC115
Acme
Belfast
SC1044
12
SC115
Acme
Belfast
Unlock document

This preview shows page 1 of the document.
Unlock all 3 pages and 3 million more documents.

Already have an account? Log in

Get OneClass Grade+

Unlimited access to all notes and study guides.

Grade+All Inclusive
$10 USD/m
You will be charged $120 USD upfront and auto renewed at the end of each cycle. You may cancel anytime under Payment Settings. For more information, see our Terms and Privacy.
Payments are encrypted using 256-bit SSL. Powered by Stripe.