Design the database schema to store users (students and instructors), teams, and their roles. This schema will support login functionality and team management
Task Breakdown:
Create User Table: Fields should include id, email, password, role (student or instructor).
Create Team Table: Fields should include team_id, team_name, and instructor_id.
Create User-Team Association Table: To link students to teams with fields user_id, team_id.
Implement Relationships: Set up foreign key constraints between users and teams.
Test Schema: Insert sample data to test relationships and data integrity.
Design the database schema to store users (students and instructors), teams, and their roles. This schema will support login functionality and team management
Task Breakdown: