Question

Screenshots from MySQL (or any other software you use) of all the tables after queries result

sorry no spam i will be reported

no copy and paste i want complete answer with Screenshots

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 at least)
. Using the info below toCreate the Normalized Tables and Populate them with at least 5 Rows
. Using the info below toWrite the Wholesale Management System requested Queries & Execute them

Screenshots from MySQL (or any other software you use) of all the 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 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 amoun

Answer 1

1. In order to find both payment paid and pending customers you can directly use this query

select name from Wholesale;   //* Name columns represents customer name and Wholesale represents Table name *//

2. To get customers with pending amount we have to apply where condition

select name from Wholesale where payment="pending"; //* Payments column represents whether the payments is paid or not *//

3. select name, address, id from Wholesale;  //* As database consists of all the mentioned columns *//

4. In order to find the customer not having any assigned department apply where condition as null

select name from Wholesale where department=Null;

5. As the database directly consists of " stock that is to buy if quantity goes less than a particular amount" we can have direct query like this assuming stock as a column with values satisfying the mentioned condition

select stock from Wholesale;