ICT320-Database Programming

3 SQL Scripts: Script 1:

Create one SQL script that is used to create the database and insert the data in the appropriate tables. Name this script as CreateFirstname_idnumber.sql (where Firstname is your first name and idnumber is your student ID number).

Script 2: This script should incorporate the extra features of the database. Save this as Extraidnumber.sql

Script 3: The second script is to include SQL statements that will clear the whole database (ie remove all data and tables etc). Save this as DeleteFirstname_ idnumber.sql.