Consider the following relation COURSE INSTRUCTOR COURSE ID COURSE TITLE INSTRUC
ID: 3616049 • Letter: C
Question
Consider the following relation
COURSE INSTRUCTOR
COURSE
ID
COURSE
TITLE
INSTRUCTOR
NAME
INSTRUCTORLOCATION
IS 350
Database Mgt
Codd
B 104
IS 465
System Analysis
Parsons
B 137
Acctg 201
Fund Acctg
Miller
H 310
Mktg 300
Intro Mktg
Mick
B 212
The relation is in Second normal form(2NF) and there are modifications and deletion anomalies exist. Youare required to convert it into third normal form (3NF).
COURSE
ID
COURSE
TITLE
INSTRUCTOR
NAME
INSTRUCTORLOCATION
IS 350
Database Mgt
Codd
B 104
IS 465
System Analysis
Parsons
B 137
Acctg 201
Fund Acctg
Miller
H 310
Mktg 300
Intro Mktg
Mick
B 212
Explanation / Answer
COURSE(course Id, course Title)
Course ID
Course Title
IS 350
DataBaseMgt
IS 465
System Analysis
Acctg 201
Fund Acctg
Mktg 300
IntroMktg
INSTRUCTOR(name,location)
Instructor Name
Instructor Location
Codd
B104
Parsons
B137
Millor
H310
Mick
B212
Course ID
Course Title
IS 350
DataBaseMgt
IS 465
System Analysis
Acctg 201
Fund Acctg
Mktg 300
IntroMktg