Note: In all cases you represent the textual description. DO NOT bring in your perspective even if what you see described appears illogical or incorrect. The goal is to see if you can represent what's given accurately

The college of business atbwants to build a database to manage faculty data.$$

Specifically, it wants to track the following data: Faculty ID$,$ Faculty name, phone number, current title $($as in assistant prof, associate prof, lecturer etc$),$ office building,$$ office room no$.$

Restriction$($s$)$:$$A faculty member can have several offices $($room$),$ but this office may not be shared with other faculty $($see note above$).$

Task:$$

Provide the design $($set of tables and fields$)$ for such a database. The resulting table structure MUST follow this simple$$textual$$format:

TABLENAME$($PK$,$ attr $1,$ attr $2,$ attr$3...$ as needed$)$

TABLENAME$($PK$,$ attr $4,$ attr $5$ etc...$$FK$$as needed$)$