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


Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1490

Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1495

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


Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1490

Notice: Trying to access array offset on value of type bool in /home/onliiuxo/public_html/wp-content/themes/betheme/functions/theme-functions.php on line 1495

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.