Hi everyone, Please I\'d love to have correct answers to these questions by prov
ID: 3805759 • Letter: H
Question
Hi everyone, Please I'd love to have correct answers to these questions by providing typed clear answer capable of being copied to a word file so I can apply it in the program to see outcomes! Please do your best or leave it to someone else if you think you can't fulfill all parts required. I really will appreciate the one who take care of this as I always do with everybody's else :) Exercise 1 Consider the table below, describing a badly designed database. Follow the steps defined above and seen in class to make the design 3NF compliant and BCNF OffYear EnrGrade TCourseNo TCrsDescr TStdNo TStd City StdClass offerNo OffTerm S1 Seattle JUN 01 FALL T2013 3.5 DB C1 02 FALL 2013 3.3 VB C2 S2 Bothell JUN 03 SPRING 2014 3.1 OO C3 02 FALL 2013 3.4 C2 VB Exercise 2: Study the Fourth Normal Form and apply what you learn to the following relation STUDENT that shows the relationship among students, majors and activities. Suppose that students can enroll in several different majors and in several activities. Activity Major SID 1000 Swimming Music 100 Accounting Swimming 100 Music Tennis Accounting Tennis 150 Math JoggingExplanation / Answer
Exercise 1:
stdNo
stdCity
stdClass
offerNo
offTerm
OffYear
EnrGrade
CourseNo
CrsDescr
S1
Seattle
JUN
01
FALL
2013
3.5
C1
DB
S1
Seattle
JUN
02
FALL
2013
3.3
C2
VB
S2
Bothell
JUN
03
SPRING
2014
3.1
C3
OO
S2
Bothell
JUN
02
FALL
2013
3.4
C2
VB
If a relation should be in third normal form:
· It should meet be in both 1NF and 2NF
· If there is any columns which are unrelated to primary key, then put them in a separate table, relate both the table with the help of foreign key. There shouldn’t be any transitive dependency.
Boyce Codd Normal Form (BCNF):
· It should meet all the requirement of 3NF
· Candidate keys should not have any partial dependency on the other attributes.
By applying 3rd normal form and BCNF:
stdNo
stdCity
stdClass
OfferNo
EnrGrade
S1
Seattle
JUN
01
3.5
S1
Seattle
JUN
02
3.3
S2
Bothell
JUN
03
3.1
S2
Bothell
JUN
02
3.4
OfferNo
OffTerm
OffYear
CourseNo
01
FALL
2013
C1
02
FALL
2013
C2
03
SPRING
2014
C3
CourseNo
CrsDescr
C1
DB
C2
VB
C3
OO
Exercise2:
Fourth Normal Form (4NF)
By applying 4NF:
SID
Major
100
Music
100
Accounting
100
Music
100
Accounting
150
Math
SID
Activity
100
Swimming
100
Swimming
100
Tennis
100
Tennis
150
Jogging
stdNo
stdCity
stdClass
offerNo
offTerm
OffYear
EnrGrade
CourseNo
CrsDescr
S1
Seattle
JUN
01
FALL
2013
3.5
C1
DB
S1
Seattle
JUN
02
FALL
2013
3.3
C2
VB
S2
Bothell
JUN
03
SPRING
2014
3.1
C3
OO
S2
Bothell
JUN
02
FALL
2013
3.4
C2
VB
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.