Develop a Wholesale Management System Database
Your DB will keep track of medical equipment used in hospitals
Cardiopulmonary bypass device
LASIK surgical machine
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
Blood gas analyzers
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.
You are free to choose the name of your store and GUI design.
Make sure that you do not share your idea/code/interface design/etc. with other students. Similarities will be flagged as plagiarism and both of you will get an F.
Use MySQL to create your DBs.
Use either Java/PHP/any language/any tool to create a GUI for your system. Your system MUST have a user-friendly interface.
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.
14 freelanceria on tarjonnut keskimäärin $223 tähän työhön
ello dear, We are group of professional mysql database tutors expert and can solve any questions within given time because we are in top 2% here so just text me so we can help you out with your task Kind regards
Hello I can finish this job in 3 days as a full-stack web developer. If you give me the assignment, I will satisfy you with good results. Please do share more details via chat for discussion. Thanks
ESTEEMED CUSTOMER! I can perfectly do the Data base I make sure my clients are 100% satisfied with the writings. I am a professional writer with proven track record. You can also see my reviews as well Thank You