Repeat question 4, but allowing several telephones per room. All employees in a room share all the telephones in that room. question 4 Repeat question 3, but with the addition of the attributes...

Repeat question 4, but allowing several telephones per room. All employees in a room share all the telephones in that room.

question 4

Repeat question 3, but with the addition of the attributes employeeNo and employeeName. Values of employeeNo identify individual employees. Each employee has only one name and occupies only one room.

question 3

Every room in a building is identified by a room No and has precisely one telephone. Each telephone has its own distinct telephone Extension No. There are two types of telephone, internal dialling only (type I), and external/internal dialling (type E). The rental charged depends only on the tariff. Type I telephones are charged on tariff T1, and type E on tariff T2. Information on rooms and telephones will be held in the table:

Making any further plausible assumptions necessary:

(a) draw a determinancy diagram for Office;

(b) write down the candidate identifier(s).