Your task is to perform a step of logical database design, i.e. to transform a conceptual schema given above into a collection of relational schemas.

 

For each relational schema, clearly list the names of attributes, primary key, candidate keys (if any), and foreign keys (if any). Assume, that a superset method must be used to implement a generalization.

 

 

Manages A MANAGER BRANCH branch# name address 1..* 1..* assign_date Assigned to ID EMPLOYEE employee# name address dob salary_level Supervises ID account# Has 1..* Handles transaction_date TELLER CUSTOMER customer# name address dob 1 Opens ACCOUNT ID balance type open_date Has 3..* IDDocument Document# ID