10 Marks DFC 20123 DATABASE DESIGN Page 34 of 60 LAB ACTIVITY 4 Entity

10 marks dfc 20123 database design page 34 of 60 lab

This preview shows page 7 - 11 out of 12 pages.

(10 Marks)
Image of page 7
DFC 20123 DATABASE DESIGN Page 34 of 60 LAB ACTIVITY 4: Entity Relationship (ER) Model & Normalization – Part 3 Duration: 4 Hours Learning Outcomes This activity encompasses activities 4F, 4G, 4H, 4I and 4J. At the end of this activity session, you should be able to: 1. Understand normalization in database. 2. Understand Functional and Transitive dependencies 3. Construct normalization from 1NF until 3NF. Activity 4F Activity Outcome : Understand normalization in database. Fill in the appropriate terms for normalization in database based on the following statements. 1. ______________________ is a 2 dimensional table with columns and row. 2. 2 problems in relational data model are _______________________________ and ______________________________________. 3. 3 types of anomalies are _________________________, _________ ______________ and ______________________________. 4. ___________________________ is a process for assigning into a table and reduces data redundancy and helps eliminate the data anomalies. 5. ________________________ is a table that contains one or more repeating groups. 6. 3 level of normalization are _______________________, _______________________ and _____________________________. 7. ________________________ is a relation in which based on the concept of transitive dependency. 8. In the _____________ normal form, a composite attribute is converted to individual attribute
Image of page 8
DFC 20123 DATABASE DESIGN Page 35 of 60 Activity 4G Activity Outcome : Understand functional and transitive dependencies in database normalization. Consider the following relation definition and sample data: PROJECT ProjectID EmployeeName EmployeeSalary 100A Jamilah 1500 100A Samad 2000 100B Samad 2000 200A Jamilah 1500 200B Jamilah 1500 200C Affendi 2500 200C Samad 2000 200D Affendi 2500 PROJECT (ProjectID, EmployeeName, EmployeeSalary) Where ProjectID is the name of a work project. EmployeeName is the name of an employee who works on that project. EmployeeSalary is the salary of the employee whose name is EmployeeName. Assuming that all of the functional dependencies and constraints are apparent in this data, which of the following statements is true? ProjectID EmployeeName ProjectID_ EmployeeSalary (ProjectID, EmployeeName) EmployeeSalary EmployeeName EmployeeSalary EmployeeSalary ProjectID EmployeeSalary (ProjectID, EmployeeName) Answer these questions: a) What is a key for PROJECT? b) Are all non-key attributes dependent on the entire key? c) In what normal form is PROJECT? d) Describe two modification anomalies from which PROJECT suffers.
Image of page 9
DFC 20123 DATABASE DESIGN Page 36 of 60 Activity 4H Activity Outcome: Construct normalization process (UNF – 3NF) based on the given scenario. SCENARIO Success Software Co., a software contract and consultancy firm maintains details of all the various projects in which its employees are currently involved. These details comprise: Employee Number Employee Name Date of Birth Department Code
Image of page 10
Image of page 11

You've reached the end of your free preview.

Want to read all 12 pages?

  • Spring '20
  • Relational model, Database normalization, Infinity Design Solution Sdn, Success Software Co.

What students are saying

  • Left Quote Icon

    As a current student on this bumpy collegiate pathway, I stumbled upon Course Hero, where I can find study resources for nearly all my courses, get online help from tutors 24/7, and even share my old projects, papers, and lecture notes with other students.

    Student Picture

    Kiran Temple University Fox School of Business ‘17, Course Hero Intern

  • Left Quote Icon

    I cannot even describe how much Course Hero helped me this summer. It’s truly become something I can always rely on and help me. In the end, I was not only able to survive summer classes, but I was able to thrive thanks to Course Hero.

    Student Picture

    Dana University of Pennsylvania ‘17, Course Hero Intern

  • Left Quote Icon

    The ability to access any university’s resources through Course Hero proved invaluable in my case. I was behind on Tulane coursework and actually used UCLA’s materials to help me move forward and get everything together on time.

    Student Picture

    Jill Tulane University ‘16, Course Hero Intern

Stuck? We have tutors online 24/7 who can help you get unstuck.
A+ icon
Ask Expert Tutors You can ask You can ask You can ask (will expire )
Answers in as fast as 15 minutes
A+ icon
Ask Expert Tutors