Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Systems For Advanced Applications 9th International Conference Dasfaa 2004 Jeju Island Korea March 2004 Proceedings Lncs 2973

Authors: YoonJoon Lee ,Jianzhong Li ,Kyu-Young Whang

2004th Edition

3540210474, 978-3540210474

More Books

Students also viewed these Databases questions

Question

What is the purpose of depreciating non current assets?

Answered: 1 week ago

Question

Networking is a two-way street. Discuss this statement.

Answered: 1 week ago