3183

/in /by

back to top

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