DVD Rental Shop

--Description--

DVD Rental Shop is a backend system designed to manage a DVD rental business.
It allows users to manage clients, movie inventory, rental orders, and customer reviews.

The system simulates real-world rental shop operations, including tracking availability of movies and handling customer requests.

--Technologies--

• Java
• PostgreSQL

--Features--

Client management

• Add new clients
• View and manage client list

Movie inventory

• Add new movies to the stock
• Update and manage movie availability

Orders system

• Create and manage rental orders
• Track order status
• Wishlist functionality for clients

Reviews

• Clients can leave reviews for rented movies

--Database--

The project uses PostgreSQL as the database system.

Database structure and sample data are included in dvd_rental_shop.sql