Summary: in this tutorial, we will introduce you to a PostgreSQL sample database that you can use for learning and practice PostgreSQL.
We will use the DVD rental database for demonstrating the features of PostgreSQL.
I am trying to learn SQL development using SQL Server 2008 R2 Database Management Studio. I was trying to model a car rental company, where clients can rent cars, and I have to know which client has rented which car on which date, and also the date the car was returned.
- Free Excel Inventory Template for Rental Businesses If you are a business owner of a rental business where you rent equipment or assets to your customers, you will find this template handy in tracking inventory. This Excel rental inventory management template can help you know how many items are in stock and how many have been rented out.
- This is a car rental template that is available for download in a PDF format. This particular template can be easily customized for car owners who wish to rent their cars for a short duration of time. You can fill in the blanks in areas such as fee details, travel limitation, registration number, and other such rental agreements.
- Designed as a simple reservation management system for SME vehicle rental agencies. Created as a test harness for our e-Bridge travel distribution product, but fully functional for use by operators, car, bike, bus rental agencies. OTA Vehicle is e-Bridge ready, so it can be connected directly to your website via an online booking engine.
The DVD rental database represents the business processes of a DVD rental store. The DVD rental database has many objects including:
- 15 tables
- 1 trigger
- 7 views
- 8 functions
- 1 domain
- 13 sequences
DVD Rental ER Model
PostgreSQL Sample Database Tables
There are 15 tables in the DVD Rental database:
- actor – stores actors data including first name and last name.
- film – stores film data such as title, release year, length, rating, etc.
- film_actor – stores the relationships between films and actors.
- category – stores film’s categories data.
- film_category- stores the relationships between films and categories.
- store – contains the store data including manager staff and address.
- inventory – stores inventory data.
- rental – stores rental data.
- payment – stores customer’s payments.
- staff – stores staff data.
- customer – stores customer data.
- address – stores address data for staff and customers
- city – stores city names.
- country – stores country names.
Download PostgreSQL sample database
Car Rental Database Template Letter
You can download the PostgreSQL DVD Rental sample database via the following link:
The database file is in zipformat ( dvdrental.zip) so you need to extract it to dvdrental.tarbefore loading the sample database into the PostgreSQL database server.
Download printable ER diagram
Car Rental Template Free Download
Besides the sample database, we also provide you with a printable ER diagram in PDF format. You can download and print the ER diagram for reference while practicing with PostgreSQL.
Rental Car Receipt Template
This tutorial introduced you to a PostgreSQL sample database named DVD rental. We will use this database in our PostgreSQL tutorials so make sure that you have it on your server.