nal ModeVEERD Develop an ER/EER model for the Morehead, Inc. database based on the scenario below. If you discover while drawing the diagram that the scenario is incomplete, make up reasonable explanations to complete the story. Supply your explanations along with the diagram. Note The Relational ModelEERD should be fully specified with (you may refer Figure 4.35 and Figure 5.4): o Entities and Supertype/Subtype entities: The proper number of entities and their name o All needed attributes of each entity o Primary key and Foreign key o Relationship Max. and Min. connectivities (cardinalities): If needed, you can put your justifications on your answer document about why you use the connectivity (cardinality) " Make sure that each M:N relationship should be decomposed into two 1:M relationships Description (text) of relationship between entities (e.g., takes, advises, has, etc. in Figure 4.35) The correct number of relationships between entities o Subtype discriminators In drawing the model, use Crow's foot model (notation) In drawing the diagram, you can use any (diagraming) software, such as Draw.io, Microsoft Visio, LucidChart, or even Microsoft Word. Copy and paste the diagram to Microsoft Word or convert them PDF and Submit the Word file or PDF file o Include diagram ONLY, not entire software screen o Your submission should be readable (Scenario) Morehead, Inc., a factory manufacturing automobile parts, wants to implement a database to manage its data. Your task is to design the database to capture the data specifications through the ER/EER modeling. The factory has several departments. A department may have many employees, but at least three. Every employee works for one and only one department. Every department has a manager - only one manager per department. Clearly, a manager is an employee of the company; but, all employees are not managers. A department may have many machines, and every machine is assigned to a specific department