Question: Exercise 2 b - Entity Relationship Diagram Create an Entity Relationship Diagram for each scenario. Indicate Primary Key attributes with PK and Foreign Key Attributes

Exercise 2b - Entity Relationship Diagram
Create an Entity Relationship Diagram for each scenario. Indicate Primary Key attributes with PK and Foreign Key Attributes with FK. State also the Max and Min Cardinality of the relationship and if they are optional or mandatory.
Also, add at least 2 other significant attributes for each entity.
Question 1
Design a database to store details about bank branches and employees. The database should include the branch name, address and telephone number. The database will store details about the bank employees and positions. An employee works at one location (branch).
 Exercise 2b - Entity Relationship Diagram Create an Entity Relationship Diagram

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!