Question

Draw an ER diagram and show the cardinality. Customers submit orders for products. The identifier for...

Draw an ER diagram and show the cardinality.

Customers submit orders for products. The identifier for an order is Order-ID, and another attribute is Order Date. A customer may submit any number of orders, but need not submit any orders. Each order is submitted by exactly one customer. The identifier for a customer is Customer ID. Other attributes include Customer_Name and Customer_Address.

Engineering   Computer-Science   
0 0
Add a commentTranscribed image text
Next >

Homework Answers

Answer #1

Here we have 2 entity - Customer and Order. The primary key for Customer is CustomerID while primary key for Order is OrderID.

The relationship between Customer and Order is one to many.

The participation of Customer is zero or many which is indicated as --->0----

The participation of Order is one. It is indicated as

-----||-----

The relationship between them is called submit denotes in a rhombus shape.

The ER Diagram is

If you have any questions comment down and please? upvote thanks

0 0
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Use ONLY the classes in this list to draw a Class diagram. The diagram must show...
Use ONLY the classes in this list to draw a Class diagram. The diagram must show all the classes, their attributes, and the relationships between the classes. All the associations must have proper multiplicity constraints indicated. Note that class methods and attribute types are not required.                                                                                                               Domain classes and their attributes Order [date/time, total price, status] Account [full name, address, phone, email] SellerAccount (no attributes) BuyerAccount [credit card] Book [title, ISBN, author, publisher, asking price] BookOnOrder [quantity] Dispute [reason]...
Draw an ER Diagram for the following enterprise: A publication (which is either a book or...
Draw an ER Diagram for the following enterprise: A publication (which is either a book or a recording, but not both) is identified by its catalog number, and it additionally has a title. Every publication is produced by a publisher on some date, where the date consists of a month and a year. A publisher, identified by name, has offices in one or more cities. A publisher may be owned by another publisher. A publisher may own several other publishers....
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc....
Create a relational model and ER diagram based on the following info. Emerald Realty Group, Inc. is a local real estate company that is specialized in leasing office space to businesses. The company does not own all the properties it leases. The company has its own suppliers and customers. We refer to the person or the company that owns the office space as a supplier. A customer is the person or the company that rents the office space. Emerald Realty...
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...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in...
Requirements: Based on the following information, draw an E-R diagram and a set of relations in 3rd normal form. Please indicate any assumptions that you have made. Wally Los Gatos, owner of Wally’s Wonderful World of Wallcoverings, has hired you as a consultant to design a database management system for his chain of three stores that sell wallpaper and accessories. He would like to track sales, customers, and employees. After an initial meeting with Wally, you have developed a list...
note: I asked the database code by posting another question. Question: Draw the ER diagram of...
note: I asked the database code by posting another question. Question: Draw the ER diagram of your database design in Chen’s notation. . RULES OF DATABASE Each thesis has the following mandatory attributes: thesis no (numeric), title, abstract, author, year, type (one of Master, Doctorate, Specialization in Medicine, and Proficiency in Art), university, institute, number of pages, language (Turkish, English, etc.), and submission date, A person can be author of more than one theses (for example, a person can prepare...
Plot a UML diagram for the following application. A chain of community libraries run book loan...
Plot a UML diagram for the following application. A chain of community libraries run book loan services. A book can be borrowed from a library of the chain and returned to another library. A book has an ISBN number, a title, some authors, and a year of publication. Books have a loan period limit which is determined by how frequent the books have been borrowed. Books may have multiple copies and each copy has an item number. When all copies...
Draw an E-R diagram pls Required Data The data items required for the train reservation database...
Draw an E-R diagram pls Required Data The data items required for the train reservation database can be classified into six categories: trains, stations, train schedules, reservations, customers and employees. The above classification does not imply any particular table arrangement. You are responsible for arranging the data items into tables, determining the relationships among tables and identifying the key attributes. Finally, you should specify and enforce integrity constraints on the data, including referential integrity constraints. You will first create an...
A travel/tour company provides a broad range of tours and travel services with discounts for their...
A travel/tour company provides a broad range of tours and travel services with discounts for their members. A member may be an individual member or a company member that allows the company’s employees to use the services.  An individual member will pay his/her own travel expenses, a company employee will be paid for by his/her company.  The payment will be charged by credit cards. The travel company offers the following categories of services: Air travel – charters for airlines Water travel –...
Question 2 The questions in this section are all based on the “Online Book Exchange System...
Question 2 The questions in this section are all based on the “Online Book Exchange System (EyesHaveIt.com)” Case Study on the last page of this document. Read the case study carefully before answering these questions. b) An analyst has identified all the domain classes and their attributes required for the system, as listed below. Use ONLY the classes in this list to draw a Class diagram. The diagram must show all the classes, their attributes, and the relationships between the...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT