Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For each of the following narratives, draw an ERD diagram which indicates the entities and their attributes (if noted). Identify and label significant relationships between

For each of the following narratives, draw an ERD diagram which indicates the entities and their attributes (if noted). Identify and label significant relationships between pairs of entities.

1- A large bank operates several divisions. Information Technology (IT) is operated as one of these divisions. Within the IT division are many departments that are managed by one manager, and all IT employees belong to one of these departments.

The IT division assigns its employees to one or more ongoing projects in the bank. A project may be planned, but not have any employees assigned to it for several months. Each project will have a single employee assigned who acts as a project leader.2-

2- A hardware store sells several home workshop products to the public (such as power saws and sanders). Each product has several different manufacturers who manufacture it, and prices are different for products made by different manufacturers. Each time one or more products are sold to a customer, an invoice is created which lists the date, items purchased and their prices, and then the total purchase and tax amounts.

3- 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.28 Rating (151 Votes )

There are 3 Steps involved in it

Step: 1

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

Step: 3

blur-text-image

Document Format ( 2 attachments)

PDF file Icon
609b1cde056a1_31333.pdf

180 KBs PDF File

Word file Icon
609b1cde056a1_31333.docx

120 KBs Word File

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

Microeconomics

Authors: Austan Goolsbee, Steven Levitt, Chad Syverson

1st Edition

978-1464146978, 1464146977

Students also viewed these Databases questions

Question

2. Does your tone of voice vary with different students?

Answered: 1 week ago