Screenshots from MySQL (or any other software you use) of allthe tables after queries result
sorry no spam i will be reported
no copy and paste i want complete answer withScreenshots
no handwriting
thanks for your efforts and time
Using the info below, write a query SQL
Using the info below to Normalize the Tables (in 3NF atleast)
. Using the info below toCreate the Normalized Tables and Populatethem with at least 5 Rows
. Using the info below toWrite the Wholesale Management Systemrequested Queries & Execute them
Screenshots from MySQL (or any other software you use) of allthe tables after queries result
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 has to buythe 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 pendingamount after the due date So List of payment paid or pending.
o The stock that is to buy if quantity goes less than aparticular amount.
o Profit calculation for a month.
o Quantity cannot be sold to a customer if the required amountis not present in stock and date of delivery should be maintainedup 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 theirpending amount.
3. Find the details of customers name, address, id.
4. Find Query to get information of employee where employee isnot assigned to the department.
5. List the stock that is to buy if quantity goes less than aparticular amoun
