Practice Problem #1 Normalize the dataset into 3NF tables. Show the normalization steps for each dataset using the format provided in the example. Example) 1NF: PROJECT (ProjectNum, Proj_Name, Start_Date, Emp_Num, Emp_Name, Job_Class) 2NF: PROJECT (ProjectNum, Proj_Name, Start_Date) EMP(Emp_Num, Emp_Name, Job_Class) 3NF: PROJECT (ProjectNum, Proj_Name, Start_Date) EMP(Emp_Num, Emp_Name, Job_Class) ** Bold and underline the primary key
Practice Problem #1
Normalize the dataset into 3NF tables. Show the normalization steps for each dataset using the format provided in the example.
Example)
1NF:
PROJECT (ProjectNum, Proj_Name, Start_Date, Emp_Num, Emp_Name, Job_Class)
2NF:
PROJECT (ProjectNum, Proj_Name, Start_Date)
EMP(Emp_Num, Emp_Name, Job_Class)
3NF:
PROJECT (ProjectNum, Proj_Name, Start_Date)
EMP(Emp_Num, Emp_Name, Job_Class)
** Bold and underline the primary key
DATA SET #1:
1NF:
STUDENT(Stu_Num, Stu_Lname, Stu_Major,Dept_Code,Dept_Name,Dept_phone,College_Name, Advisor_Lname, Advisor_Office, Advisor_Bldg, Advisor_Phone, Stu_Gpa, Stu_Hours, Stu_Class)
2NF:
STUDENT(Stu_Num, Stu_Lname, Stu_Major,Dept_Code, Advisor_Lname, Stu_Gpa, Stu_Hours, Stu_Class)
DEPT(Dept_Code,Dept_Name,Dept_phone,College_Name)
ADVISOR(Advisor_Lname, Advisor_Office, Advisor_Bldg, Advisor_Phone)
3NF:
STUDENT(Stu_Num, Stu_Lname, Stu_Major,Dept_Code, Advisor_Lname, Stu_Gpa, Stu_Hours, Stu_Class)
DEPT(Dept_Code,Dept_Name,Dept_phone,College_Name)
ADVISOR(Advisor_Lname, Advisor_Office, Advisor_Bldg, Advisor_Phone)
Step by step
Solved in 3 steps
