Meeting Id Meeting Date Meeting Time Meeting Venue Event Id User Id Rating Person Id 2812649

/in /by

Meeting ID

Meeting Date

Meeting Time

Meeting Venue

Event ID

User ID

Rating

Person ID

Status

1

24/1/2018

11:40 am

Library

1

IA

3

KC

Yes

1

DD

4

YA

No

1

KC

2

DD

Yes

2

25/1/2018

10:30 am

Trail St

2

IA

5

IA

Yes

2

DD

4

AK

Yes

2

KC

2

2

AK

3

3

26/1/2018

9:00 am

Blessed Bean

3

DD

3

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

4. Create an ERD that represents your 3NF relations

NOTE

For guidance on how to normalize database relations from a dependency diagram, watch this very short YouTube video: https://www.youtube.com/watch?v=vkUyuLLgmwQ

Manually drawing the dependency diagram, or the set of 3NF relations or the relational schema is NOT acceptable.

Rationale

back to top

This assessment task will assess the following learning outcome/s:

  • be able to apply normalisation techniques to optimise a database design.