Skip to content

Latest commit

 

History

History
33 lines (25 loc) · 2.18 KB

README.md

File metadata and controls

33 lines (25 loc) · 2.18 KB

SQL_Cinema

This Film Wiki project is a fully responsive web application designed to manage information about movies, actors/actresses, movie directors, roles and film genres.

Project Contents

  • Conceptual Data Model (CDM): Designing the structure of the database by modeling entities such as films, actors/actresses, movie directors, roles and film genres.
  • Mockups: Contains mockups and wireframes created using Figma for the user interface of the application.
  • Database: Setting up a MySQL database using tools like HeidiSQL and PHPMyAdmin to store and manage the project's data.
  • SQL Queries: Includes SQL queries for performing various tasks such as fetching movie details, listing films by duration, counting movies by genre, etc.
  • User Interface (UI): Developing the user interface using HTML, CSS, JavaScript and PHP to enable users to interact with and perform actions like viewing, adding, modifying, and deleting films, actors, directors, and other entities.
  • Docker: Implementing Docker to containerize the MySQL database and development environment, ensuring a portable configuration that can be easily deployed across different systems.

Technologies Used

  • PHP
  • HTML, CSS and JavaScript for the User Interface (UI)
  • MySQL with HeidiSQL for the database
  • Figma for the mockups
  • Looping (Conceptual Data Modeling)
  • Docker

More illustrations