Data Manipulation Language (DML)
It is very common to have to populate a new database with an existing set of data. This can be because the new system replaces an older one and the data needs to be preserved, or because the new system requires a minimal set of data before it can be used. Sometimes these sets of data can be quite large, and it is useful to have some simple methods for handling them.
This week you will be using Excel and a text editor to insert a large amount of data into the sightings database that you created last week. The first stage is to prepare the database by removing last week's data and creating some sequences and triggers to maintain synthetic keys.