Please help, thank you

Databases [30 Marks] Grahamstown Residents' Association (GRA) has up to now been keeping track of its members using a spreadsheet but this has become cumbersome because of a big increase in membership. GRA has had some help in creating a database and now needs help extending it. Open GRA- members.accdb in your exam folder and answer the following questions by filling in the blanks. 54. Look for the relationship below in the given database and fill in the missing labels on the connecting lines (in the boxes with heavy lines): (2 marks) 55. The relationship between Campaigns and Activists is to (2 marks) 56. The kind of query that can modify a database is called query. (1 mark) 57. A query that can add a new table to a database is called query. (1 mark) 58. Run the query Members Overdue Payment Query. What kind of query is this? (1 mark) query 59. Explain what happens when you run the query Members Overdue Payment Query and supply the text 31/03/2016. (3 marks) 59. Explain what happens when you run the query Members Overdue Payment Query and supply the text 31/03/2016. (3 marks) The following relates to questions 60-63. You want to create a query called GenerousMembers that: - Displays a member's first name - Displays a member's surname - Displays the amount the member has paid - Only displays the above if the amount paid is more than a number the user types in. 60. Name any tables needed in this GenerousMembers query. (2 marks) 61. This GenerousMembers query should pop up a request worded like this "Report members who paid more than:" and expect the user to enter a number as described above. What type of query is this? (1 mark) query 62. Create the GenerousMembers query and copy the SQL generated for it here. (6 marks) 63. Import the Excel file SportsClubs.xlxs from your exam folder as a new table called Sports Clubs. Use the first row as column headings and use the first column (Club ID) as the primary key. What data type is this key? (1 mark) 6. Now add a new field (in design view) to the Committee Members table called Sports Club of type short text. Use this field to create a relation in which you enforce referential integrity between committee members and sports clubs. The primary key is in table and the foreign key (4 marks) 65. In table Committee Members try to enter an invalid club ID (such as XYZ ) under Sports Club for member Wendy Payne. Report what happens. (2 marks) 66. Consider a query where the SQL contains the wording FROM Members INNER JOIN Activists. The wording INNER JOIN results in which combination of records from Members and Activists? (2 marks) 67. The SELECT line in a query determines which (delete which does not apply) COLUMNS/ROWS are displayed and the WHERE line determines which (delete which does not apply) COLUMNS/ROWS are displayed. (2 marks)