#Northwinds database sql download#

Lets run a cURL command line query to get a particular Order. Microsoft built Northwind as a fully functional and.

#Northwinds database sql download#

What does the Northwind data look like in our NoSQL database? Are you interested in learning Microsoft Access Download the sample Northwind Access database. The same 'automagic' navigation tools are provided for all the relations in our data model. Navigate to any Product shows all Order-details for that particular product.ДЄnd if you click on the Order-Details tab, you will see all associated records. The screen shot below shows the Order-detail view with the finished mappings against both Orders and Customers.ДЄs we now have a data schema that 'knows' about the relations between our collections, restdb.io provides us with some really useful productivity features. to create a relation between Orders and Order-details we navigate to the Order-detail collection and change the OrderIDfield to a Lookupthat refers to Orders with foreign key OrderID. The mapping process described here is repeated for all the relations we wish to map.Д®.g. Note that we also need to select the Advanced option and then pick the foreign key field from the Customers collection ( CustomerID). We then select the CustomerID field, and change it from a textdata type to a Lookup to Customers. The screen shot below shows all the fields on the Orders collection. First we switch to Developer mode (button in the upper right corner) and then navigate to Orders / settings. In order to create relations we must change the schema of our database. The next step is to start the mapping of the relations. We can also see the CustomerID column that refers to a column in the Customer collection. When we navigate to the Orders collection, we can see that the data has been imported correctly. All in all it counts 6635 records (or Documents, as we say in NoSQL speak). The screen shot below shows the import of orders and the mapping of the data fields.ДЄfter we've imported all data files, we can see the newly created collections and the count of their data records. Just click the Import button on the restdb.io database dashboard. Thanks to a GitHub project we found, we save time and get a nice set of CSV files from a data dump from the Northwind database. 13 tables and 13 relations, we will try to re-create this in a modern NoSQL document schema. The Nortwind relational data schema is shown in the picture below.