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

Following sample data is available:

COURSE Sample data

Course ID	Price ($)	Instructor Name	Instructor Address
S111	2850	Harry	UB
S121	3200	Polly	UB
S155	1200	Smith	Loyola
H111	500	Morton	JHU
H123	2200	David	JHU
H125	1200	Polly	UB
H221	800	Lionel	UB
H225	1450	Lionel	UB

TRAINEE sample data

Trainee ID	CourseID	Trainee Name	Date of training
A101	H111	Sam Paper	10/02/2016
A101	H123	Sam paper	10/03/2016
A110	S111	Mary Poppins	11/01/2016
B112	S111	Alex Johnson	11/01/2016
B112	S121	Alex Johnson	11/02/2016
B112	S155	Alex Johnson	11/06/2016
B222	H123	John Watt	10/03/2016
B222	H111	John Watt	10/01/2016
B222	S111	John Watt	11/06/2016
B222	S121	John Watt	11/02/2016
B222	S155	John Watt	10/05/2016
C111	H123	Jong Chu	10/03/2016
C111	H111	Jong Chu	10/02/2016
F456	S111	Jerry Long	11/08/2016
F555	S111	Willy Polk	11/08/2016
F555	S155	Willy Polk	11/06/2016
F555	H111	Willy Polk	02/11/2016
X123	H123	Shirley Dent	10/03/2016
X123	S111	Shirley Dent	11/06/2016
X123	H125	Shirley dent	02/11/2016
X123	H225	Shirley dent	10/02/2016

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)

Table Name	COURSE	TRAINING
Primary Key (PK)
Foreign Key (FK)

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:

COURSE and TRAINEE in ACCESS and include a print screen copy from ACCESS

Justify why it is 1:1 or 1:m or m:n