DRAW Entity/Relationship Model For the following narrative, draw an ERD diagram which indicates the entities and their
Question:
DRAW Entity/Relationship Model For the following narrative, draw an ERD diagram which indicates the entities and their attributes (if noted). Identify and label significant relationships between pairs of entities.
The Ministry of Transportation (MOT) supplies department keeps track of all the items (furniture and equipment such as a chair or printer) in the Ministry offices. There are several MOT buildings and each one is given a different name to identify it. Each item is assigned a unique ID when it is purchased. This ID is used to keep track of the item, which is assigned to a room within a building. Each room within a building is assigned to a department, and each department has a single employee as its manager.
Systems analysis and design
ISBN: ?978-1118808177
5th edition
Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth