IT 403-Database System for A Wholesale Management System Question- SEU .

Project Database 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)