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

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!