1 / 6

Tutorial 8 : Normalization

Tutorial 8 : Normalization. Question 1. Consider the following relation definition and sample data : PROJECT (ProjectID, EmployeeName, EmployeeSalary) ProjectID: name of a work project EmployeeName: name of an employee EmployeeSalary: salary of the employee.

sun
Download Presentation

Tutorial 8 : Normalization

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Tutorial 8: Normalization

  2. Question 1 Consider the following relation definition and sample data: PROJECT (ProjectID, EmployeeName, EmployeeSalary) • ProjectID: name of a work project • EmployeeName: name of an employee • EmployeeSalary: salary of the employee

  3. Assuming that all of the functional dependencies and constraints are apparent in this data, which of the following statements is true? • ProjectID  EmpName • ProjectID  EmpSalary • (ProjectID, EmpName)  EmpSalary • EmpName  EmpSalary • EmpSalary  ProjectID • EmpSalary  (ProjectID, EmpName) • What’s the primary key? • In what normal form is PROJECT? • Redesign this relation to get it into 3NF.

  4. Question 2 • Consider R = {A, B, C, D, E, F, G, H} with a set of FDs • F = {CD→A, EC→H, GHB→AB, C→D, EG→A, H→B, BE→CD, EC→B} Is R w.r.t. F in 3NF?

  5. Question 3 • Consider R = {A, B, C, D} with a set of FDs • F = {AB→CD, D→B, C→A} Is R w.r.t. F in 3NF?

  6. Question 4 • Consider R = {A, B, C, D, E, F, G, H} with a set of FDs F = {CD→A, EC→H, GHB→AB, C→D, EG→A, H→B, BE→CD, EC→B} The candidate keys are: {BEFG, CEFG, EFGH} • Decompose R into relations in 3NF.

More Related