Overview
After completing the Language Learning Platform project, I realized I wanted to deepen my understanding of databases. This project, Movie Review Database, was my opportunity to explore and improve on that front.
This was a team project in our Database Systems class and served as a fantastic opportunity to learn more about designing and working with databases. One major takeaway from the Language Learning Platform was our lack of database design experience. The schema we designed for that project was fragmented, with many lonely tables that had minimal relationships. This time, I was determined to address that issue and create a more cohesive and interconnected database structure. The project is live at: Movie Review Database.
The GitHub repository for this project is available at: MovieDB Repository.
Details
The Movie Review Database project focused on:
- Designing and implementing a relational database schema to manage movies, reviews, users, and ratings.
- Developing a user-friendly interface for accessing and managing movie reviews.
- Ensuring robust relationships between tables, avoiding isolated data structures.
- Implementing CRUD operations for seamless interaction with the database.
Technologies Used
- Database: PostgreSQL
- Backend: Express.js
- Frontend: HTML, CSS, and JavaScript
- API Interaction: Axios
Team Contributions
- Srija: Designed and implemented the SQL for reviews and created the reviews page.
- Jeffin: Created the SQL queries for the search functionality.
- Nguyen Anh Nguyen (Me): Built upon Jeffin’s work by adding SQL for other types of filters to enhance the search functionality.