Question 4 (25 marks) Case: Fitness Centre Access Management Database The developer for the Access Management System has decided to create a database to capture the required data using Microsoft Access database. You are required to design and show the FOUR (4) basic tables with the relevant fields that can meet the following requirements. The following are the tables you will need to show in your answer file (Do not create the tables using Microsoft Access). For each of the table below, you should specify clearly the appropriate MS Access data type for each field. You should also define the relevant primary key and foreign keys (if any) for all four tables below. You may add more fields for each table if necessary. (a) Members Information The purpose of this table is to capture information relating to members who have subscribed to the membership of the fitness centres. Some key fields are Membership ID, Member Name, Gender, Address, Email, Phone No, Membership expiry Date. Show the data view with minimum THREE (3) sample records for this table with your own data. (6 marks) (b) Member Access to the Fitness Centre The purpose of this table is to track the use of the fitness centre by the members. The key fields are Record No, Membership ID, Centre Name, Clock-in Date and Clock- in Time, Clock-Out Time. Show the data view with minimum FIVE (5) sample records with your own data. Show how a member record would be captured when he or she visited the centres. (7 marks) Fitness Instructors The purpose of this table is to store the information related to information related to the fitness Instructors. Some key fields would include the Instructor ID, Instructor Name, Gender, Phone Number, Email and Rate Per hour. Show the data view of minimum THREE (3) records for this table with your own data. (6 marks) (d) Instructor Lesson Assignments Create a relevant table with THREE (3) sample records to show the private fitness lessons conducted by Instructors in (c) for the members including the Training Record ID, Instructor ID, Membership ID, Training Date, Training Time and No of Training. (6 marks) Question 4 (25 marks) Case: Fitness Centre Access Management Database The developer for the Access Management System has decided to create a database to capture the required data using Microsoft Access database. You are required to design and show the FOUR (4) basic tables with the relevant fields that can meet the following requirements. The following are the tables you will need to show in your answer file (Do not create the tables using Microsoft Access). For each of the table below, you should specify clearly the appropriate MS Access data type for each field. You should also define the relevant primary key and foreign keys (if any) for all four tables below. You may add more fields for each table if necessary. (a) Members Information The purpose of this table is to capture information relating to members who have subscribed to the membership of the fitness centres. Some key fields are Membership ID, Member Name, Gender, Address, Email, Phone No, Membership expiry Date. Show the data view with minimum THREE (3) sample records for this table with your own data. (6 marks) (b) Member Access to the Fitness Centre The purpose of this table is to track the use of the fitness centre by the members. The key fields are Record No, Membership ID, Centre Name, Clock-in Date and Clock- in Time, Clock-Out Time. Show the data view with minimum FIVE (5) sample records with your own data. Show how a member record would be captured when he or she visited the centres. (7 marks) Fitness Instructors The purpose of this table is to store the information related to information related to the fitness Instructors. Some key fields would include the Instructor ID, Instructor Name, Gender, Phone Number, Email and Rate Per hour. Show the data view of minimum THREE (3) records for this table with your own data. (6 marks) (d) Instructor Lesson Assignments Create a relevant table with THREE (3) sample records to show the private fitness lessons conducted by Instructors in (c) for the members including the Training Record ID, Instructor ID, Membership ID, Training Date, Training Time and No of Training. (6 marks)