SQL Backend for Movie Review Platform
Budget: ₹1,000 – ₹5,000 INR
I'm looking for an experienced SQL database developer to design and build a MySQL backend for a movie review website. The system will store information about media titles, critics, and their reviews. Reviews will be marked as positive or negative, and the system will calculate a score (as a percentage of positive reviews) for each title.
Key Requirements:
- Design and normalize the database (with ER diagrams).
- Create tables for critics, reviews, ratings, and media.
- Add SQL views and queries to extract insights (e.g. top-rated shows).
- Implement basic triggers or stored procedures to auto-update scores.
- Populate the tables with sample data for testing.
The project must be completed within 1 week. Ideal skills and experience include:
- Expertise in MySQL and database design
- Experience with ER diagrams and normalization
- Ability to create SQL queries, views, triggers, and stored procedures
- Familiarity with media review systems
Key Requirements:
- Design and normalize the database (with ER diagrams).
- Create tables for critics, reviews, ratings, and media.
- Add SQL views and queries to extract insights (e.g. top-rated shows).
- Implement basic triggers or stored procedures to auto-update scores.
- Populate the tables with sample data for testing.
The project must be completed within 1 week. Ideal skills and experience include:
- Expertise in MySQL and database design
- Experience with ER diagrams and normalization
- Ability to create SQL queries, views, triggers, and stored procedures
- Familiarity with media review systems