The Sales and Stock Management Information System has to be designed and developed for any shop. The main aim of this project should be to computerization of daily activities in the shop. The project contains several objects to record the details about the Product, Customer details, Order details and Bill details about the goods which the Customer has purchased from the shop. The system is recording new products (addition, modification, deletion).

The system should provide the following information

1. Display a detailed list of all the products in the shop
2. Who are customers and what is the frequency of their visit to the shop
3. Generate a list of all the orders on a specific date
4. Display all the bills of highest revenue generating customers
5. Which products sales is more than the average sales of all the items

Required:
1) Identify  Entities, Elements and attributes

2) Identify Meta data

3) Normalize your tables up to 3rd normal form

4) Create table and insert 3 records (PostgreSQL)

5) Write PostgreSQL queries for the given problems                                              

1. Display a detailed list of all the products in the shop
2. Who are customers and what is the frequency of their visit to the shop
3. Generate a list of all the orders on a specific date
4. Display all the bills of highest revenue generating customers
5. Which products sales is more than the average sales of all the items