Question

A small company is expanding into new offices spread across three buildings. To keep track of office furniture, computers, and printers, the company would like an ER diagram to keep track of everything. Each piece of office furniture, computer, or printer is given an identification number. Each item (which is either a piece of furniture, a computer, or a printer) is placed in a room of one of three buildings. The building manager is responsible for the items in their building. The building manager is identified by an employee ID, first name, last name, and DOB. Draw an ER diagram that will assist in the creation of this database. (CLARIFICATION: Only need the ER diagram, you are not responsible to make the database)

Answer 1

Below is the ER Diagram.Here employee is a manager.empID is employee id,bgID is the building ID,roomID is the Room ID,itemID is the Item ID, these are the primary keys of the table which uniquely identifies the table.here item can be anything like furniture,computer and printer each item is identified by its itemID.

ER-DIAGRAM: