Rational data base , writing homework help

User Generated

hzubbe

Programming

Description

i want someone to deal with my assignment please

User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

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


Anonymous
Really helped me to better understand my coursework. Super recommended.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Related Tags