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

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

NOTE

For guidance on how to normalise 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 analyse a database design and apply normalisation theory and techniques.

Marking criteria and standards

back to top

Each task is worth 5 marks. The marking criteria for this assignment is:

Criteria

HD

DI

CR

PS

be able to analyse a database design and apply normalisation theory and techniques.

Analysis identifies all PKs and functional, partial and transitive dependencies. Accurately identifies all 3NF relations, including PKs, relevant attributes and referential integrity constraints.

Analysis identifies PKs and functional, partial and transitive dependencies with minor omissions. Accurately identifies 3NF relations, including PKs, relevant attributes and referential integrity constraints with minor omissions.

Analysis identifies key PKs and functional, partial and transitive dependencies. Identifies key 3NF relations, including PKs and relevant attributes and referential integrity constraints.

Analysis identifies key PKs and functional dependencies and draws out relevant 3NF relations.

Requirements

back to top

Either save your diagrams in a PDF file or embed them in a Word document.

Don’t use any other file formats

Please include your student ID, name and subject code in your submission.

Prof. Angela

4.6/5

Calculate Price


Price (USD)
$