Answered step by step
Verified Expert Solution
Link Copied!

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,

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems Design Implementation And Management

Authors: Peter Rob, Carlos Coronel

6th International Edition

061921323X, 978-0619213237

More Books

Students also viewed these Databases questions