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.

Evner: Database Administration, Programmering af database, MySQL, PHP, Software Arkitektur

Se mere: php mysql contacts database, php mysql soccer database, mysql huge database import, lightweight mysql database download, mysql database download, mysql community server, mysql database tutorial, oracle mysql download, mysql download for windows, mysql workbench, download mysql database for ubuntu, mysql convert database utf8, php mysql relational database frontend, mysql ecommerce database example, mysql extract database, mysql hotel database reservations select dates, mysql registration database, php mysql photo database, php mysql students database, create mysql email database

Om arbejdsgiveren:
( 0 bedømmelser ) Dublin, Ireland

Projekt ID: #18985422

Tildelt til:


*************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 Flere

€24 EUR in 3 dage
(6 bedømmelser)

5 freelancere byder i gennemsnit €30 på dette job


[login to view URL] I will provide you complete solution with unique design and development time as per your requirement. Complete end to end solutions, from Development to testing and marketing, we do it al Flere

€55 EUR på 1 dag
(25 bedømmelser)

Hi Hope you are doing great. I have 7 Years of exposure on web development. I mainly worked with java,Spring,Hibernate,JBPM,Php,Oracle,MySQL,MongoDb. I deal anything on Web and my orientation towards business layer Flere

€19 EUR på 1 dag
(4 bedømmelser)

Hi, How are you? I'm Hardik Kotecha. I've over 12 years of experience in Data Analytics, Visualization and Administration. I was in Chicago for 8 years working for Sears at their corporate headquarter as a Data Flere

€30 EUR på 1 dag
(0 bedømmelser)
€23 EUR på 1 dag
(0 bedømmelser)