Question: Consider, a relation Employees, which contains information about workers and their salaries. Employees ID D13 D14 D25 D23 D04 D03 D02 D01 Yearsin Service

Consider, a relation Employees, which contains information about workers and their salaries. Employees ID D13

Consider, a relation Employees, which contains information about workers and their salaries. Employees ID D13 D14 D25 D23 D04 D03 D02 D01 Yearsin Service 2 3 Name W. Ganim A. Fry O. Lal 3 V. Kotlar 5 A. Randall 5 R. Fry 5 M. Singh 8 M. Singh 8 Role Programmer 25,000 Programmer 27,000 Programmer 27,000 Salary Programmer 34,000 Programmer 34,000 Programmer 34,000 Programmer 41,000 Analyst 43,000 In this organization, the salary of an employee depends entirely on their role and number of years in service, we should be able to predict it from them. 1. List all the attributes in this relation using relation listing method. 2. Identify, if there is any duplicate/redundant information and write them in parenthesis 3. Normalize to NF3 level 4. Define the relationships and draw the ERD diagram 5. Write the SQL commands to implement the design

Step by Step Solution

3.49 Rating (152 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

1 List all the attributes in this relation using relation listing method To list the attributes of the relation we examine the columns of the table wh... View full answer

blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!