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 b 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 other significant attributes for each entity.
Question
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
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
