You group has been hired by  TrainingrUs.com to keeps track of training revenues. TrainingrUS.com wants you to keep scheduling.

COURSE table contains following information:

1.  Course ID (PK)
2. Price
3. Instructor Name
4. Instructor Address

Note: Primary Key (PK) is COURSE ID

Identify FK, if any

TRAINEE table contains following information:

1. Trainee ID (PK)
2. Course_ID (PK)
3. Trainee name
4. Date of training

Note: PK is (Trainee ID, Course_ID)

Identify FK, if any

Training session signed for is the same as Course ID in COURSE table

Following sample data is available:

                                                            COURSE Sample data

TRAINEE sample data

PART A:

• Develop the tables in ACCESS database Systems
• Identify PK and FK of each table (can do in WORD)

Table 1 (identify PK and FK relationships)

Submit this table as  Part A (section 2) requirement to be submitted see below

• Show the relationship (1:1 or 1:m or m:n) between the following:

PART B:

Develop the following queries in ACCESS and run (execute) them

1. List the course ID and its cost, format the output appropriately.

2. Give the trainee name and the number of classes each trainee is taking.

3. How many trainees are taking classes on November 6th? (Give a count)

4. Give the training sessions and their dates (make sure there is no repetition of session and corresponding date).

5. How many students are registered per training section?

6. How many courses are there?

7. How many classes John Watt is taking?

8. Give the total amount paid by Willy Polk

9. Give the names of instructors teaching on November 6th