Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

A company wants to make a database system that will assist with tracking employees. Information must be kept on all the offices and employees that

image text in transcribed

A company wants to make a database system that will assist with tracking employees. Information must be kept on all the offices and employees that will be working at each office and their clients. Additionally, information about supervisors must be kept in each office. Draw a data model that meets the following descriptions. Required entities: Office, Employee, Supervisor, and Client. Required attributes: Office: Office ID number, Office name, and Office motto. Employee: Employee ID number, Employee first name. Employee last name, and Employee age. Supervisor: Supervisor ID number, Supervisor first name, Supervisor last name, and Supervisor home phone number. Client: Client ID number, Client last name, Client first name, Client phone number, and Client Address (Street, City, State, and ZIP Code). The listed relationships have to be defined: Office is related to Employee. Office is related to Supervisor. Employee is related to Client. The following connectivity's and participations are defined: An Office may or may not have an Employee. An Employee must have an Office. An Office may have many Employees. An Employee has only one Office. An Office may or may not have a Supervisor. A Supervisor must have an Office. An Office may have many Supervisors. A Supervisor has only one Office. An Employee must have a Client. A Client must have an Employee. An Employee may have many Clients. A Client may have many Employees

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

Beyond Big Data Using Social MDM To Drive Deep Customer Insight

Authors: Martin Oberhofer, Eberhard Hechler

1st Edition

0133509796, 9780133509793

More Books

Students also viewed these Databases questions