SmartProjects Company is planning to design a data model to hold information relating to their projects, employees working on company projects, and their customers. SmartProjects IT Manager provided the following business rules to the software developer:

Complete the information-level design for the database that satisfies the above constraints and user view requirements. In order to complete this information-level design you are required to answer the questions given below 1(a) (e).

User view 1 requirement: Each employee has a unique ID number, and their first name, last name, date of birth, address, contactNo user name and password must be recorded. There is a need to keep track of the dependents of each employee for insurance purposes.

User view 2 requirements: Each customer has a unique customer_number and their first name, last name, address, PNum, project tile and payment must be recorded.

User view 3 requirements: Each project has a project number that uniquely identifies the project (PNum) and project title, StartDate, managerID, managerName,managerContactNo must be recorded.

User view 4 requirements: An employee can work on only one project. A project can have one or more employees associated with it.

User view 5 requirements: Each department has a unique ID number and name. A department can have many employees. An employee can only work in one department. A department controls a number of projects.

User view 6 requirements: One project may belong to several departments. One customer can submit only one project at one time.

a. Analyse all the user requirements given above; identify and list all entities described in each user requirement.

b. Add attributes to these entities and represent these entities (or tables) and attributes as a collection of tables and attributes. You are required to arrange them as given in the example below.

NB: Select a suitable primary key for each table and underline them.

E.g., Customer (CustomerID, name,.

c. Outline all relationships between entities.

E.g., One project may belong to several departments - One-to-many,