#Sqlite for mac output mac os
#Sqlite for mac output install
#Sqlite for mac output zip file

For example, this is a row from the table:Ĭontains details for a product. For example, this is a row from the table:Ĭontains information about the individual products within an order. For example, this is a row from the table:ĩ|Dodsworth|Anne|Sales Representative|Ms.|.ĬREATE TABLE IF NOT EXISTS 'EmployeeTerritory'Ĭontains mappings between employees and which territories they are responsible for:Ĭontains information about orders. LAMAI|La maison d'Asie|Annette Roulet|Sales Manager|.įor this assignment, we will not be using CustomerCustomerDemo or CustomerDemographic EmployeeĬontains information about employees.

For example, this is a row from the table: For example, this is a row from the table:Ĭontains details of a customer. CategoryĬontains details for a category of goods. The output should look like the example below for each table. schema $TABLE_NAME command on the sqlite3 terminal for each table. Get familiar with the schema (structure) of the tables (what attributes do they contain, what are the primary and foreign keys). You should see fourteen tables, and the output should look like this:ĬustomerCustomerDemo OrderDetail Supplier

Check the contents of the database by running the.

Note that the database file be 31MB after you decompress it.

Unzip the database from the provided database dump by running the following commands on your shell.

Load the Database DumpĬheck if sqlite3 is properly working by following this tutorial.Ĭheck its MD5 checksum to ensure that you have correctly downloaded the file:į4fd955688d0dd9b5f4799d891f3f646 northwind-cmudb2021.db.gz You can upgrade it, if you absolutely need to, with Homebrew.

#Sqlite for mac output mac os

On Mac OS Leopard or later, you don't have to! It comes pre-installed. Not support the SQL features that you need to complete this assignment. Make sure that you are using at least SQLite version 3.25! Older releases (prior to 2019) will

#Sqlite for mac output install

You will first need to install SQLite on your development machine. The grading scripts will not work correctly unless you do this.

#Sqlite for mac output zip file

The -j flag lets you compress all the SQL queries in the zip file without path information. $ zip -j submission.zip placeholder/*.sql Placeholder FolderĬreate the placeholder submission folder with the empty SQL files that you will use for each question:Īfter filling in the queries, you can compress the folder by running the following command: It will likely take you approximately 6-8 hours to complete the questions.

For each question, you will need to construct a SQL query that fetches the desired data from the SQLite DBMS. The homework contains 10 questions in total and is graded out of 100 points. This is a single-person project that will be completed individually (i.e., no groups). This homework is an opportunity to: (1) learn basic and certain advanced SQL features, and (2) get familiar with using a full-featured DBMS, SQLite, that can be useful for you in the future. For this, you will look into the Northwind sample database. The first homework is to construct a set of SQL queries for analysing a dataset that will be provided to you.