Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

An electronics manufacturer produces a range of consumer and commercial grade electronic devices. These include television sets, sound systems, computer monitors, mobile phones and many

An electronics manufacturer produces a range of consumer and commercial grade electronic devices. These include television sets, sound systems, computer monitors, mobile phones and many other products. Each of these products has a name and a unique ID number associated with them.

Components to make these devices can be purchased from a single vendor or from multiple vendors. Each component has a name, unique ID number and may include a component description (this information is optional). The manufacturer sells its products to commercial buyers and also directly to consumers. The manufacturer keeps track of the name, address and phone numbers of the commercial buyers. Only the postcode for non-commercial buyers is stored.

Your first task is to construct an Entity-Relationship diagram that captures entities and their relationships. You are free to make assumptions about any information that you believe is not supplies as long as you state these assumptions. (Your assumptions should not contradict the description!)

Step by Step Solution

3.31 Rating (148 Votes )

There are 3 Steps involved in it

Step: 1

The description mainly talks about below entities Product with unique Product ID and name Product ca... 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

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

Financial Management For Decision Makers

Authors: Peter Atrill, Paul Hurley

2nd Canadian Edition

138011605, 978-0138011604

More Books

Students also viewed these Accounting questions