preview

dbs201

Better Essays
DBS201 Assignment 2 Due Friday, April 04th by midnight 10% of final mark Your group must consist of 2 or 3 people You will develop a logical database design for the following description shown later (Page 3 etc). Submissions done by a single person will receive a 20% penalty. Required for submission: One: (60 marks) Printed 3NF solution for each user view in this assignment a) You are to show each step in your solution: UNF, 1NF, 2NF, 3NF . b) You are to clearly mark Primary and Foreign Keys as shown in the sample below: Entity1[ column1 (PK), column2, column3, column4…show more content…
Employee[employeePK, skill, skill hourly rate, date] Invoice_Equip[equipmentPK, invoiceFK, date, total hours, charge] Equip[equipmentPK, hourly rate] 3NF: Invoice[invoicePK, customerFK, projectFK, invoice date] Customer[customerPK, name, address] Project[projectPK, projectName, projectType, location] Invoice_Employee[invoiceFK, employeePK, date, hrs] Employee[employeePK, skill, skill hourly rate, date] Invoice_Equip[equipmentPK, invoiceFK, date, total hours, charge] Equip[equipmentPK, hourly rate] Question 2: UNF: Project[ProjectPK, projectName, (employeePK, name, years in company)] 1NF: Project[ProjectPK, projectName] Project_Employee[ProjectFK, employeePK, name, years in company] 2NF: Project[projectPK, projectName, projectType, location] Employee[employeePK, name] Project_Employee[employeePK, projectPK] 3NF: Same as above Question 3: UNF: Employee[employeePK, name, phone, (benefitNum, benefit) date] 1NF: Employee_Benefit[employeePK, benefitNum, benefit] Employee[employeePK, name, phone, date] 2NF: Employee_Benefit[employeePK, benefitPK] Benefit[benefitPK, benefit] Employee[employeePK, name, phone, date] 3NF: Same as above Question 4: UNF: custByGroup[custTypePK, custType, custSub(custername, phone, fax)] 1NF: custByGroup[custTypePK, custType, custSub] custByGroup_customer[custTypePK, customerPK, name, phone, fax] 2NF: custByGroup[custTypePK, custType, custSub]
Get Access