- insert, update, delete
Working with Database Structures
- creating tables
- table columns
- Keys & Indexes
- Altering Structures
Assignment – Due April 10
- Read about Inner Joins
- Complete reading and examples in Chapter 5 – pages 162-176 – Basic SQL
- Read & examples in Chapter 6 – pages 179-222 – Database Structures
Use the Workbench Scratchpad for the examples. Also use the Create/Alter table interface in MySQL Workbench where appropriate in chapter 6.
- Project 1: The music database needs to be able to track the LABEL that releases every album. Add a table to the database and insert several rows – such as:
Motown | Detroit | MI
EMI | London | UK
Capitol Records | Los Angeles | CA
The table should have a primary key and a foreign key relationship to the album table. Make the appropriate changes to the album table structure and data to include label information for every album.
Send me an email including:
a) any sql statement you used to create or alter the database tables.
b) a listing of the albums in your record collection sorted by label.
- Quiz 1