We will use this database in our PostgreSQL tutorials so make sure that you have it on your server. This tutorial introduced you to a PostgreSQL sample database named DVD rental. You can download and print the ER diagram for reference while practicing with PostgreSQL. Open the file and click the Vuerd icon in the upper right corner of the Editor window or right click on file -> Open editor. Download printable ER diagramīesides the sample database, we also provide you with a printable ER diagram in PDF format. The database file is in zipformat ( dvdrental.zip) so you need to extract it to dvdrental.tar before loading the sample database into the PostgreSQL database server. You can download the PostgreSQL DVD Rental sample database via the following link: address – stores address data for staff and customers.store – contains the store data including manager staff and address.film_category- stores the relationships between films and categories.category – stores film’s categories data.film_actor – stores the relationships between films and actors.film – stores film data such as title, release year, length, rating, etc.actor – stores actors data including first name and last name.There are 15 tables in the DVD Rental database: The DVD rental database has many objects including:ĭVD Rental ER Model PostgreSQL Sample Database Tables The DVD rental database represents the business processes of a DVD rental store. We will use the DVD rental database for demonstrating the features of PostgreSQL. Summary: in this tutorial, we will introduce you to a PostgreSQL sample database that you can use for learning and practice PostgreSQL.
0 kommentar(er)
