The Scope of the Project is to design a database of a Community Portal Similar to Linkedin.com. Once the user registers on the portal all the data will be stored in the database.
- User table has one to one relation with User profile as user profile is a weak entity.
- User table has many to many relation between send message and send friend request as it is many to many relation there’s a bridge in between with columns such as status and time.
- User Table has many to many relation with Jobs Table so there is a bridge in between which has application status with status and time.
- Jobs has one to many relation with companies and jobs is a part of company.
- Admin has many to many relation with companies and the bridge table contains the verification status
