Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started