A university needs to design a database. Below are the list of entities, attributes, and business rules.

Room is identified by Room$\_$No and also has Capacity. A room can be either a lab or a classroom, nothing else.

Computer identified by Computer$\_$No and has attributes ComputerType, Description and ProcessorSpeed.

Media is identified by Media$\_$No and has attributes of Type and Description.

A room cannot be both classroom and a lab. There also no other room types to be incorporated into the system.

A lab has one or more computer. However, a classroom does not have any computers and it contains different type of board need to be saved.

A room can be provided with one type of media, several types of media, or no media. A media does not belong to a room, they are borrowed and returned.

Draw an EER diagram for that case.

Specify key attributes of each entity type and structural constraints on each relationship type.

Note any unspecified requirements, and make appropriate assumptions to make the specification complete.