IT403 Saudi Electronic University Lossless Join Decomposition Quiz

Lossless-Join Decomposition

.

..

.

What do you mean by Lossless-JoinDecomposition, give an example of Lossless-Join decomposition of R = (A, B, C)in R1= (A, B) and R2 = (B, C) by drawing tables?

Write the USE of multivalued dependencies in two ways

What are the conditions that must be full fill for 2NF, explain the implications of 1NF?

….. College of Computing and Informatics
Assignment 2
Deadline: Day 21/11/2019 @ 23:59
[Total Mark for this Assignment is 5]
Student Details:
Name: ###
ID: ###
CRN: ###
Instructions:
•
•
•
•
•
•
•
•
•
You must submit two separate copies (one Word file and one PDF file) using the Assignment Template on
Blackboard via the allocated folder. These files must not be in compressed format.
It is your responsibility to check and make sure that you have uploaded both the correct files.
Zero make will be given if you try to bypass the SafeAssing (e.g. misspell words, remove spaces between
words, hide characters, use different character sets or languages other than English or any kind of
manipulation).
Email submission will not be accepted.
You are advised to make your work clear and well-presented, marks may be reduced for poor presentation.
This includes filling your information on the cover page.
You MUST show all your work, and text must not be converted into an image, unless specified otherwise by
the question.
Late submission will result in ZERO marks being awarded.
The work should be your own, copying from students or other resources will result in ZERO marks.
Use Times New Roman font for all your answers.
Question One
Pg. 01
Learning
Outcome(s):
LO 3 explain the
concepts and
processes
involved in
database
development.
Question One
2 Marks
What do you mean by Lossless-Join Decomposition, give an example of Lossless-Join
decomposition of R = (A, B, C) in R1= (A, B) and R2 = (B, C) by drawing tables?
Question Two
Pg. 02
1 Mark
Learning
Outcome(s):
Question Two
LO 3 explain the
Write the USE of multivalued dependencies in two ways
concepts and
processes
involved in
database
development.
Question Three
Pg. 03
2 Marks
Question Three
Learning
Outcome(s):
LO 6 create a
database
application to
store and retrieve
data.
What are the conditions that must be full fill for 2NF, explain the implications of 1NF?