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.
The DVD rental database represents the business processes of a DVD rental store. The DVD rental database has many objects including:
To review the tables in the SofiaCarRental database: On the File menu, click Connect Object Explorer.; In the Connect to Database Engine dialog box, type either localhost or the name of the local SQL Server instance, and then click Connect.; In the Object Explorer window, expand the node for the newly connected instance, then expand Databases, expand SofiaCarRental, expand Tables, and review. This lesson shows how to programmatically perform database operations in Microsoft Access. Example Application: Bethesda Car Rental Introduction: Bethesda Car Rental is a fictitious company that rents cars (vehicles) to customers. The company has many employees who take care of cars, customers, related transactions, and other maintenance tasks. Car Rental Agreement Template This Car Rental Agreement Template is useful to any car rental, rent-a-car, or other vehicle rental service, and now you can save time and money getting contracts signed online. Car Lease Agreement Template Your customers can decide to lease a car from anywhere and you want them to sign it from anywhere. ER diagram for car rental system is a visual presentation of entities and relationships of car rental software database.You can edit this template and create your own diagram. Creately diagrams can be exported and added to Word, PPT (powerpoint), Excel, Visio or any other document.
- 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
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
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.
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.
Exceltemplates.org – Managing car rental reservation will be easier with the help of a special sheet of car rental. There are two main sheets that can be used in running the business of car rental reservation. The first sheet will be about the availability of rented cars while the other one is about the detail information on the customers who rent the cars. The two main sheets of car reservation will be great to be used every day in order to keep the reservations tidy and well organized and eventually bring the customers’ satisfaction. There is nothing better than customers who will show a huge smile after the service.
This car rental reservation is different from other spreadsheets you may find online. It has calendar layout with color markers. Those color markers represent the number of car availability at particular dates. This spreadsheet is fully editable. You can learn all functions in this spreadsheet to give you ideas on how to create similar spreadsheet to meet your specific needs.
How to Use Car Rental Reservation Spreadsheet
Since this spreadsheet is a simple spreadsheet, you might know how to use it once you open it. There are three worksheets. But, you may work on two worksheets only. Calendar worksheet contain dates, filled manually, for one year period. There are color markers where you can their values by replacing numbers in red, orange, yellow and green color boxes at the bottom of the calendar. This color marker is created using conditional formatting function where it get values from availability column in Year Schedule worksheet.
The availability column contains formulas. It sums “1” numbers across particular rows. Each car will have its own column. Type “1” if particular car is available and type other texts (like client name or any) or leave it blank. It is to prevent SUM function to sum numbers other than 1 in particular rows. There are color markers for your references.
Car Rental Database
The third worksheet is additional worksheet. It contains car information only. It has no formula links to other worksheets. Because this spreadsheet is a basic spreadsheet, you can modify and extend it to meet your needs. You can add more worksheets, extend car columns and add more important information regarding your car rental business. Also, you can make its layout to follow your business signatures.
To remind you, to change this calendar to another year, you need to type those dates manually. It should be easy. Copy calendar dates from other calendars and paste it as values in particular fields. Do not paste it directly since it will break the conditional formatting formulas.
Car Rental Checklist Template
Using Microsoft Excel to simplify your spreadsheet tasks is not as difficult as you think. I learned how to use it in less than 24 hours and rely on internet to find the solution if I got stuck. I am not an Excel expert, but here are all useful spreadsheets I have collected and created.