90.2K

Verified Solution

Link Copied!

Page 2 of 4 EMPLOYEES (EMP CODE, EMP_NAME, EMP_HIREDATE, JOB_CODE, JOB_TITLE, JOB_STARTING_SALARY, EMP_SALARY, DEPARTMENT_CODE, DEPT_NAME, DEPT_PHONE, QUALIFICATION_CODE, QUAL_DESCRIPTION, DATE_QUAL_EARNED) Thulasizwe Inc. is an Engineering Company with approximately 700 employees. A database is required to keep track of all Employees, the Department they work for, their qualifications, job description and information of their dependents a) Each Employee has a unique Employee Code assigned by the Company. It is required to store the Employees name and hire date. Each employee has a job title. b) An Employee can have only one job title at a time and each Job has a unique Job Code. Each Job has a Starting Salary. It is also required to store the Employees Salary. The Employees Salary may differ from the Starting Salary for the Job the Employee is appointed for C) There are 11 different Departments each with a unique Department code. An Employee report to only one Department. Each Department has a name and a phone number. d) An Employee can have more than one Qualifications. There can also be more than one Employee that has the same Qualification. The date the Employee has earned their Qualification is needed. e) For a Qualification the unique Qualification Code and Qualification Description is needed 1.1 Given the information ABOVE convert the EMPLOYEES TABLE to 1NF. Write the relational schema. Make sure that you label the transitive and/or partial dependencies. (14) 1.2. Using the answer to 1.1, create the relational schemas that meet 2NF requirements. Rename attributes to meet the naming conventions and create new attributes as necessary (10) 1.3. Using the answer to 1.2, create the relational schemas that meet 3NF requirements. Rename attributes to meet the naming conventions and create new attributes as necessary. (6) What Assessor's Signature Moderator's Signature: Page 2 of 4 EMPLOYEES (EMP CODE, EMP_NAME, EMP_HIREDATE, JOB_CODE, JOB_TITLE, JOB_STARTING_SALARY, EMP_SALARY, DEPARTMENT_CODE, DEPT_NAME, DEPT_PHONE, QUALIFICATION_CODE, QUAL_DESCRIPTION, DATE_QUAL_EARNED) Thulasizwe Inc. is an Engineering Company with approximately 700 employees. A database is required to keep track of all Employees, the Department they work for, their qualifications, job description and information of their dependents a) Each Employee has a unique Employee Code assigned by the Company. It is required to store the Employees name and hire date. Each employee has a job title. b) An Employee can have only one job title at a time and each Job has a unique Job Code. Each Job has a Starting Salary. It is also required to store the Employees Salary. The Employees Salary may differ from the Starting Salary for the Job the Employee is appointed for C) There are 11 different Departments each with a unique Department code. An Employee report to only one Department. Each Department has a name and a phone number. d) An Employee can have more than one Qualifications. There can also be more than one Employee that has the same Qualification. The date the Employee has earned their Qualification is needed. e) For a Qualification the unique Qualification Code and Qualification Description is needed 1.1 Given the information ABOVE convert the EMPLOYEES TABLE to 1NF. Write the relational schema. Make sure that you label the transitive and/or partial dependencies. (14) 1.2. Using the answer to 1.1, create the relational schemas that meet 2NF requirements. Rename attributes to meet the naming conventions and create new attributes as necessary (10) 1.3. Using the answer to 1.2, create the relational schemas that meet 3NF requirements. Rename attributes to meet the naming conventions and create new attributes as necessary. (6) What Assessor's Signature Moderator's Signature

Answer & Explanation Solved by verified expert

See Answer