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

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 $\_\_\_\_\_\_\_\_\_$ tables. $(3$ point$)$

A$.5$

B$.6$

C$.8$

D$.9$