You are dispatched as a consultant for xyz company to


Introduction

You are dispatched as a consultant for XYZ Company to create a database for their applications. Since this is just an initial analysis, they just want you to create a conceptual design of the database. One of the business analysts of the company toldyou of how the system works:
"We have employees all over the United States. Each employee has first name, last name, age, job history, email, and phone number in our records and we need to keep track on them. We just want to see the concept of the design for now. Anyway, our problem is we don't have an employment history on any of them, so we ask you to incorporate your design to keep track on them too. We need to keep track on the start date, end date, job id, and department id.Lastly, we want you to include the supervisors' profiles which include id, first name, last name and employees that are assigned to supervisors. Our supervisors have assigned employees already and employees must belong to one and only one supervisors. We don't want to see the details of the design. Create a conceptual diagram for us and submit as soon as possible so that we can review it."

Conceptual Design

Note: Submit the design using MySQL Workbench or Oracle Modeler along with the DDL.

 

Request for Solution File

Ask an Expert for Answer!!
PL-SQL Programming: You are dispatched as a consultant for xyz company to
Reference No:- TGS02317853

Expected delivery within 24 Hours