Task back to top Meeting ID Meeting Date Meeting Time Meeting...

Question

Task

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 guidanceon how to normalise database relations from a dependency diagram, watch this very shortYouTube video:https://www.youtube.com/watch?v=vkUyuLLgmwQ

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

Rationale

back to top

This assessment task will assess the following learning outcomes:

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 yourdiagrams in aPDF file or embedthem in a Word document.

Don't use any other file formats

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

Tanya · Accepted Answer

Assignment
Functional Dependency and Normalization
Content 
Introducion..................................................................................................................................3
Dependency diagram.............................................................................................................3
Normalizaion..............................................................................................................................3
Relaional schema................................................................................................................................4 
INTRODUCTION
Normalization is a process of restructuring the database in accordance with a series of normal forms in order to reduce data redundancy.
1) Functional Dependancy Diagram:
A functional Dependancy is a constraint between two attributes in a relation.
If we know one attribute, the value for the other attribute can be deduced.
This is the basic concept of functional dependency.
Full dependency means that a non-prime attribute totally depends on a prime attribute.
Partial dependency means that a non-prime attribute depends on a subset of a prime attribute.

Task 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...

Task

Rationale

Marking criteria and standards

Requirements

Answer To: Task back to top Meeting ID Meeting Date Meeting Time Meeting Venue Event ID User ID Rating Person...

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment