Over the next few weeks, you’ll explore ways to create databases to store and manipulate data in a consistent manner. This week, we’ll look at how to manipulate data in a database, focusing on the Create (SQL INSERT) and Delete (SQL DELETE) data manipulation operations.
It’s in your interest to make notes in this lab, as the notes will help you with the practical tests.
Task 0: Scenario and setup
Today’s lab continues the water quality scenario from where you left off last time. You’ll need to complete Lab 03 before you can complete the tasks in this lab. You created tables corresponding to the Scientist, Sample, and Site entities in the following ERD:
If you haven’t already done so, you’ll complete the details for the Measurement and Measurement Type tables at the end of this lab in preperation for next weeks lab. This lab focuses on the Scientist, Sample, and Site tables.
You’ll also need the water quality CSV data file and the sample data form from Lab 04 on Blackboard. Download copies of these if you don’t have them already.