Question: Study the E-R diagram of Figure 1. Based on this E_R diagram, answer the following questions. a) How many PROJECTS can an employee work

Study the E-R diagram of Figure 1. Based on this E_R diagram,

answer the following questions. a) How many PROJECTS can an employee work 

 

Study the E-R diagram of Figure 1. Based on this E_R diagram, answer the following questions. a) How many PROJECTS can an employee work on? b) Can you think of some attributes that can be attached to the works on relationship? If yes, write the corresponding assumptions in a descriptive form. =) How else could the attribute Skill be modeled? d) Could TASK be modeled as an associative entity? Project ID EMPLOYEE Works_on PROJECT Employee ID Includes Skill TOOL Used_on TASK Task_ID Figure-1- Done_at CITY Time a) b) 5. For the entity-relationship diagram provided in Figure-2-, perform the following: Describe any assumption you must make about relevant business rules. Add the relationship cardinalities for each link and describe them. c) Are there any changes or additions you would make to this diagram to make it better? Why or why not? CUSTOMER Place ORDER Includes Generate COMPONENT Comprised of PRODUCT BACKORDER Supplied by VENDOR Figure-2- CITY Figure-1-

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

5 EntityRelationship Diagram Analysis Figure1 a Add the relationship cardinalities and describe them Customer Order Places Cardinality Onetomany 1N Description A single customer can place multiple ord... View full answer

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 General Management Questions!