zaber.blogg.se

The Orders table in MySQL Northwind databaseĩ. The Shippers table in MySQL Northwind databaseĨ. The Employees table in MySQL Northwind databaseħ. The Customers table in MySQL Northwind databaseĦ.

The Products table in MySQL Northwind databaseĥ. The Suppliers table in MySQL Northwind databaseĤ. The Categories table in MySQL Northwind databaseģ. If you are not familiar with relational database design, you can get a quick start withĢ. Order Details - transaction details of each order such as products, unit price and quantity, discount applied.Įntity relationship diagram for Northwindīelow is a simplified relational view of the Northwind database.Orders - information about each order such as the customer who placed the order, employee who handled the order, order and shipment date, which shipper made the shipment, etc.Shippers – companies who ship products from Northwind Traders to its customers.Employees - people who work for Northwind Traders.Customers - buyers of Northwind products.Products - the products Northwind Traders buys and sells.Suppliers – who supply products to Northwind Traders.Categories - list of product categories.Various tutorials have been created around this database, including concepts about indexes,Ĭonstraints, foreign keys, normalization, SQL queries, relational database design concept, etc. The following 8 tables exist in MySQL Northwind database. The database contains business data for a period of two years so it makes learning SQL queries much easier, especially for summarizing data, aggregation, and even trend analysis. Our MySQL Northwind database has kept in line with standard relational database concept and structure with real world business scenarios. What does the MySQL Northwind database contain? We converted the famous Northwind database to MySQL and use it as the the basis for most of the tutorials on this site. In the Northwind database while you're learning and developing ideas for Access applications. Sales data for a fictitious company called Northwind Traders, which imports and exports specialty foods from around the world. The Northwind database was first released in Microsoft Access Database as a sample database with data already pre-populated.