Homework answers / question archive / Develop a Wholesale Management System Database Your DB will keep track of medical equipment used in hospitals Ventilators Cardiopulmonary bypass device Dialysis machine Infusion pumps LASIK surgical machine Medical lasers Consult 120 Urine Analyzer Urine Reagent Strips 10 Parameter Consult Liquid Urine Control Plastic urine containers, sterile or unsterile Conical centrifuge tube, 15 ml Microscope slides and 1 coverslip Clinical Centrifuge Flow cytometers Blood gas analyzers Electrolyte analyzers Differential counters Coagulation analyzers Slide strainers Magnetic resonance imaging (MRI) Your system will: Maintain the details of stock like their id, name, quantity

Develop a Wholesale Management System Database Your DB will keep track of medical equipment used in hospitals Ventilators Cardiopulmonary bypass device Dialysis machine Infusion pumps LASIK surgical machine Medical lasers Consult 120 Urine Analyzer Urine Reagent Strips 10 Parameter Consult Liquid Urine Control Plastic urine containers, sterile or unsterile Conical centrifuge tube, 15 ml Microscope slides and 1 coverslip Clinical Centrifuge Flow cytometers Blood gas analyzers Electrolyte analyzers Differential counters Coagulation analyzers Slide strainers Magnetic resonance imaging (MRI) Your system will: Maintain the details of stock like their id, name, quantity

Computer Science

Share With

---

Develop a Wholesale Management System Database

Your DB will keep track of medical equipment used in hospitals

Ventilators

Cardiopulmonary bypass device

Dialysis machine

Infusion pumps

LASIK surgical machine

Medical lasers

Consult 120 Urine Analyzer

Urine Reagent Strips 10 Parameter

Consult Liquid Urine Control

Plastic urine containers, sterile or unsterile

Conical centrifuge tube, 15 ml

Microscope slides and 1 coverslip

Clinical Centrifuge

Flow cytometers

Blood gas analyzers

Electrolyte analyzers

Differential counters

Coagulation analyzers

Slide strainers

Magnetic resonance imaging (MRI)

Your system will:

Maintain the details of stock like their id, name, quantity. Include 20 items in your DB

Maintain the details of buyers from which the manager has to buy the stock like buyer id, name, address, stock id to be bought. Include 20 names in your DB

Maintain the details of customers name, address, telephone number, id. Include 30 names in your DB

Display a report with the Defaulter’s list of customers who have not paid their pending amount.

Display a report with the List of payments paid

Display a report with the List of payments pending.

Display a report with the List of the stock that is to buy if quantity goes less than a particular amount (10 items).

Display a report with the Profit calculation for a month.

Produce a warning or error if the Quantity cannot be sold to a customer if the required amount is not present in stock and the date of delivery should be maintained up to which stock can be provided.

Produce a warning if a customer who have not paid their pending amount is requesting more items.

Produce a warning when the quantity of an item goes less than a particular amount.

 

 

Instructions:

 

You are free to choose the name of your store and what you sell.

Make sure that you do not share your idea with other students. Similarities will be flagged as plagiarism and both of you will get an F.

Your store should be unique and is about something you like.

Use MySQL to create your DBs.

Use either Java or PHP to create a GUI for your system.

Upload one Word document (zipped if size is large). You will receive a zero (0) if you upload any other document type. Remember it needs to be a word document .docx or .doc

Your document must consist of the following and divided to the following sections. The content of sections must be in the correct order and place. I will not look for content and if it is not labeled correctly or if it is not placed in the correct order, you will get a zero for that section.

Report sections / Grading matrix

 

 

 

Section #

 

Item

Max score

Completed Yes/No

Score

1

 

Title page with the following information: your name, project title, semester and year, course name and number, instructor name, and name of store

 

1

2 Project description. What you are selling and list the software, tools, programming languages used.

 

1

 

 

 

 

 

3

 

List of queries (you can copy and paste the SQL code from MySQL)

 

5

 

 

 

 

 

4

 

Print screen of the interface (Java  or PHP) used to enter a new details of stock like their id, name, quantity. Include 20 items in your DB

 

 

 

5

 

 

 

 

 

5

 

Print screen of the interface (Java  or PHP)used to enter the details of buyers from which the manager has to buy the stock like buyer id, name, address, stock id to be bought. Include 20 names in your DB

 

 

 

5

 

 

 

 

 

6

 

Print screen of the interface (Java  or PHP) used to enter the details of customers name, address, telephone number, id. Include 30 names in your DB

 

 

 

5

 

 

 

 

 

7

 

Print screen of the table attributes Maintaining the details of stock like their id, name, quantity. Include 20 items in your DB

 

 

 

5

 

 

 

 

 

8

 

Print screen of the table  attributes Maintaining the details of buyers from which the manager has to buy the stock like buyer id, name, address, stock id to be bought. Include 20 names in your DB

 

 

 

5

 

 

 

 

 

9

 

Print screen of the table attributes Maintaining the details of customers name, address, telephone number, id. Include 30 names in your DB

 

 

 

5

 

 

 

 

 

10

 

Print screen of the table content Maintaining the details of stock like their id, name, quantity. Include 20 items in your DB

 

 

 

5

 

 

 

 

 

11

 

Print screen of the table  content Maintaining the details of buyers from which the manager has to buy the stock like buyer id, name, address, stock id to be bought. Include 20 names in your DB

 

 

 

5

 

 

 

 

 

12

 

Print screen of the table content Maintaining the details of customers name, address, telephone number, id. Include 30 names in your DB

 

 

 

5

 

 

 

 

 

13

 

Prints screen of a report (produced by Java or PHP) with the Defaulter’s list of customers who have not paid their pending amount.

 

 

 

5

 

 

 

 

 

14

 

Prints screen of a report (produced by Java or PHP) with the List of payments paid

 

 

 

5

 

 

 

 

 

15

 

Print screen of a report (produced by Java or PHP) with the List of payments pending.

 

 

 

5

 

 

 

 

 

16

 

Prints screen of a report (produced by Java or PHP) with the List of the stock that is to buy if quantity goes less than a particular amount (10 items).

 

 

 

5

 

 

 

 

 

17

 

Print screen of a report (produced by Java or PHP) with the Profit calculation for a month.

 

 

 

5

 

 

 

 

 

18

 

Print screen of the Produced warning when an error occurs if the Quantity cannot be sold to a customer if the required amount is not present in stock and the date of delivery should be maintained up to which stock can be provided.

 

 

 

3

 

 

 

 

 

19

 

Print screen of the Produced warning when a customer who have not paid their pending amount is requesting more items.

 

 

 

3

 

 

 

 

 

20

 

Print screen of the Produced warning when the quantity of an item goes less than a particular amount.

 

 

 

3

 

 

 

 

 

21

 

Conclusion. Reflect on your experience completing this project as an individual. The good and the bad. The time spent. Anything new you learned on your own

 

4

 

 

 

 

 

22

 

copy of Java code or PHP code

 

 

 

10

Upload the WORD document or the zipped WORD document to this drop box by the deadline.