Create ERD showing all cardinality

Assignment Help Operation Management

Reference no: EM132287509

The case:

A mail order company takes orders from Customers. When a Customer calls in, they gather information regarding the Customer's name, address, and credit card number. Customers can be of two types – individuals and corporate. Corporate customers have a tax id number that has to be stored by the mail order company. The Clerk taking the order writes out a Product Order Form, on which they write out the Customer's credit card number (a customer can have more than one) and list the products that the Customer wants to order.

The products are kept in the backroom in order by product number. Each individual product has a product number thus the product number does not refer to the class of products. They are eventually mailed to the customer.

Create an ERD showing all cardinality. If you make any assumptions please list them.

Reference no: EM132287509

Questions Cloud

Companies to major corporate status worth millions of dollar : Marie is a brilliant business person and has taken two small companies to major corporate status worth millions of dollars.

Compound interest calculator : Compound Interest Calculator 1: You are making plans to save for your retirement in 30 years.

Discuss how knowledge is improvement over information : Discuss how knowledge is an improvement over information? One approach to generating the grant narrative is creating a problem definition.

Perspectives that underpin your editorial thinking : Focus are useful perspectives that help to shape your editorial thinking

Create ERD showing all cardinality : A mail order company takes orders from Customers. Create an ERD showing all cardinality. If you make any assumptions please list them.

Mary was extremely satisfied with the product : Mary was extremely satisfied with the product after she tried it, so she purchased the product again.

The most common types of driving forces : Which of the following is not among the most common types of driving forces? Which situation, if true, most hinders the company’s exportation possibilities?

Describe trademarks-copyrights and trade secrets : Describe trademarks, copyrights, and trade secrets. How are infringements enforced internationally?

The process of preparing for favorite food item : Complete a SIPOC diagram for the process of preparing for favorite food item. (pizza)

User Account

All Pages