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.
All the work that you do today contributes towards completing the second assignment.
It’s in your interest to make notes in this lab, as the notes will help you with the required components of the assignment.
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 as part of your work for the second assignment. 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.