IT 403 SEU Database System for A Wholesale Management System Question

ProjectDatabase system for a Wholesale Management System
Consider a database system for a Wholesale Management System. The data requirements are
summarized as follows:
o Maintain the details of stock like their id, name, quantity.
o Maintain the details of buyers from which manager must buy the stock like buyer
id, name, address, stock id to be bought.
o Details of customers i.e., name, address, id.
o Defaulters list of customers who have not paid their pending amount after the due
date So List of payment paid or pending.
o The stock that is to buy if quantity goes less than a particular amount.
o Profit calculation for a month.
o Quantity cannot be sold to a customer if the required amount is not present in
stock and date of delivery should be maintained up to which stock can be
provided.
SQL Queries:
1. List of payment paid or pending customers.
2. Find the Defaulters list of customers who have not paid their pending amount.
3. Find the details of customers name, address, id.
4. Find Query to get information of employee where employee is not assigned to the
department.
5.
List the stock that is to buy if quantity goes less than a particular amount.
•
This project worth 10 marks and will be distributed as in the following:
a)
b)
c)
d)
Design the database, following an ER model.
(3 marks)
Tables before Normalization.
(1.5 marks)
Tables after Normalization
(1.5 marks)
Use MySQL or any other database to create the normalized tables and
populate your tables with at least 5 rows.
(2 marks)
e) Execute the requested sample queries.
(2 marks)
your project
a) ER Diagram
b) Tables before the Normalization
c) Tables after the normalization (At least in 3NF)