- SQL
- MySQL Workbench
- GitHub
- Microsoft Excel (for visualization and PDF generation)
The TerpBuy SQL Project is a comprehensive database design and implementation project for a mock B2B and B2C e-commerce platform. It demonstrates the creation of database schema, insertion of sample data, and execution of analytical queries to simulate real-world database operations for business reporting.
- Database Schema Design: Logical design of tables with primary and foreign keys to maintain data integrity.
- Sample Data Population: Insertion of realistic sample data for departments, categories, products, customers, orders, and order lines.
- SQL Queries for Reporting: Analytical queries to extract meaningful insights such as sales trends, customer behavior, and product performance.
- Documentation: Comprehensive documentation in the form of an execution PDF outlining the queries and their purposes.
TERPBUY PROJECT.sql: SQL script containing database schema creation, sample data insertion, and query execution.SQL TERPBUY.pdf: Documentation detailing the database schema, queries, and results.
- MySQL: Database management system for schema creation and query execution.
- GitHub Projects: For project management and tracking progress.
- View customer and order details.
- Analyze product sales and revenue by category.
- Calculate average shipping performance.
This project was managed using GitHub Projects. Key steps included:
- Setting up the TerpBuy database schema.
- Inserting realistic sample data.
- Writing SQL queries for business analysis.
- Preparing the SQL query execution PDF.
- Uploading the project to GitHub.
If you'd like to contribute to this project, please fork the repository, make changes, and submit a pull request.
For any questions or suggestions, feel free to reach out via GitHub or email at yahyazamindar7@gmail.com.
Feel free to customize the file further based on your preferences or specific repository content. Let me know if you'd like additional sections!