mysql database

Job Description:

Question 1

Write stored procedures in SQL to implement the purchase and sale transactions.

The purchase transaction inputs are : vendor_id, date, product_id, qty, purchase_price ...]

// more than one product can be purchased at a time from a vendor

The purchase transaction creates a record of the purchase in appropriate tables.

The sale transaction inputs are : customer_id, date, product_id, qty, sale_price ...]

// more than one product can be sold at a time to a customer.

The sale transaction creates a record of the sale in appropriate tables.

You can assume a given set of products, customers, and vendors and make sample data on your own to test the transactions.

Submit a snapshot of your database with sample data, and the results of executing sale and purchase transactions.

Question 2

Write a stored procedure to generate a stock report for a date range.

select stock_report (date1 date, date2 date);

This report shows the following columns

product_id product_name opening_balance qty_in qty_out qty_net closing_balance_date2

The report calculates opening balances from "beginning of time" to date1, then computes qty_in and qty_out using purchases and sales respectively, then calculates qty_net by qty_in and qty_out between date1 and date2 and finally computes the closing balance on date2.

You may need to write multiple sql statements inside the body of the stock_report stored procedure.

You can use any language for database programming, including PLV8 (embeddeded javascript), PL/SQL or any other embedded language embedded in a SQL server.

Bonus : Can you make the report more efficient ?

Submission Guidelines

Taidot: MySQL, Tietokantaohjelmointi

Tietoa asiakkaasta:
( 0 arvostelua ) Vizianagaram, India

Projektin tunnus: #35460636

11 freelanceria on tarjonnut keskimäärin ₹1366 tähän työhön


Hi I have 15 years of experience in SQL server Database development, MySQL development, postgress development. Reporting using power bi. Expert in performance tuning. Programming using python and C#. I will be able to Lisää

₹7000 INR 1 päivässä
(7 arvostelua)

Hello there, I have read your requirements and am confident I am the right candidate for the job. Among other things, I have over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and others NoSQL. F Lisää

₹650 INR 7 päivässä
(2 arvostelua)

Im very interested in this job , i'am good in mysql programming.

₹625 INR 10 päivässä
(0 arvostelua)

Hello I'm data engineer using python and Java with 3 years experience in data field. I did a lot of data projects so don't worry about anything let's talk for more details

₹2000 INR 7 päivässä
(0 arvostelua)

Hi, i'm a software engineer with several years of experience working in IT and solving problems exactly like the one you're presenting, so let me help you with the project, i know exactly how to do it. Looking forward Lisää

₹625 INR 3 päivässä
(0 arvostelua)

Can i send you the answer of the question? , after seeing the code tell me, whether you are satisfied or not ok?

₹625 INR 7 päivässä
(0 arvostelua)

I have a experience in, MVC, web API, c#, SQL, entity framework,linq, razor view (Cshtl), html, bootstrap,Angular JS, Jquery, Json,XML, reports (PDF,xls, crystal, rdlc,ssrs).

₹625 INR 1 päivässä
(0 arvostelua)

Hi I'm Ishwarya Lakshmi currently working as a Trainee Intern in Edgearc Technology from may 2022. I have good knowledge in MS SQL Server,T SQL, SSIS, SSRS and Power BI. I have experience in designing Analytical report Lisää

₹625 INR 7 päivässä
(0 arvostelua)

Hello there ,I have 7 years experience in dealing with Database , SQL, Oracle, database programming, database development , I had read the above project details, kindly ping me for more details. I am working as etl de Lisää

₹1000 INR 1 päivässä
(0 arvostelua)

Interested in this job ! I worked a lot with pl/sql and sql I can finish it in less than 24 hours Just need more details

₹625 INR 3 päivässä
(0 arvostelua)