A comprehensive Movie Management System that organizes and manages movie-related data, including genres, production companies, directors, producers, actors, and more. The system also features a graphical user interface (GUI) to simplify interaction with the database.
This project implements a robust database for managing movies and related information such as genres, production companies, directors, producers, actors, and users. The database schema ensures data integrity and provides features like triggers to enforce constraints and cascade rules.
The database is accompanied by a GUI for user-friendly interaction, making it easier to manage data and perform CRUD (Create, Read, Update, Delete) operations.
-
Database Tables:
Genres: Manage movie genres.ProductionCompanies: Store production company details.Producers: Manage producer information.Directors: Store director details.Movies: Store and manage movies with metadata such as rating, runtime, and plot.Actors: Manage actor profiles.MovieCast: Track actor roles in movies.Users: Manage user accounts.Admins: Handle admin accounts.
-
Triggers:
- Ensure valid
DateOfBirthfor actors. - Handle dependent records when deleting a movie.
- Ensure valid
-
Data Integrity:
- Validation using
CHECKconstraints. - Relationships using
FOREIGN KEYconstraints.
- Validation using
-
GUI:
- User-friendly interface for managing database entries.
- Simplifies CRUD operations.
- Real-time interaction with the database.
- Database: MySQL
- GUI Framework: (Specify the framework used, e.g., Java Swing, PyQt, Tkinter, etc.)
- Programming Language: SQL, (Specify the language used for GUI, e.g., Python, Java, etc.)
- Triggers and Constraints: Enforce data integrity.
- MySQL Server (version 8.0 or later)
- GUI Framework dependencies (install relevant dependencies based on the framework used for the GUI)
This project is licensed under the MIT License. See the LICENSE file for details.