Question: table [ [ DEPT , DEPTCODE,CourseOffering,Course Section,Course Number,Sem,StartDate,EndDate,CourseName ] , [ Finance , FNAN,C 3 , 0 1 , FIN 3 0 1 ,

\table[[DEPT,DEPTCODE,CourseOffering,Course Section,Course Number,Sem,StartDate,EndDate,CourseName],[Finance,FNAN,C3,01,FIN301,F2017,Aug-20-2017,Dec-19-2017,Corporate Finance],[Finance,FNAN,C4,02,FIN301,F2017,Aug-20-2017,Dec-19-2017,Corporate Finance],[,,,,MIS310,F2017,Aug-20-2017,Dec-19-2017,Intro to DB],[Info Sys Ops Mgmt,ISOM,C1,01,MIS310,F2017,Aug-20-2017,Dec-19-2017,Intro to DB],[Info Sys Ops Mgmt,ISOM,C2,02,MIS310,SP2018,Jan-15-2018,May-14-2018,Intro to DB],[Info Sys Ops Mgmt,ISOM,C5,01,MIS310,SP2018,Jan-15-2018,May-14-2018,Intro to DB],[Info Sys Ops Mgmt,ISOM,C6,02,,,,,]]
Column explanations:
\table[[DEPT: name of department,Course Number: Number of a course],[DEPTCODE: code used to identify each department,Sem: semester in which a course is offered by a department made up],[with combining semester code and year,],[CourseOffering: code used to identify a course offered,StartDate: Date indicating start of Semester],[by a department in a semester,EndDate: Date indicating end of Semester],[\table[[Course Section: section of a course offered in a],[semester]],CourseName: name of a course]]
 \table[[DEPT,DEPTCODE,CourseOffering,Course Section,Course Number,Sem,StartDate,EndDate,CourseName],[Finance,FNAN,C3,01,FIN301,F2017,Aug-20-2017,Dec-19-2017,Corporate Finance],[Finance,FNAN,C4,02,FIN301,F2017,Aug-20-2017,Dec-19-2017,Corporate Finance],[,,,,MIS310,F2017,Aug-20-2017,Dec-19-2017,Intro to DB],[Info Sys Ops Mgmt,ISOM,C1,01,MIS310,F2017,Aug-20-2017,Dec-19-2017,Intro to

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!