After a short quiz on your homework, we will begin a tutorial on using SQL to create a small database.

Next we will begin learning to use SQLite using SQLite Tutorial.

Download the following two files before you start:

1. chinook.db
2. chinook_db_diagram.pdf

We will now confirm that the sqlite3 command interpreter works on your laptops, and begin learning to use it to intereact with the sample database you just downloaded.

Continue working through the tutorial you started today in class for homework. Come to class on Monday ready to work with your group to create a small database that models data at ACC.

Think about the following questions as you work your way through the examples:

1. What is a table and how does it correspond to something in the world outside a computer?
2. What is a field (column) in a table? What does it respresent? What is a record (row) in a table, and what does it represent?
3. What kind of thought process would you need to use to design your own database tables?

We will begin class with a Thinkflex activity. During the group brainstorming part of this activity, please observe the five golden rules of creative thinking processes:

• Every idea is allowed. The more spontaneous, the greater the success.
• Do not make any judgements during the brainstorming process!
• Taking up already expressed ideas is encouraged!
• The more ideas, the better for the problem solution.
• Interactions with each other must be respectful.

During the second half of class we will present the group websites that we made in class last week. The focus of each presentation should be to demonstrate that your group website meets each of the four requirements listed for you to earn an A for your project.

Watch the following video lectures from the Basic SQL lesson:

• How Databases Work
• Elizabeth Fong: Creating the SQL Database Standards

Take notes on a single sheet of 8 1/2 by 11 inch paper, which you can use on a short quiz on these two videos that you will take at the beginning of class on Thursday. (*Note:* You could also type up the notes and print them before coming to class.)