Question

Meeting ID	Meeting Date	Meeting Time	Meeting Venue	Meeting ID	User ID	Rating	User ID	User Availability
1	24/1/2019	11:40 am	Library	1	IA	3	KC	Yes
1	24/1/2019	11:40 a	Library	1	DD	4	YA	No
1	24/1/2019	11:40 a	Library	1	KC	2	DD	Yes
2	25/1/2019	10:30 am	Trail St	2	IA	5	IA	Yes
2	25/1/2019	10:30 am	Trail St	2	DD	4	AK	Yes
2	25/1/2019	10:30 am	Trail St	2	KC	2
2	25/1/2019	10:30 am	Trail St	2	AK	3
3	26/1/2019	9:00 am	Blessed Bean	3	DD	3
3	26/1/2019	9:00 am	Blessed Bean	3	IA	2

Using above table

1. Draw a dependency diagram to show the functional dependencies in the relation

2. Decompose the relation into a set of 3NF relations

3. Draw a relational schema for your 3NF relations and show the referential integrity constraints

Answer 1

1.

2 and 3

1NF

Meeting(MeetingID, UserID, MeetingDate, MeetingTime, MeetingVenue, Rating,UserAvailability)

2NF relations

Meeting(MeetingID, MeetingDate, MeetingTime, MeetingVenue)

MeetingUser(MeetingID, UserID, Rating)

User(UserID, UserAvailability)

There is no transitive dependency so all the tables in 2NF are also in 3NF

underlined are primary keys and italicised are foreign keys.

Do ask if any doubt. Please upvote.