Taskback to topMeeting IDMeeting DateMeeting TimeMeeting VenueEvent IDUser IDRatingPerson...

Question

Taskback to topMeeting IDMeeting DateMeeting TimeMeeting VenueEvent IDUser IDRatingPerson IDStatus124/1/201811:40 amLibrary1IA3KCYes1DD4YANo1KC2DDYes225/1/201810:30 amTrail St2IA5IAYes2DD4AKYes2KC22AK3326/1/20189:00 amBlessed Bean3DD33IA2Using above table1. Draw a dependency diagram to show the functional dependencies in the relation2. Decompose the relation into a set of 3NF relations3. Draw a relational schema for your 3NF relations and show the referential integrity constraintsNOTEFor guidanceon how to normalise database relations from a dependency diagram, watch this very shortYouTube video:https://www.youtube.com/watch?v=vkUyuLLgmwQManually drawing the dependency diagram, orthe set of 3NF relationsor the relational schema is NOT acceptable.Rationaleback to topThis assessment task will assess the following learning outcomes:be able to analyse a database design and apply normalisation theory and techniques.Marking criteria and standardsback to topEach task is worth 5 marks. The marking criteria for this assignment is:CriteriaHDDICRPSbe 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.Requirementsback to topEither save yourdiagrams in aPDF file or embedthem in a Word document.Don't use any other file formatsPlease 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

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment

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

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.