Kapalı

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.

Beceriler: Veri Tabanı Yönetimi, Veritabanı Programlama, MySQL, Oracle, SQL

Daha fazlasını gör: 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

İşveren Hakkında:
( 4 değerlendirme ) bogra, Bangladesh

Proje NO: #19161352

Bu iş için 10 freelancer ortalamada $36 teklif veriyor

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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(46 Değerlendirme)
6.3
digidreamstech

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

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(35 Değerlendirme)
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 Daha Fazla

$35 USD in 3 gün içinde
(27 Değerlendirme)
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 Daha Fazla

$111 USD in 5 gün içinde
(3 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 gün içinde
(0 Değerlendirme)
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,

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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.

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
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 Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0