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

Transcribed Image Text:

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 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

Answer rating: 100% (QA)

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 the full answer