ISYS224 Section A. (DB Concepts, ER modelling, DB design, SQL) Question A1. (15 marks) Page 2 50 marks (a) (8 marks) Provide a set of relational tables for the high-level data model shown in Figure 1 below. Identify primary, alternate and foreign keys in the tables. Note: you may make any reasonable assumptions about the relationships and attributes given in the figure. (b) (5 marks) Explain the concepts of Entity Integrity and Referential Integrity. Discuss why it is desirable to enforce entity integnity and referential integrity in relational models. Use Figure 1 to provide the context for your discussion. (c) (2 marks) Discuss a strategy to maintain referential integrity for a DELETE operation on a parent relation. Use Figure 1 as an example to provide the context for your discussion Branch Location 1 Assets 1m Balance Statement Date 1.1 Is has Limit Loan Belongs to Amount 1..1 o.m Customer 1n Custom D Name 1..m Employee Paymentamount Payment-date Workfor 0.m StartDate Figure 1: Data-model for a bank