Database Requirements:
Click review system allows user to give reviews about school they have studied or they are currently studying. Each Review submitted has Review ID, first name, lastname, DOB, email, nationality, and school name. Email will be unique for all users
Each user can post one review on one school. School can have many reviews from different students.
Review submitted also contains Faculty Rating, Facility Rating, Staff Rating, Comments, recommendation and DATETIME.
Review also has Verification status and Post status.
Reviews are either verified by schools and by online platform
Reviews posted are managed by admin users
Each School has a unique id, name, address, email, contact person name and phone number, username and password
Each user can post one review on one school. School can have many reviews from different students.
Review has review id, school name, user email, and user name, comments , date, verification status and post status.
User can choose to post review as ANONYMOUS if they wish
Click review system has different admin users who will assess review content before posting it on web app. Admin users have id, name, email, username and password
After review has been submitted it will sent to school for verification. If review is verified it will posted on to school main page as verified review. Else if school doesn’t verify or do not respond 3working days it will posted as unverified.
Verified status can only be authorized by school.
It is only Admin Users who can post or delete any review.
*************START RIGHT NOW*************
HI
I can make a review system with the above requirements within 72 hours. I will provide you unlimited revisions and full support after completion of the project
thanks
sourav