1. The snapshot of online Golf club management system database structure (GolfClubDB) is given below. GolfClubDB is a database that keeps track of information about the clubs, members, Professionals (who provide professional golf coaching) and details of lesson bookings.

Assume that you are working as an IT specialist in this organisation and required to extract information from this database by executing SQL queries according to the instructions given below. The primary keys (PK), Foreign Keys (FK or PF) are marked in the following snapshot of database, shown in Figure 1.

Figure 1: Snapshot of database for Golf Club members Database Answers Ltd

CREATE DATABASE

a. For Part A, create only 2 tables Golf_clubs and Members with all attributes given in the above database structure and the relationship between the two tables. You do not have to create other tables for assignment 1 Part A. Use MS Access.

• Populate those tables with suitable data (at least 3 records per table).

You can use datasheet view in MS Access to enter suitable data records.

• Include Proper foreign keys to create relationships in between tables.

Hint: If you want to create a one-to-many relationship in your database, include one side primary key in the many side table as foreign keys.

NB: You need to upload your database on submission link before the due date and 10 marks will be deducted as per assignment Marking Criteria for not submitting the database file.

This is an individual assignment; it should be your own individual work (You should not copy Ms Access Database). If not, it is considered as cheating and you will get zero marks for the whole

assignment. (10 Marks)

Golf_Clubs PK golf_club_id* club_name year_established club_address other_club_details | | Professionals Members PK member_id FK golf_club_id* pro_id* FR employed_by_club_id*| date_of_birth gender* handicap pro_first_name pro_last_name other_pro_details fees_due_date fees_paid_uptodate_yn member_first_name member_last_name member_phone member_email member_address Member_Lessons CPF member_id* PF pro_id" PK lesson_date FK lesson_status_code* booking_made_date lesson_fee_amount Golf_Clubs PK golf_club_id* club_name year_established club_address other_club_details | | Professionals Members PK member_id FK golf_club_id* pro_id* FR employed_by_club_id*| date_of_birth gender* handicap pro_first_name pro_last_name other_pro_details fees_due_date fees_paid_uptodate_yn member_first_name member_last_name member_phone member_email member_address Member_Lessons CPF member_id* PF pro_id" PK lesson_date FK lesson_status_code* booking_made_date lesson_fee_amount