Question

Draw an ERD for the following situations: A department store has a wedding registry. This registry...

Draw an ERD for the following situations: A department store has a wedding registry. This registry keeps information about the customer, the products that the store carries, and the products for which each customer registers. Customers typically registers for a large number of products and many customers register for the same products.

Homework Answers

Answer #1

Here the entities we have are Customer and Products.

The relationship between Customer and Product is M:N since a customer order many products while a same product can be ordered by more than one customer.

Let primary key for Customer be CustID and the order attribute be FName, LName, Address.

Let the primary key of Product be ProdID and other attribute be description. Here the Quantity of a product ordered will be attribute of relationship ORDER.

The ERD diagram is

If you have any questions comment down. Please don't simply downvote and leave. If you are satisfied with answer, please? upvote thanks

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Create an ERD diagram from the following problem: The Busy B Company wants to store data...
Create an ERD diagram from the following problem: The Busy B Company wants to store data about its employees’ skills. Each employee possesses one or more specific skills. In addition, several employees may have the same skill. The following facts need to be included in the database: 1. Employee name 2.Skill number 3.Skill name 4.Employee number 5. Date hired 6. Date of birth 7. Date skill acquired
Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing...
Create an ERD based on the following Summit Sporting Goods scenario. Be sure to follow drawing conventions for readability and clarity. “I’m a manager of a sporting-goods wholesale company that operates worldwide to fill orders from retail sporting-goods stores. The stores are our customers (some of our people prefer to call them our clients). Right now we have 15 customers worldwide, but we’re trying to expand our customer base by about 10% each year starting this year. Our two biggest...
The manager of a department store in Seattle is attempting to decide on the types and...
The manager of a department store in Seattle is attempting to decide on the types and amounts of advertising the store should use. He has invited representatives from the local radio station, television station, and newspaper to make presentations in which they describe their audiences. The television station representative indicates that a TV commercial, which costs $15,000, would reach 25,000 potential customers. The breakdown of the audience is as follows:    Male   Female Senior   5,000   5,000 Young   5,000   10,000 The...
Create an ERD for the Following: The H.I. Topi School of Business operates international business programs...
Create an ERD for the Following: The H.I. Topi School of Business operates international business programs in 10 locations throughout Europe. The school had its first class of 9,000 graduates in 1965. The school keeps track of each graduate’s student number, name when a student, country of birth, current country of citizenship, current name, current address, and the name of each major the student completed (each student has up to two majors). To maintain strong ties with its alumni, the...
In a hospital there are a number of department based on disease. Major department exist are...
In a hospital there are a number of department based on disease. Major department exist are Dermatology, Cardiology, Gynecology, Pathology, etc. Each department is capable to serve the patient in increasingly fair manner. To avail the treatment facility, patient visits to the relevant department where (s)he is allotted a token number. Allotment of token number is purely on the basis of arrival time. Separate queue is maintained for each department. Hospital maintains the following information about the patient. Based on...
Consider the following description of a Point-of-Sale (POS) system: A department store wants to develop a...
Consider the following description of a Point-of-Sale (POS) system: A department store wants to develop a software system to help control the running of business. The back-end database, which holds information about the stock and transactions, already exists. But it is not currently integrated with any POS devices. The purpose the new system is to make this integration. The business analyst has identified the following POS’s and activities where the new software system should help: • At the checkout counter,...
    Imagine yourself in the following two situations: a.    You are about to go shopping to...
    Imagine yourself in the following two situations: a.    You are about to go shopping to purchase a stereo system at a local store. Upon reading the newspaper, you find that another stereo store across town has the system you are interested in for $1,089.99. You had been planning to spend $1,099.95, the best price you had found after considerable shopping. Would you drive across town to purchase the stereo system at the other store? b.    You are about to...
[1] Please draw an ERD based on the following description. The requirements collection and analysis phase...
[1] Please draw an ERD based on the following description. The requirements collection and analysis phase of the database design process has provided the following data requirements for a company called Reliable Rentals, which rents out vehicles (cars and vans). The Company has various outlets (garage/offices) throughout Glasgow. Each outlet has a number, address, phone number, fax number, and a manager who supervises the operation of the garage and offices at each site. Each site is allocated a stock of...
Hello, can you teach me how to draw a Use Case diagram for this given scenario?...
Hello, can you teach me how to draw a Use Case diagram for this given scenario? I also need to include all the extends and includes relationships. Case Description Acme Drug Stores (ADS) which consists of a chain of retail stores across Canada wants to be able to provide a new online customer service system. Each store has an identifying store no, address, phone, and email. The company dispenses a wide range of pharmaceutical (drug) products. Each product has a...
A grocery store is trying to predict how many packages of toilet paper rolls will be...
A grocery store is trying to predict how many packages of toilet paper rolls will be purchased over the next week. They know from their records that each customer has a 60% chance of buying 0 packages, a 30% chance of buying 1 package, an 8% chance of buying 2, and a 2% chance of buying 25. They expect about 150 customers per day. a. What is the expected number of packages sold in one day? b. What is the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT