Solution and Marking scheme for Part 1 and 2 of the project ----------------------------------------------------------- Mark the deliverable out of 20. Extended ER Diagram ------------------- The new ER diagram elements are: 1) 1.1 An entity set called ACCOUNT_ACTIVITY with attributes Date, Description, Amount, and Balance 1.2 A relationship (say, GENERATES) between ACCOUNT and ACCOUNT_ACTIVITY 1.3 A total participation of ACCOUNT_ACTIVITY in the GENERATES relationship set 1.4 A key constraint from ACCOUNT_ACTIVITY to GENERATES 2) 2.1 An entity set called BILL_PAYMENT with attributes Payee, Date, Accoun_number, and Amount 1.2 A relationship (say, MAKES) between CUSTOMER and BILL_PAYMENT 1.3 A total participation of BILL_PAYMENT in the MAKES relationship set 1.4 A key constraint from BILL_PAYMENT to MAKES 3) 3 new attributes for the entity set CUSTOMER: Phone, Email, and Best_time For each missing item among the nine items above, take 0.5 point off. SQl Script ---------- - Add the following tables to those obtained in Assignment 1: ACCOUNT_ACTIVITY (to capture both ACCOUNT_ACTIVITY and GENERATES) BILL_PAYMENT (to capture both BILL_PAYMENT and MAKES) - Add the following attributes to the table CUSTOMER: Phone, Email, and Best_time - Add 2 triggers to do the following: 1) Whenever teh balance in table ACCOUNT_ACTIVITY is updated, the balance i table ACCOUNT must also be updated accordingly 2) Whenever a bill is paid, the amount of that bill must be deduced from the balance in the account specified in the bill payment Give 8 marks for any reasonable script created. Deduce 2 points if the 2 triggers are missing, or if no mention at all is made of them.