Projectaty MySQL Database Schema:

In this project, there exists 4 diffrent entities with diffrent attributes:

Entities:

1. Student: StudentID (Primary Key), username, password(sha), email
2. Project: ProjectID (Primary Key), Title, Description(optional), Deadline (Date), PrivacySetting (Public, Private), and CreatorID (Foreign Key referencing Student)
3. Team: TeamID (Primary Key), ProjectID (Foreign Key referencing Project), MemberID (Foreign Key referencing Student)
4. Task: TaskID (Primary Key), ProjectID (Foreign Key referencing Project), Title, Description (optional), Status (Incomplete, Complete), AssignedTo (Foreign Key referencing Student)

Relationships:

1. One Student can create multiple Projects.
2. One Project can have multiple Teams.
3. One Student can be a member of multiple Teams.
4. One Project can have multiple Tasks.
5. One Task is associated with one Project and can be assigned to one Student.

Entity Relationship Diagram: