Designing a Database Portfolio using MySQL Workbench

Task 1: Database Design (Week 1): Participants will design a simple relational database using MySQL Workbench. Include at least three tables with appropriate relationships. Specify data types for each column in the tables.

Task 2: Data Manipulation (Week 2): Populate the tables with sample data. Create SQL queries to retrieve specific information from the database. Use basic SELECT statements to filter, sort, and aggregate data.

Task 3: Database Modification (Week 3): Implement changes in the database structure using SQL. Update existing records and insert new data. Demonstrate the use of DELETE statements.

Task 4: Documentation (Throughout): Document the database schema, including tables, relationships, and data types. Include comments in SQL code for clarity.