please work on laptop which i can see it clearly please ! SmartProjects Company
ID: 3879431 • 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
Answer a:
As per the requirement, following are the list of entities that are going to be used in building "SmartProjects" DB:
Answer b:
Following are the table and attribute details for "SmartProjects" DB:
NOTE: Attribute marked as underline are the primary key for each tables.
Answer c:
Following are the relationship details for the tables:
1. An employee can work only on one project .So,
3. An employee can work only on one department. So,
5. A project can be operating in several departments. So,
***************************************************************************************
Please rate the solution if you like it.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.