Database schema for a customer sale database scenario


Database schema for a customer sale database scenario:

customer(cust_id,cust_name) primary key(cust_id).

Item(item_id,item_name,price) primary key(item_id)

Sale(bill_no,bill_date,cust_id,item_id,qty_sold) primary key(bill_no),foreign key(cust_id),foreign key(item_id).

1) Create the tables with appropriate integrity constraints.Insert around 10 records in each of the tables.

2) List all the bills for the current date with the customer name and item_no.

3) List the total bill detail with the quantity sold,price of the item and final amount.

4) List the details of the customer who have brought a product which has a price>200.

5) Give a count of how many product have been brought by each customer.

6) Give a list of product brought by a customer having cust_id as 5.

7) List the item details which are sold as of today.

Request for Solution File

Ask an Expert for Answer!!
Database Management System: Database schema for a customer sale database scenario
Reference No:- TGS01272275

Expected delivery within 24 Hours