please work on laptop which i can see it clearly please ! SmartProjects Company
ID: 3879073 • Letter: P
Question
please work on laptop which i can see it clearly please !
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) – (c).
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,
Explanation / Answer
a)
All the entities would be:
b) Entities and attributes -
c) Outline all relationships between entities.
many depandants may belong to one employee - many to one
many employee may work on one project - many to one
one department can have many employees - one to many
one employee can only belong to one department - one to one
A department controls a number of projects and One project may belong to several departments. - many to many
One customer can submit only one project at one time - one to one
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.