Question: 1. Draw an ER diagram based on the following database requirements as provided by a company a. For each employee, the company would like to

1. Draw an ER diagram based on the following database requirements as provided by a company a. For each employee, the company would like to keep track of the employee's employee number, name, identity card number, gender, qualification and salary i. Employee number is unique for each employee ii. An employee's name consists of last name, middle name and first name iii. Identity card number is unique for each employee iv. An employee may have more than one qualification b. For each department, the company would like to keep track of the department's department number, name and main office i. Department number is unique for each department C. For each project, the company would like to keep track of the project's project number and name i. Project number is unique for each project d. Employees belong to departments i. An employee must belong to exactly one department ii. A department must have at least one employee e. Employees work on projects i. An employee must work on at least one project ii. Each project must be worked on by at least one employee f. Departments own projects i. A department may own zero or more projects ii. Each project must be owned by one department
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
