Here is the question:(Accounting)

You are given with three Microsoft Access tables, namely, Program, Member and Booking, as shown in Tables 1 to 3. Program X Program_ID . Program_Name . Duration . Pay_Per_View 5 Malcolm X 45 $7.60 6 Hong Kong History 120 $15.05 13 2020 Singing Contest 70 $9.08 21 Family Affair 68 $13.68 25 $8.90 + + 22 Dragon Dance 63 Haunted House 58 $12.50 72 Karate Kids 28 $5.25 Table 1: Program Member X Member_No Member_Name 10 John Rogers 20 Patrick Wood 55 Ann Hastings Table 2: Member Booking X Member_No Program_ID . Start_Date 10 22 Wednesday, January 8, 2020 10 72 Friday, April 10, 2020 10 13 Wednesday, April 15, 2020 10 72 Saturday, June 6, 2020 20 63 Wednesday, July 22, 2020 20 63 Monday, July 20, 2020 55 6 Monday, April 6, 2020 55 22 Tuesday, February 4, 2020 55 63 Tuesday, May 19, 2020 Table 3: Booking(a) For each table, fill in the table on the answer sheet for this question to identify the primary key and the foreign key(s). If a table does not have a foreign key, write None in the space provided. (10 marks) (b) Do the tables exhibit entity integrity? Answer yes or no and then explain your answer in the table on the answer sheet for this question. (10 marks) (c) Do the tables exhibit referential integrity? Answer yes or no and then explain your answer and write "Not Applicable" if the table does not have a foreign key in the table on the answer sheet for this question. (10 marks) (d) Use a subquery to write a SQL statement for the Microsoft database that retrieves the program names and their durations which were booked by the same member as that who booked the program called "2020 Singing Contest" in descending order of the durations. This query only shows the program names and their durations other than the program called "2020 Singing Contest". Table 4 shows this query result. PROGRAM NAME DURATION Karate Kids 28 Dragon Dance 25 Table 4: Query Result Provide your answer in the space provided in the answer sheet for this question. (15 marks) (e) Write a SQL statement for the Microsoft database that shows each member name and the total of payments the member has to make for the programs booked in descending alphabetical order of member names. Exclude the rows with the total of payments less than or equal to 25. Table 5 shows this query result. Total of MEMBER NAME Payments John Rogers 28.48 Ann Hastings 36.45 Table 5: Query Result (15 marks)