Assume you are creating a database for IS paint store. The database needs to support the following business functions.
· Allow customers to browse the inventory. Customers want to search by paint types and colors. Customers also wants to know pricing information.
· A customer can be a regular customer (e.g., home owner), or a contractor or painting professionals. Different customers can get different discounts for the same type of paint. We assume each customer can get the same discount for all types of products in this store.
Place this order or similar order and get an amazing discount. USE Discount code “GET20” for 20% discount
