The database has only 3 tables:
The table design is as follows:
Column Name | Data Type | Width | Constraints |
UserName | Text | 15 | Primary Key |
Password | Text | 15 | Required |
Column Name | Constraints |
UserName | Primary Key1 |
Foreign Key from User table | |
FriendName | Primary Key2 |
Foreign Key from User table |
Column Name | Constraints |
UserName | Primary Key1 |
Foreign Key from User table | |
BlockedUserName | Primary Key2 |
Foreign Key from User table |
The following figure shows the relationships and dependencies between tables: