**Course Title:** SQL Mastery: From Fundamentals to Advanced Techniques **Section Title:** Final Project Preparation and Review **Topic:** Overview of final project requirements and expectations You have now covered a wide range of topics in SQL, from the fundamentals of databases and SQL syntax to advanced techniques in query optimization, indexing, and database security. As we near the end of the course, it's time to take on the final project that will help you apply your knowledge and skills to real-world scenarios. **Final Project Overview** The final project is designed to test your ability to design, develop, and optimize a database using SQL. You will be given a scenario that requires you to apply the concepts and techniques learned throughout the course. **Project Requirements** For this project, you will be working as a database administrator for a fictional e-commerce company called "Online Shopping Pro." The company sells products online and needs a database to store customer information, product details, orders, and sales data. Your task is to design and develop a database that meets the following requirements: 1. **Database Design:** Create a database schema that includes the following entities: * Customer * Product * Order * Order Item * Sales 2. **Entity Relationships:** Define the relationships between the entities using primary and foreign keys. 3. **Table Structure:** Create tables for each entity, including columns for the required attributes. 4. **Data Population:** Insert sample data into each table to test the database. 5. **Query Development:** Write queries to perform the following tasks: * Retrieve sales data for a specific product * Find customers who have ordered a particular product * Get the total sales for each month * Retrieve product details for a specific category 6. **Indexing and Optimization:** Create indexes to optimize query performance. 7. **Security and Permissions:** Set up user roles and permissions to ensure data security. **Project Deliverables** To complete the project, you will need to submit the following: 1. **Database Schema:** A diagram or ERD showing the database schema. 2. **SQL Code:** The SQL code used to create the tables, insert data, and write queries. 3. **Query Results:** The results of the queries executed on the sample data. 4. **Indexing and Optimization:** A brief explanation of the indexes created and how they optimize query performance. 5. **Security and Permissions:** A brief explanation of the user roles and permissions set up. **Expectations** To pass the final project, you are expected to: * Design a database schema that accurately represents the e-commerce company's requirements * Write efficient and effective queries to retrieve data * Optimize query performance using indexing techniques * Demonstrate an understanding of database security and permissions * Submit high-quality documentation that explains your design and implementation decisions **Additional Resources** To help you with the project, refer to the following resources: * [W3Schools SQL Tutorial](https://www.w3schools.com/sql/) * [SQL Fiddle](http://sqlfiddle.com/) * [DBMS Normalization Tutorial](https://www.tutorialspoint.com/dbms/dbms_normalization.htm) **Submission Guidelines** Please submit your final project as a single file in .pdf or .docx format. The file should include all the deliverables mentioned above. **Grading Criteria** The final project will be graded on the following criteria: * Database schema design (20 points) * SQL code and query writing (30 points) * Indexing and optimization (20 points) * Security and permissions (10 points) * Documentation and presentation (20 points) **Need Help or Have Questions?** If you have any questions or concerns about the final project, please feel free to ask in the comments section below. You can also ask for help with specific aspects of the project, such as database design or query writing. Good luck with your final project!