MYSQL database

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.