database systems
Hormework. 1.Introduction In this assignment, you will write 501. queries that answer questions about a database containing information about northwind. The data in this homework is a version is a version of the Microsoft Access 2000 Northwind sample database, re-engineered for 5Q Lite3. The Northwind sample database was provided with Microsoft Access as a tutorial schema for managing small business customers, orders, inventory, purchasing, suppliers, shipping, and employees. Northwind is an excellent tutorial schema for a small-business ERP, with customers, orders, ifventory, purchasing. suppliers, shipping, employees, and single-entry accounting. All the TABLES and VIEWS from the MSSQL-2000 version have been converted to Sqlite3 and included here. Included is a single version prepopulated with data. Should you decide to, you can use the included python script to pump the database full of more data. 2. SETTING UP SQLITE Please follow the instructions to set up SQuITE on your computer Or the Youtube video to setup SQuITE on your computer (windows) https-//www youtube com/watch ivawx+22213 ke8t=331s Or the Youtube video to setup SQLITE on your computer (mac) https-/Www youtube com/watchilvayyirhntrkiDA 3.Check if SQLite3 is properly working on your computer by following this tutorial 4.Download the data which name is northwind db from Blackboard 5. Check the contents of the database by running the tables command on the sqlite 3 terminal. 6. Create a folder by using the following command mkdir HOMEWORKI 7.move northwind.db to HOMEWORK1 8. Check the contents of the database by running the tables command on the sqlite 3 terminal. You should see fourteen tables More details are listed on the picture 9. Get familiar with the structure of the tables (what attributes do they contain, what are the primary and foreign keys). 10. To see more details on the orders, you should run 11.To count how many rows in Order table make sure to use quotation marks around it f SUBMUSSON Paste screenshot for atep 811 to a Microsoft ward document. Then save it es peff. Secbunit Pof
