Description
i want someone to deal with my assignment please
Explanation & Answer
Attached.
RELATIONAL DATABASE
SYSTEMS (COMP 1005)
Individual Assignment Spring
2017
Class:
Student Name:
Student ID:
Contents
TASK 2-ENTITY RELATIONSHIP DIAGRAM ........................................................................................ 3
a).Constructing the Entity relationship Diagram for the scenario............................................................. 3
b). Analyze the above given scenario and discuss about the possible structure of the relations (the
number and name of the columns) and the referential integrity constraints to be implemented in
the above design. ....................................................................................................................................... 4
TASK 3-NORMALIZATION ...................................................................................................................... 5
Normalize the below given Invoice to First Normal Form, Second Normal Form and Third Normal
Form .......................................................................................................................................................... 5
Step 1: Convert to 1NF by eliminating repeating groups. Each original row becomes multiple rows;
one for each value of the repeating group. ............................................................................................ 5
Step 2: Convert to 2NF by eliminating partial functional dependencies. ............................................. 6
Step 3: Convert to 3NF by eliminating transitive dependencies. .......................................................... 7
b) Discuss how the data consistency can be maintained during normalization. Support your answer
with reference to the above Question. (At least 400 words) ..................................................................... 8
TASK 4 –WRITTEN VIVA ....................................................................................................................... 11
Be ready for a written viva to demonstrate your knowledge with the different concepts used in
preparing the assignment. Schedule for the written viva will be announced in the class and on
Moodle/MEC mail. ................................................................................................................................. 11
ENTITY RELATION DATABASES DIAGRAM. ................................................................................ 11
NORMALIZATION ............................................................................................................................... 14
DATA CONCISTENCY AND INTERGRITY ...................................................................................... 14
REFERENCES ................................................................................................................................................ 17
TASK 2-ENTITY RELATIONSHIP DIAGRAM
a).Constructing the Entity relationship Diagram for the scenario.
b). Analyze the above given scenario and discuss about the possible structure
of the relations (the number and name of the columns) and the
referential integrity constraints to be implemented in the above design.
The scenario describes a company which has several departments. The relationship between the
company and the departments is one too many (1:M) since the department can have several
departments but a department cannot have several companies. Each d...
Review
Review
24/7 Homework Help
Stuck on a homework question? Our verified tutors can answer all questions, from basic math to advanced rocket science!
Similar Content
Related Tags
The Atlantis Gene
by S. A. Beck
A Wrinkle as Time
by Madeleine L'Engle
The Unwinding of the Miracle
by Julie Yip-Williams
Tess of the DUrbervilles
by Thomas Hardy
The Eyes Were Watching God
by Zora Neale Hurston
The Age Of Light
by Whitney Scharer
Killers of the Flower Moon
by David Grann
Fear - Trump in the White House
by Bob Woodward
Mrs Dalloway
by Virginia Woolf