PDSND SQL Project on Investigate a Relational Database
Date created
Created on 04 June,2020
Project title
Udacity Programming for Data Science Nanodegree Program Investigate a Relational Database
Description
In this project, I’ll query the Sakila DVD Rental database. The Sakila Database holds information about a company that rents movie DVDs. For this project, I’ll be querying the database to gain an understanding of the customer base, such as what are the patterns in movie watching are across different customer groups, how they compare on payment earnings, and how the stores compare in their performance. To assist the queries ahead, the schema for the DVD Rental database is provided.
The DVD rental database represents the business processes of a DVD rental store. The DVD rental database has many objects including:
- 14 tables
- 1 trigger
- 7 views
- 8 functions
- 1 domain
- 13 sequences
Tables:
- actor – stores actors data including first name and last name.
- film – stores films 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 customers data.
- address – stores address data for staff and customers
- city – stores the city names.
- country – stores the country names.
Files used
Source: http://www.postgresqltutorial.com/postgresql-sample-database/
Supporting Materials DVD Rental ERD: https://sp.postgresqltutorial.com/wp-content/uploads/2018/03/dvd-rental-sample-database-diagram.png
Credits
Thank you Udacity for providing the course and the necessary material for me to develop this project.
Sources of help and inspiration:
https://www.w3schools.com/sql/
Author @vikashryder