i created table below

Employee (emp_id, first_name, last_name, dob, address, contactNo, username, password)

Dependent (dependent_id, name, relation, age, emp_id)

Customer (customer_id, first_name, last_name, address)

Project (PNum, title, startDate, managerID, managerName, managerContactNo, customer_id)

Project_Assignment (PNum, emp_id)

Department (dept_id, name)

Emp_dept (dept_id, emp_id)

Dept_proj (dept_id, PNum)

The relationships between entities is given below-

One Employee can have many Dependent.

One customer submits only one project at a time.

One employee is assigned only one project but a project can have many employees.

One employee belongs to only one department and a department can have many employees.

One project may belongs to many departments and one department can have many projects.

the question is

SmactPreiests 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: 1. 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, SSOtact user name and password must be recorded. There is a need to keeptrack of the dependents of each employee for insurance purposes. User view 2 requirements: Each customer has a unique customer.oumber 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,manaemanagerNaemaagerContactNo 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