Niven Co. manufactures ornamental flamingoes. The flamingoes are sold to wholesalers who then sell the goods to retailers. The flamingoes come in a variety of colors, sizes, and materials. Niven produces its products once an order is received. Each order is treated as a job and the company tracks costs using a job-order system.

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