SAKILA: Elegant Database Website + App

SAKILA is a well-known open source database provided by Oracle. The objective of our project was to showcase our ability in designing a fully-functional "interface" for interacting with the content of the database. We developed both a web version (hosted on Mercury) and an app counterpart of the software. All functionalities were integrated into the app design such that the user is given complete flexibility in dealing with the data including query functionalities and data manipulation operations via the aid of elegant U.I. components.

Technologies Used

HTML, PHP, CSS, SQL & JS

Achievements/Tasks

Developed a fully functional application for interacting with and modifying the database flexibly using a wide range of intuitive GUI components which also allows users to make complex queries using DQL and DML operations at the backend

Implemented a secure login and registration system using MySQLi to store user information

Optimized the application for different devices and views