Contains 11 tables of customer, employee, album, track, and sales data and is available in formats such as SQLite, MySQL, and PostgreSQL. The database is used for teaching database management and SQL querying.

• Customers: Fictitious customer data.

• Employees: Information about sales agents.

• Sales: Data on invoices and line items.Music catalog: Tracks, albums, artists, and genres, derived from a real iTunes library.

• Other tables: Media types and playlists.

The database includes multiple schemas, each representing different functional areas of the business.

• Production: Manages the product catalog, inventory, and manufacturing details.

• Sales: Contains information on sales transactions, customers, and sales territories.

• Person: Holds personal and contact information for individuals associated with the company, such as employees and customers.

• HumanResources: Manages employee and department information.

• Purchasing: Tracks procurement, vendors, and purchase orders.

• dbo: Includes miscellaneous system tables and logs.

The Northwind sample database includes 14 tables, and their relationships are shown in the following entity-relationship diagram.

• Suppliers: Suppliers and vendors of Northwind

• Customers: Customers who buy products from Northwind

• Employees: Employee details of Northwind traders

• Products: Product information

• Shippers: The details of the shippers who ship the products from the traders to the end-customers

• Orders and Order_Details: Sales Order transactions taking place between the customers & the company