DEPT

DEPTCODE

Course

Offering

Course Section

Online

Credits

Course Number

Sem

StartDate

EndDate

CourseName

Finance

FNAN

C$3$

$001$

Y

$4$

FIN$301$

F$2022$

Aug$-20-2022$

Dec$-19-2022$

Corporate Finance

Finance

FNAN

C$4$

$002$

N

$4$

FIN$301$

F$2022$

Aug$-20-2022$

Dec$-19-2022$

Corporate Finance

Info Sys Ops Mgmt

ISOM

C$1$

$001$

Y

$4$

MIS$310$

F$2022$

Aug$-20-2022$

Dec$-19-2022$

Intro to DB

Info Sys Ops Mgmt

ISOM

C$2$

$002$

Y

$4$

MIS$310$

F$2022$

Aug$-20-2022$

Dec$-19-2022$

Intro to DB

Info Sys Ops Mgmt

ISOM

C$5$

$001$

N

$4$

MIS$310$

SP$2023$

Jan$-15-2023$

May$-14-2023$

Intro to DB

Info Sys Ops Mgmt

ISOM

C$6$

$002$

N

$4$

MIS$310$

SP$2023$

Jan$-15-2023$

May$-14-2023$

Intro to DB

Column explanations:

DEPT: name of department

DEPTCODE: code used to identify each department

CourseOffering: code used to identify a course offered by a department in a semester

Course Section: section of a course offered in a semester

Online: whether section of a course offered in a semester is online

Credits: number of credits earned for a course

Course Number: Number of a course

Sem: semester in which a course is offered by a department made up with combining semester code and year

StartDate: Date indicating start of Semester

EndDate: Date indicating end of Semester

CourseName: name of a course

IMPORTANT: Copy$-$paste the following into your answer before providing answer for each $($a$)$ and $($b$)$

a$)$ Identify all the Entities and associated columns. Write in format $--$ ENTITY$\_$NAME$($column$1,$ column$2,$ column$3,...).$ Underline Primary Key column$($s$).$

b$)$ Identify relationship between entities and cardinality for each relationship.