Niven Company manufactures and sells ornamental flamingoes. The flamingoes come in one color, pink, but come in three sizes, small, medium, and large. Customers order the products through the web by specifying the quantity of each product, and by providing a shipping address and credit card number. The credit card is verified and the customer’s account is charged when the order is placed. Orders are rejected if the card cannot be charged.

Required

Design a relational database system that Niven might use for its products and orders. Identify the tables, fields, and primary and foreign keys that would be part of the database.