Home Online Database ERD Activity 1 Activity 2 Activity 3 Activity 4 Activity 5 Activity 6 Activity 7

Activity 7: Changing the structure of the database by adding, altering or dropping tables of data.

Investigate

First start by learning about SQL by reading through the following web pages:

Practice

Use the Online Database to perform the following queries:

DescriptionSQL QueryResults
Modify the products table to add one new field to store the quantity available in stock, using an integer value, with a default value of 1. Update all existing records to make sure their stock level is set to 1.
Create a new table called "advertisingCampaigns" to store information such as: campaignID, StartDate, EndDate, TypeOfCampaign, Country, Description. Add a new campaing as follows: 1, 01/01/2016, 29/02/2016, Radio Advert, USA, National campaign to promote our services in the USA.