Sales Database

The Sales database stores the following information. A customer might place some order. An order contains some item$($s$).$ An item is a product made by some manufacturer who might offer warranty for the product. If no warranty is provided, the warranty# will be NULL. The database involves the following relations where primary keys are underlined and arrows indicate foreign keys:

Sales