write my assignment 11798

Database: For each relation:

a) List Functional Dependencies.

b) Based on the given primary key, is the relation in 1NF, 2NF, or 3NF? Why or why not?


  • Attachment 1
  • Attachment 2

REMEMBER: The goal of normalization is to end up with tables in which theprimary key determines all non-key columns.For each relation:a) List Functional Dependencies.b) Based on the given primary key, is the relation in INF, 2NF, or 3NF? Why or why not?c) Normalize the relation successively into 3NF, if it is not already in 3NF.You may present the normalized relations using the kind of notation seen in the FACULTY or ORDER relations below,or you could use the kind of notation used when drawing relational schemas (e.g., with table headers).1. FACULTY(FacNo, FacName. DeptNo, DeptName, DeptLos, InsurPlanNo, InsurPlanDesc)2. ORDER(OrdNo, OrdDate, CustNo, PartNo, Qty, UnitPrice)3. Transform the following relation into 3NF:EMPLOYEE (Emp_ID, Name, Dept_Name, Salary, Course_Title, Date_Completed)The functional dependencies are:Emp_ID > Name, Dept Name, Salary(Emp_ID, Course_Title) > Date_Completed

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Comments are closed.

Hi there! Click one of our representatives below and we will get back to you as soon as possible.

Chat with us on WhatsApp