Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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.

Step by Step Solution

3.39 Rating (161 Votes )

There are 3 Steps involved in it

Step: 1

Date Hardware Project HH Duratio... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Systems analysis and design

Authors: Alan Dennis, Barbara Haley Wixom, Roberta m. Roth

5th edition

978-1118057629, 1118057627, 978-111880817

Students also viewed these Accounting questions

Question

Which phase in the SDLC is the most important?

Answered: 1 week ago