Closed

Few MySQL statements for existing MySQL database

I need the following for a basic DB with dummy data project

Using ERD and Database which will be provided, I need to develop and populate a real life Relational Database (with dummy data) to hold business data and ALSO a Data Mart to support the reporting requirements of the Databse that I will provide. In order to implement this Data Mart I need you to automate the loading of the data from the live production database to the Data Mart. This should be done by scripting.

documentation needs to be break down as follows:

Project Report Document

a. Background Information Document and relevant graphs connected via Excel to each report defined below.

b. Script File to Create the Data Mart database and tables

c. Script file to populate the Data Mart tables

d. Scripts to complete the following reports

Reports and scripts for the following queries need to be provided

1. Show all transactions for a given week in your business. (Stored Procedure)

2. Create a trigger that stores stock levels once a sale takes place.

3. Create a View of stock (by supplier) purchased by you.

4. Total stock sold to general public (by supplier). (A Group By with Roll-Up)

5. Detail and total all transactions for the month-to-date. (A Group By with Roll-Up)

6. Detail and total all revenue for the year-to-date. (A Group By with Roll-Up)

7. Detail & total transactions broken down on a monthly basis for 1 year. (A Group By with Roll-Up)

8. Display the growth in sales/services (as a percentage) for your business, from the 1st month of opening until now.

9. Use a reporting tool of your choice to connect to your data and create a graphical representation of each of your previous SQL report results.

10. Add both the SQL statements and graphs into a Word document report.

Skills: Database Administration, Database Programming, MySQL, Oracle, SQL

See more: front end database mysql, database mysql con link mp3, importing large database mysql, mysql create table, mysql workbench, mysql create view from multiple tables, mysql create view example, mysql create database, mysql create or replace table, mysql example, mysql tutorial, add existing database mysql, import existing database folder mysql, mysql document tracking database, php mysql document archive database, order product online stores database mysql php, mysql document management database, creat document database mysql, import existing mysql database mysql database, document java programming database mysql

About the Employer:
( 4 reviews ) bogra, Bangladesh

Project ID: #19161352

10 freelancers are bidding on average $36 for this job

kipdev13

Nice to meet you. I've read the task description and can develop definitely. I'll provide you with the highly skill to complete this task in time. I'll also do my best for you. Please contact with me. Thank you ve More

$35 USD in 1 day
(46 Reviews)
6.3
digidreamstech

Hello, I have checked the requirements. We can discuss further on this task in more details in PM. Thanks.

$30 USD in 1 day
(35 Reviews)
5.8
AliSafder

Dear Sir, My name is Ali and I can complete the project with immediate availability. Let us have a quick discussion over the project so I can work and finish the job. To discuss the project I am available in t More

$35 USD in 3 days
(27 Reviews)
4.4
jayantavkumar

I am a database / Business Intelligence / solution architect. I have more than 14 years of experience in various technologies as mentioned below: Database - SQL Server, Oracle, MySQL BI - Microsoft MSBI and Inform More

$111 USD in 5 days
(3 Reviews)
1.8
funnydata

Hello, Hope you are doing well. I came across the project and liked it. I have successfully completed multiple projects in the same field. Please feel free to visit my LinkedIn profile where i have elaborated on my sk More

$25 USD in 1 day
(0 Reviews)
0.0
ZeroDeAlkhalily

take a look in my profile to do my skills and i 'll finish all problems in your database in one day best regards

$20 USD in 2 days
(0 Reviews)
0.0
ashermuneer26

Hi, Hope you are doing well. I have 2+ years experience with this and I can do this easily. just contact me to do this asap. looking forward for your response. regards,

$25 USD in 1 day
(0 Reviews)
0.0
tudorpirau

Hello, I have a great experience with SQL databases(MySQL, POSTGRESQL, ORACLE). I can help you to find a solution. Regards, Tudor.

$25 USD in 1 day
(0 Reviews)
0.0
VishalAgrawal11

Hi,I have read your requirements of Few MySQL statements for existing MySQL database and I’m pretty confident that I will be able to get your work done within the given time your requirements conclude. I am very keen t More

$25 USD in 1 day
(0 Reviews)
0.0
SeandyAdhitia

Hi, I'm a C# Senior programmer that works for one of the Software house in Jakarta. My daily jobs is create C# application for banking company and custom application for individuals. Please take a look at my LinkedIn P More

$30 USD in 1 day
(0 Reviews)
0.0