IT 403 SEU Database System for A Wholesale Management System Question Solution Studyhelp247
1 attachmentsSlide 1 of 1attachment_1attachment_1
Unformatted Attachment Preview
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
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
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:
Design the database- following an ER model.
Tables before Normalization.
Tables after Normalization
Use MySQL or any other database to create the normalized tables and
populate your tables with at least 5 rows.
e) Execute the requested sample queries.
a) ER Diagram
b) Tables before the Normalization
c) Tables after the normalization (At least in 3NF)
Purchase answer to see full
User generated content is uploaded by users for the purposes of learning and should be used following Studypool’s honor code & terms of service.