Answered step by step
Verified Expert Solution
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
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
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