Scribd
Upload
10 views3 pages

Movie Database Management System

The document outlines the development of a Movie Database using a Database Management System (DBMS) to efficiently store and manage movie-related information. It discusses the relational model for organizing data, normalization techniques to ensure accuracy, and the use of SQL for data retrieval. Additionally, it highlights the scalability and security features of the database, making it suitable for large platforms like IMDb and Netflix.

Uploaded by

chennailover058
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
10 views3 pages

Movie Database Management System

The document outlines the development of a Movie Database using a Database Management System (DBMS) to efficiently store and manage movie-related information. It discusses the relational model for organizing data, normalization techniques to ensure accuracy, and the use of SQL for data retrieval. Additionally, it highlights the scalability and security features of the database, making it suitable for large platforms like IMDb and Netflix.

Uploaded by

chennailover058
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

ABSTRACT

In today's digital world, people watch a lot of movies and shows, which creates a need for
organized and reliable storage of movie information. A Movie Database using a Database
Management System (DBMS) is a smart way to manage this data. It helps store and handle
details like movie titles, actors, directors, genres, languages, and release dates in an easy and
secure way.A DBMS allows users — like developers, researchers, or regular viewers — to
search for movies, find actor or director info, or generate reports by genre. Big platforms like
IMDb, Netflix, and Hulu use advanced databases to manage their large collections and suggest
content to [Link] database usually follows a relational model, where data is kept in tables.
Each table stores specific information, like one for Movies, one for Actors, and one for
Directors. For example, a movie table might include the title, release date, language, genre, and
director. If one movie has many actors, a special table (like Movie_Actor) is used to link movies
and [Link] database is designed to avoid repetition and ensure accuracy by following rules
like the Third Normal Form (3NF). Users can use SQL (Structured Query Language) to search
for data, such as finding all movies of a certain genre or listing actors who worked with a
[Link] also offers security by giving different access levels — like allowing admins to
add or edit data while regular users can only view it. It also supports backups to protect against
data [Link], a movie database can grow easily. New movies, actors, or genres can be added
without changing the whole structure, making it scalable and future-ready.
CONTENTS

Abstract

CHAPTER 1 INTRODUCTION Page No.

1.1 Overview 1

1.2 Problem Statement 2

1.3 Objectives 3

1.4 Features of Proposed System 4

CHAPTER 2 BACK-END DESIGN

2.1 Modules 5

2.2 Conceptual Database Design 6-7

2.3 Logical Database Design 8-9

2.4 Normalization 10

2.4.1 First Normal Form 11

2.4.2 Second Normal Form 12

2.4.3 Third Normal Form 13

CHAPTER 3 FRONT-END DESIGN

3.1 HTML 14

3.2 CSS 15

CHAPTER 4 IMPLEMENTATION

4.1 MySQL 16-26


CHAPTER 5 TESTING 27-29

CHAPTER 6 SNAPSHOTS 30-32

CHAPTER 7 APPLICATION 33-34

CHAPTER 8 CONCLUSION 35

LIST OF FIGURES
Figure No. Figure Name Page No.

2.2.3 ER Diagram 7

2.3.3 Schema Diagram 9

6.1 Front Page 30

6.2 Login Page 30

6.3 Sign Up Page 31

6.4 Home Page 31

6.5 Movie Fig For Inception 32

LIST OF TABLE
Table No. Table Name Page No.

2.4.1 First Normal Form 10

2.4.2 Second Normal Form 11

2.4.3 Third Normal Form 12

5.4 Example Test Cases 29

You might also like