Reference no: EM133694479

Question: A university have several members of faculty who work in one or more rooms with specific equipment. Faculty request certain kinds of equipment for each room. Attributes of FACULTY include Faculty ID (identifier), Name, Phone No, and office location. Attributes of ROOMS include Room ID (identifier) and Start Date. Attributes of EQUIPMENT include Serial No and Cost. The university wishes to record Assign Date-that is, the date when a given equipment item was assigned to a particular faculty working in a specified room. A faculty must be assigned to at least one room and one equipment item. A given equipment item need not be assigned, and a given room need not be assigned either a faculty or an equipment item. Draw an ERD.