Home‎ > ‎CIS 54‎ > ‎

Lab 5 - Normalization


In this lab you'll do exercises demonstrating your understanding of normalization. 

Chapter Questions and Exercises

Answer the "Queen Anne Curiosity Shop Project Questions" starting on page 116. 

Practice Your Selects

Use a select statement to answer the following questions:
  1. How many Starbuck's are there in Santa Cruz county? 
  2. What is the only restaurant in Live Oak? 
  3. What restaurants have problems where the resolution has been verified? 
Submit the SQL select statement that gave you the answer (not the answer itself).

Turn In

Turn in the answers to the questions on Canvas 


  • 10 points for the questions
  • 10 points for the SQL select statements.
Subpages (1): Lab 5 Answers