Question: Normalize the below tables up to 3rd normal form. Example 1 : Grade_report(StudNo, StudName, Major,Advisor CourseNo.Ctitle. InstrucName InstructLo cn. Grade) Example 2 : WORK (projName,

Normalize the below tables up to 3rd normal form. Example 1 : Grade_report(StudNo, StudName, Major,Advisor CourseNo.Ctitle. InstrucName InstructLo cn. Grade) Example 2 : WORK (projName, projMgr, empId, hours, empNamel budget, startDate, salary, empMgr, empDept, rating) 1- Each project has a unique name, but names of employees and managers are not unique. 2- Each project has one manager, whose name is stored in projMgr 3. Many employees may be assigned to work on each project, and an employee may be assigned to more than one project. The attribute 'hours' tells the number of hours per week that a particular employee is assigned to work on a particular project. 4- Budget stores the budget allocated for a project and startDate stores the starting date of a project 5. Salary gives the annual salary of the employee 6- empMgr gives the name of the employee's manager, who is not the same as project manager. 7- empDept give the employee's department. Department names are unique. The employee's manager is the manager of the employee's department 8- Rating give the employee's rating for a particular project. The project manager assigns the rating at the end of employee's work on that project
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
