Topic: Creating database and running queries
Is this model capable of answering the following queries ?
1.Display the details of the current items of carpet in stock
2. Search for the details of a particular carpet to check the Quantity in stock
3. Display the suppliers who provide particular carpets (search by carpet code)
4. Check the number of orders a customer has made to allocate a discount
percentage to that customer (example if > 1 apply 10% discount, if > 3 apply
20% discount) **(I am not sure how to show this correctly)**