Question

Normalize the following relation Lecturer_Course_Rel(DID, Dept, LID, Lname, Lroom, CID, CName, Credit, DW, LTime, PID, PType) DID Dept. LID LName CID CName Credit LRoom LTime DW PID PType 10 IT 0001 Minger 101 Intro. To Comp 2-3 101 13:00-16:00 Mon. 01 Sony 105 Prog. Lang. 3-0 101 9:00-10:20 Tue. 02 Panasonic 0002 Craven 003 Math II 2-0 102 10:40-12:00 Thu. 04 Phillips 105 Prog. Lang. 3-0 106 14:40-16:00 Wed. 02 Panasonic 11 ME 0101 Taylor 003 Math II 2-0 201 13:00-14:20 Thu. 01 Sony 208 Fluid Dynamics 2-3 101 9:00-12:00 Mon 01 Sony 0102 Chen 208 Fluid Dynamics 2-3 202 14:40-16:00 Fri. 04 Phillips 12 CE 0201 Ahmed 307 Concrete Eng. 2-3 301 13:00-14:20 Tue. 05 Sharp 0202 Brown 304 Hydraulics 3-0 106 9:00-10:20 Wed. 02 Panasonic Where, DID: Department Identifier LRoom: Lecture Room Dept: Department Name CID: Course Identifier LID: Lecture Identifier Course: Course Name Lecturer: Lecturer Name LTime: Lecture Time DW: Day in Week PID: Projector Identifier PType: Projector Type

          Normalize the following relation
Lecturer_Course_Rel(DID, Dept, LID, Lname, Lroom, CID,
CName, Credit, DW, LTime, PID, PType)
DID Dept. LID LName CID CName Credit LRoom LTime DW PID PType
10 IT 0001 Minger 101 Intro. To Comp 2-3 101 13:00-16:00 Mon. 01 Sony
105 Prog. Lang. 3-0 101 9:00-10:20 Tue. 02 Panasonic
0002 Craven 003 Math II 2-0 102 10:40-12:00 Thu. 04 Phillips
105 Prog. Lang. 3-0 106 14:40-16:00 Wed. 02 Panasonic
11 ME 0101 Taylor 003 Math II 2-0 201 13:00-14:20 Thu. 01 Sony
208 Fluid Dynamics 2-3 101 9:00-12:00 Mon 01 Sony
0102 Chen 208 Fluid Dynamics 2-3 202 14:40-16:00 Fri. 04 Phillips
12 CE 0201 Ahmed 307 Concrete Eng. 2-3 301 13:00-14:20 Tue. 05 Sharp
0202 Brown 304 Hydraulics 3-0 106 9:00-10:20 Wed. 02 Panasonic
Where,
DID: Department Identifier LRoom: Lecture Room
Dept: Department Name CID: Course Identifier
LID: Lecture Identifier Course: Course Name
Lecturer: Lecturer Name LTime: Lecture Time
DW: Day in Week PID: Projector Identifier
PType: Projector Type

Normalize the following relation
LecturerCourseRel(DID, Dept, LID, Lname, Lroom, CID,
CName, Credit, DW, LTime, PID, PType)
DID Dept. LID LName CID CName Credit LRoom LTime DW PID PType
10 IT 0001 Minger 101 Intro. To Comp 2-3 101 13:00-16:00 Mon. 01 Sony
105 Prog. Lang. 3-0 101 9:00-10:20 Tue. 02 Panasonic
0002 Craven 003 Math II 2-0 102 10:40-12:00 Thu. 04 Phillips
105 Prog. Lang. 3-0 106 14:40-16:00 Wed. 02 Panasonic
11 ME 0101 Taylor 003 Math II 2-0 201 13:00-14:20 Thu. 01 Sony
208 Fluid Dynamics 2-3 101 9:00-12:00 Mon 01 Sony
0102 Chen 208 Fluid Dynamics 2-3 202 14:40-16:00 Fri. 04 Phillips
12 CE 0201 Ahmed 307 Concrete Eng. 2-3 301 13:00-14:20 Tue. 05 Sharp
0202 Brown 304 Hydraulics 3-0 106 9:00-10:20 Wed. 02 Panasonic
Where,
DID: Department Identifier LRoom: Lecture Room
Dept: Department Name CID: Course Identifier
LID: Lecture Identifier Course: Course Name
Lecturer: Lecturer Name LTime: Lecture Time
DW: Day in Week PID: Projector Identifier
PType: Projector Type

Added by Tammy K.

Question

Please give Ace some feedback