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.