(Solved) : Created Table Employee Empid Firstname Lastname Dob Address Contactno Username Password De Q26380574 . . .
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 havemany employees.
One employee belongs to only one department and a department canhave many employees.
One project may belongs to many departments and one departmentcan 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. Show transcribed image text
Expert Answer
Answer to Created Table Employee Empid Firstname Lastname Dob Address Contactno Username Password De Q26380574 . . .
OR