I have been asked to create to application to support sales

Question

I have been asked to create to application to support sales and marketing fun of company that manufactures and sales computer server cabinets.as a part of application you will create server database tht will support recording sales transaction.as a proof of concept you will create some sample forms and quries that will demonstrate how this web application might be fun as decision support system for sales and marketing department.

step 1:create table

product

customer

order

product table(product no.(int)primary key

description(varchar)

price(int)

customer(cust no.(int)primary

customer name varchar

address varchar

zipcode varchar

phone var

email var

order

order no.(int)primary

customer no( fk)

product no.(pk)

sales amount (double)

order date (date)

sales type(varchar)

payament type varchar

card type

card no.

expiry date

step2:

enter appropriate data into tables

step3:

create forms:

step4:

create queries

sales and marketing depart would like to these data use data for purpose querying db in order to get answers to spcific questions

such as 1.list customer info for all cust in nasik

2.list customer info.for customers who purchase 3 story cabinets

3.list customers who purchase cabinet using passport credit card

4.create reports

after u have enter data in 3 tables and queries. create reports for displaying tables and queries.reports are designed to be used and viewed by other users hence they must be informative.use formatting tools and be creative