Design Of Database Course

Save Answer Question 9 25 points The goal is to build a highly simplified toy prototype database to partially support the operation of a simple engineering company (SEC). Provide an ER diagram to capture and model the partial requirements below. You should list the entities, their attributes, and relationships (with names and cardinalities). Identify the primary keys of the entities when appropriate. Keep your model simple. You may use ER-Assistant to create the ER model and then capture the ER diagram and submit the image file. Alternatively, you may create the ER model in a piece of paper, and then scan, and submit the scanned file, which may be a PDF file or an image file. The company SEC has employees, with names, employee ids, and phones. There are many units in the company. Each unit may be a subunit of another unit, known as its parent unit. A unit has a name, office, and phone. Each unit may have a head, who manages the unit. Each unit may also have a vice-head, who assists the head to manage the unit. Besides the head and the vice head, a unit may have no other employee. An employee can only work for one unit, including as its head, or as its vice-head. However, an employee may not yet be assigned to any unit. There are many engineering projects. A project has a name and description. Many units may work on the same project, but there is always a lead unit. Many employees can work on a specific project. Usually, there is a project leader. The project leader may not be working directly for the leading unit, however