SmartProjects Company is planning to design a data model to hold information relating to their projects, employees working on company projects and their customers. Complete the information-level design for the database that satisfies the following constraints and user view requirements. In order to complete this information evel design you are required to answer the questions given below 1(a) (f) User view 1 requirement Each employee has a unique ID number, first name, last name, date of birth, address, Department name, Department ID, Project Number(PNum), user name and password An employee can work on only one project. User view 2 requirements Each customer has a unique Cust number, first name, last name, address and Payment. One customer can submit only one project at one time. User view 3 requirements: Each project has a project number that uniquely identifies the project (PNum), title, StartDate, managerEmpNum and managerEmpName. A project can have one or more employees associated with it. One project may belong to several departments. User view 4 requirements: Each department has a unique ID number, name and a Dept. Manager A Department can have many employees. An employee can only work in one department. A department controls number of projects. Construct User Views as a collection of Tables. Select Primary keys for each table and underline a. (5 Marks) b. Outline the relationships between entities (Tables). Here you are required to examine the entities you identified in 1(a) and briefly describe the relationships between those entities. (Eg. One-to-many, many-to-one) (5 Marks) C. Normalise the tables that may have duplicate records in your database design. (10 Marks) d. Develop the structure of your database visually by using the entity-relationship (E-R) diagram (10 Marks)