PHP-Based Movie Database Management System

FThis is the project from the Database Management course in my undergrad. The project theme was planned using IMDb movie data as an example. I used PHP along with the built-in phpMyAdmin to perform the core database operations: 'Create, Read, Update, Delete' (CRUD). Additionally, ensured the ACID properties of the data (Atomicity, Consistency, Isolation, Durability).
Github Repo Link: CaslowChien/IMDb_database_manage_system

My Contribution

Conducted web scraping on Taiwan’s leading college student social media platform, to collect and analyze data, identifying key insights for a company's market expansion strategy.
Built a data scraping pipeline for Taiwan’s largest social forum, reducing manual data collection time from 4 weeks to just a few minutes.

Final DEMO Slides

Data Ingestion

I first gathered movie data, then cleaned it into tables ready for storage.

Database Design

I designed a Graphical User Interface (GUI) web application that allows users with different authorization levels to edit or view the data. I also ensured the SQL logic was correct.

Co-coding

As a front-end engineer on this project, I needed to communicate extensively to ensure our code was compatible.