COURSE INSTRUCTOR COURSE ID COURSE TITLE INSTRUCTOR NAME INSTRUCTOR LOCATION IS
ID: 3616061 • Letter: C
Question
COURSE INSTRUCTOR
COURSE
ID
COURSE
TITLE
INSTRUCTOR
NAME
INSTRUCTOR LOCATION
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 aremodifications and deletion anomalies exist. You are required toconvert it into third normal form (3NF).
COURSE
ID
COURSE
TITLE
INSTRUCTOR
NAME
INSTRUCTOR LOCATION
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