Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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
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