Question
please use laptop ,i want to know how to work on laptop please . SmartProjects Company is planning to design a data model to hold
please use laptop ,i want to know how to work on laptop 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
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 timAe.
A. Determine the functional dependences.
E.g., CustomerID name, address, ......
B. Then normalise these tables. Make the normalization to 3NF. State for every step in the
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started