Homework answers / question archive / Please find below SQL Project instructions:  You have to submit 2 files : 1

Please find below SQL Project instructions:  You have to submit 2 files : 1

Computer Science

Share With

Please find below SQL Project instructions:  You have to submit 2 files :

1.            SQLite file( .sqbpro): In this, you need to submit all the answers to all the questions for Part-1(SQLite) in a sequential manner. You will be evaluated for part-1 based on this file.

2.            MySQL file( .SQL): In this, you need to submit all the answers to all the questions for   Part-2(MySQL) in a sequential manner. You will be evaluated for part-2 based on this file.

•             Any assignment found copied/ plagiarized with another person will not be graded and marked as zero.

•             Please ensure timely submission as a post-deadline assignment will not be accepted.

Project Problem Statement:

You are hired by a chain of online retail stores “Reliant retail limited”. They provided you with “orders” database and seek answers to the following queries as the results from these queries will help the company in making data-driven decisions that will impact the overall growth of the online retail store.

1st part(Q1-Q6) comes under SQLite and queries should be executed in DB Browser. (Database used- New Orders.db)

2nd part(Q7-Q10) comes under MYSQL and the queries should be executed in MYSQL. (SQL Script used - new Orders.sql)

Note: In case the file gets open in the browser, Please copy the entire text(including comment) and paste it on MySQL workbench. Execute all the commands to create a database schema. In case, if you are able to download the file, please use MySQL Workbench, File>open SQL Script>new orders.SQL and then execute all the statements to create a database schema.

All Questions carry 8 marks. Total Marks (8 x 10) = 80

Please refer to this link to download the Project with all the queries and instructions - Project Orders (SQLite & MYSQL) 13may .pdf

Important Note: Please reflect on all that you have learned while working on this project. This step is critical in cementing all your concepts and closing the loop. Please write down your thoughts here.