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 upcoming tests.

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:
{{/Labs/03/Images/ERD_full.svg}}

If you haven’t already done so, you’ll complete the details for the Measurement and Measurement Type tables later in this lab.

You will need to have implemented the Scientist,Sample, and Site tables to start this lab

You’ll also need the water quality CSV data file and the sample data form from Lab 02 on Blackboard. Download copies of these if you don’t have them already.