Question: Develop an ER/EER model for the Roberts Inc. database based on the scenario below. If you discover while drawing the diagram that the scenario is

Develop an ER/EER model for the Roberts 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 diagranm Note . The ERD/EERD 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. connectivity's (cardinalities): If needed, you can put your Make sure that each MN relationship should be decomposed into two 1:M Description (text) of relationship between entities (e.g., takes, advises, has, etc. in Figure The correct number of relationships between entities justifications on your answer document about why you use the connectivity (cardinality) relationships . o Disjoint/overlapping constraints o Subtype discriminators o Partial/total completeness 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. (Scenario) Roberts, 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. Products are produced on machines. Every product goes through one or more machines for appropriate production operations. Likewise, several products may go through a particular
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
