Welcome to the final project of the SQL course! This project is designed to consolidate and apply the knowledge you have gained throughout the course. By working on a comprehensive, real-world scenario, you will demonstrate your proficiency in SQL and your ability to solve complex data-related problems.

The main objectives of this final project are:

1. Apply SQL Skills: Utilize the SQL skills you have learned, including querying, data manipulation, and performance optimization.
2. Design and Implement a Database: Create a well-structured database schema that meets the project requirements.
3. Perform Data Analysis: Extract meaningful insights from the data using advanced SQL queries.
4. Optimize Queries: Ensure that your queries are efficient and optimized for performance.
5. Document Your Work: Provide clear documentation of your database design, queries, and analysis.

You have been hired as a database developer for a fictional company, "Tech Solutions Inc." The company needs a database to manage their customer information, orders, and products. Your task is to design and implement this database, populate it with sample data, and perform various queries to analyze the data.

1. Tables:

   • Customers: Store customer information such as customer ID, name, contact details, and address.
   • Products: Store product information such as product ID, name, description, price, and stock quantity.
   • Orders: Store order information such as order ID, customer ID, order date, and total amount.
   • OrderDetails: Store details of each order, including order ID, product ID, quantity, and price.

2. Relationships:

   • Each customer can place multiple orders.
   • Each order can contain multiple products.
   • Each product can be part of multiple orders.

• Populate the tables with sample data. Ensure that there is enough data to perform meaningful analysis (at least 50 customers, 100 products, and 200 orders).

1. Basic Queries:

   • Retrieve a list of all customers.
   • Retrieve a list of all products.
   • Retrieve a list of all orders.

2. Advanced Queries:

   • Find the top 5 customers who have placed the most orders.
   • Find the top 5 products that have been ordered the most.
   • Calculate the total sales for each product.
   • Calculate the total sales for each customer.

3. Performance Optimization:

   • Create indexes to optimize the performance of your queries.
   • Analyze the performance of your queries and make necessary adjustments.

• Provide a detailed explanation of your database design, including the schema and relationships.
• Document the SQL queries you used for data analysis.
• Include any performance optimization techniques you applied.

1. Database Schema: A SQL script to create the database schema.
2. Sample Data: A SQL script to populate the database with sample data.
3. SQL Queries: A document containing the SQL queries used for data analysis.
4. Performance Analysis: A report on the performance of your queries and the optimization techniques applied.
5. Project Report: A comprehensive report documenting your database design, queries, and analysis.

Your project will be evaluated based on the following criteria:

1. Database Design: The structure and relationships of your database.
2. Data Population: The accuracy and completeness of your sample data.
3. Query Accuracy: The correctness and efficiency of your SQL queries.
4. Performance Optimization: The effectiveness of your performance optimization techniques.
5. Documentation: The clarity and thoroughness of your documentation.

This final project is an opportunity to showcase your SQL skills and demonstrate your ability to design, implement, and analyze a database. Take your time to carefully plan and execute each part of the project. Good luck, and we look forward to seeing your completed work!