Database Question

2. [5 marks] Given the following relations: Relation X A B C D Bici D1 A2 B2 C3 DI A3 B2C5 DI A2 B1 C5 DI Relation Y E1 A1 E2 A2 E3A1 E5 A4 The attribute A in relation Y is a foreign key that references Relation X Identify two problem with the data given above, explaining why each is a problem. 3. [10 marks] Given the following relations: Relation X A B C D ALBI DI A2 B2 C3 DI A3 B2 05 DI Relation Y LE A E2A2 E3AI None of the following updates can be performed. Explain why. a) Update (A1, B1,C1,D1) to {null, B1 null, D1} in Relation X. b) Insert (E2, A3) into Relation Y. c) Insert (E4, A4) into Relation Y. d) Delete {A1,B1,C1,D1} from Relation X