Discussion

Our society relies on data more and more every day! Where is it stored? How is it accessed? These are general questions that will be answered along your journey through this course. Relational databases:

Please respond to all of the following prompts:

Placing comments in your program at creation is one of many ways to make your program as efficient as possible.

• Describe a situation in which you have used a database recently.
• Explain the primary purpose of a primary key in a database.

Lab assignment

Using SQL, get specific rows, using the in condition to specify a particular set of values.

Using the class example database (SQLFUN), create the required SQL statements to produce the following results:

From the L_foods table:

1. List the description and price values of the following foods:
   • Hamburger
   • French Fries
   • Soda
2. Sort the rows by the description.

From the L_foods table:

1. Create a new table containing the following columns from the L_foods table:
   • menu_item
   • description
   • price
2. Change the name of the description column to food.
3. Include all the foods that cost less than $5.00.