An international bank wishes to develop a banking information system to prepare for its expansion of the core business in mainland China. It recently opened several branches in cities like Beijing, Shanghai and Shenzhen. The bank branches can now offer limited services for customers to open saving accounts and credit accounts. A simplified conceptual database design is shown in the following extended ER $($EER$)$ diagram

Answer the following questions $($Note any unspecified requirements and make appropriate assumptions to make the specification complete$).$

a$)$ Convert the above EER d$$gram into the relational schema $(10$ marks$).$ b$)$ Show all the functional dependencies that should hold among the attributes $(7$

marks$).$

c$)$ Design relational schemas for the database that are each in $3$NF$.$ Specify the

primary and foreign key attributes of each relation $(8$ marks$).$