Midsize University has the following partial conceptual model to represent its system for storing information about its faculty, courses, departments, and offices. Convert the conceptual model into a logical model in relational database table format $($with only table names and attribute names$)$ and answer related multiple choice $/$ filling the blank questions.

Additional Information you may need:

While at any point in time a few offices are unassigned to faculty and unallocated to any department, more than $80\%$ are assigned and allocated. More than $90\%$ of faculty have assigned offices.

Q$1$: To present the course$-$faculty association, we should $(1$ point$)$

A $.$ Post courseid$($PK$)$ from Course table to Faculty Table as Foreign Key

B $.$ Post id$($PK$)$ from Faculty table to Course Table as Foreign Key

C$.$ Create a separate table and post courseid$($PK$)$ from Course table and id$($PK$)$ from Faculty table into the new table

D$.$ None of the above

Q$2$: To present the course$-$Department association, we should $(1$ point$)$

A $.$ Post courseid$($PK$)$ from Course table to Department Table as Foreign Key

B $.$ Post deptName$($PK$)$ from Department table to Course Table as Foreign Key

C$.$ Create a separate table and post Courseid$($PK$)$ from Course Table and prefix from Department table into the new table

D$.$ None of the Above

Dashboard

Dashboard

Calendar

To Do

Notifications

Inbox

$9$:$16$

Back Assignment $1.$pdf

Q$3$: To present the Faculty$-$Office association, we can $(2$ point$)$

A $.$ Post Bldg$($PK$)$ from Office table to Faculty Table as Foreign Key

B $.$ Post id$($PK$)$ from Faculty table to Office Table as Foreign Key

C$.$ Create a separate table and post Bldg$($PK$)$ and Room#$($PK$)$ from Office table and id$($PK$)$ from Faculty table into the new table

D $.$ A & B both work

Q$4$: To present the Department$-$Office association, we should

$(2$ point$)$

A $.$ Post Bldg$($PK$)$ from Office table to Department Table as Foreign Key

B $.$ Post deptName$($PK$)$ from Department table to Office Table as Foreign Key

C $.$ Create a separate table and post Bldg$($PK$)$ from Office table and deptName$($PK$)$ from Department table into the new table

D$.$ None of the above

Q$5$: Your solution of the relational model includes

ables. $(3$ point$)$

A$.5$

B$.6$

C$.8$