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.