This repository is intended to store sample data structures for the databases mentioned below.
StackEdit stores your files in your browser, which means all your files are automatically saved locally and are accessible offline!
The MySQL sample database schema consists of the following tables:
- Customers: stores customer’s data.
- Products: stores a list of scale model cars.
- ProductLines: stores a list of product line categories.
- Orders: stores sales orders placed by customers.
- OrderDetails: stores sales order line items for each sales order.
- Payments: stores payments made by customers based on their accounts.
- Employees: stores all employee information as well as the organization structure such as who reports to whom.
- Offices: stores sales office data.
Entity Relationship Model
taken from https://www.mysqltutorial.org/mysql-sample-database.aspx
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.
Entity Relationship Model
taken from https://www.postgresqltutorial.com/postgresql-getting-started/postgresql-sample-database/