Newer
Older
labs / tiddlers / content / labs / lab04 / _Labs_04_Continue work on second assignment and prepare for next lab.md

You should now have data in three of the five tables, and you should be getting close to completing the CREATE TABLE statements for the two remaining tables (Measurement and Measurement Type). Once you’ve created these two tables, use the skills you learned in this lab to populate them with data as well. Data for the Measurement table are in the CSV file, but you’ll need to think carefully about how to handle outlier values. You’ll need to generate appropriate data for the Measurement Type table based on the types of measurement shown on the sample data form from Lab 03.

In the next two labs, you’ll learn how to retrieve data from a database. If you want to get a head start, you can experiment with SQL’s SELECT statement.
Here are some useful links:

• Oracle’s SQL Language Reference
https://docs.oracle.com/cd/E11882_01/server.112/e41084/toc.htm
• Documentation for Oracle’s SELECT statement (caution: extremely detailed!)
https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_10002.htm#SQLRF01702
• An online SQL tutorial that’s a bit more lightweight and interactive
https://www.w3schools.com/sql/