Download CV

Utopolis Cinema Database Project

Introduction

This project involved designing and implementing a comprehensive database for Utopolis Cinemas. The aim was to modernize the cinema's software for ticket sales, film programming, and infrastructure management.

Project Overview

The project encompassed creating a top-down database design including a conceptual model, relational model, and physical model in PostgreSQL. The database supports cinema complex management, film scheduling, ticket reservations, and customer interactions.

Objectives

  • Conceptual Model: Develop a UML diagram for business entities and their relationships.
  • Relational Model: Translate the conceptual model into a relational schema with normalization and integrity constraints.
  • Physical Model: Implement the database schema in PostgreSQL and populate it with realistic test data.

Technology Stack

  • PostgreSQL: For database implementation and management.
  • SQL Data Modeler: For designing conceptual and relational models.
  • IntelliJ/PGAdmin: For database development and management.

Challenges and Learnings

  • Database Design: Creating a robust database schema to handle complex cinema operations.
  • Data Management: Populating the database with realistic test data to simulate real-world scenarios.
  • System Integration: Ensuring that the database integrates seamlessly with the cinema's software systems.

Conclusion

This project provided hands-on experience in database design and implementation, crucial for modernizing cinema management systems. It also demonstrated the importance of a well-structured database in supporting complex business operations.