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
For the database for a symphony orchestra, develop an ER diagram to keep track of all...
For the database for a symphony orchestra, develop an ER diagram to keep track of all business rules specified below: Strong Entity Types: Customer: The person who purchases season ticket(s). Attributes are Customer D (Identifier), Name, Address, Phone. Concert Season: The season during which a series of concerts will be performed. The identifier is Opening Date, which includes Month, Day, and Year Concert: A given performance of one or more compositions. Identifier is Concert Number. Another attribute is Concert Date,...
You are tasked to design the ER diagram for the database for the 3S clothing store....
You are tasked to design the ER diagram for the database for the 3S clothing store. Data requirements are as given below. • Information about 3S employees includes a unique employee ID, and his/her name and position. • Each customer of 3S is identified by a customer ID, and has a name. • Information about the suppliers of 3S include a unique name, and a contact phone number. • Clothes stocked by 3S are described by a product code, size,...
Read the directions Draw an ER diagram for a bank database. The database stores information about...
Read the directions Draw an ER diagram for a bank database. The database stores information about customers and their loans. Information about a customer includes the name, address, phone, SSN, and loan(s) the customer has. Loans have loan numbers, types (e.g. mortgage, car) and amount. Do not add any attributes other than the ones describe here. Modify your design to accommodate the following constraint(s). Each constraint is independent from one another. Again, do not add any attributes other than the...
Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a...
Instructions: ​You must draw the ER Model for SpaceX Bank, save the ER Model as a png or jpeg, put your name on it and submit it on Blackboard before the due date. ​You can use ​any software​ you like to create this model. No emailed homework will be accepted no exception, and No late homework will be accepted no exceptions. Create the ER Model for ​SpaceX​ ​Bank ● Showalltheentities(regularentity,associativeentityorweakentity)with their attributes(key attribute, regular attribute or multi value attribute etc..)...
Using ER Assistant, develop an EER model for the following situation, using the EER notation associated...
Using ER Assistant, develop an EER model for the following situation, using the EER notation associated with ER Assistant. A technology company provides offerings to its customers. Offerings are of two separate types: products and services. Offerings are identified by an offering ID and an attribute of description. In addition, products are ­described by product name, standard price, and date of first release; services are described by name of the company’s unit responsible for the service and conditions of service....
Complete ER Diagrams for each scenario given (ignore the fact that the problem says "class diagram"...
Complete ER Diagrams for each scenario given (ignore the fact that the problem says "class diagram" - do an ER diagram like we've been doing in class).   8.99 (do a, b, and c) 8.99 a. Draw a class diagram, showing the relevant classes, attributes, operations, and relationships for each of the following situations (if you believe that you need to make additional assumptions, clearly state them for each situation): a. A company has a number of employees. The attributes of...
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....
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]...
Using the Entities and Attributes you created for your business from the week 1 discussions. Show...
Using the Entities and Attributes you created for your business from the week 1 discussions. Show the tables and relationships resulting from your model in the form of an E/R diagram. You can use PPT, VISIO or any other graphical modeling tool to create your ER diagram. Some of the entities and attributes that I believe my company should have would be: Employees: First Name, Last Name, Employee Address, Employee Phone Number, Employee ID Number, Date of Birth, Social Security...
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...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT