The lesson is to be followed in class, and the game given as homework.

Time estimation: 5 hours

Learning Objectives

• Explain the difference between a table, a record, and a field.
• Explain the difference between a database and a database manager.
• Write a query to select all values for specific fields from a single table.
• Write queries that display results in a particular order.
• Write queries that eliminate duplicate values from data.
• Write queries that select records that satisfy user-specified conditions.
• Explain the order in which the clauses in a query are executed.
• Write queries that calculate new values for each selected record.
• Explain how databases represent missing information.
• Explain the three-valued logic databases use when manipulating missing information.
• Write queries that handle missing information correctly.
• Explore SQL City and discover who committed the murder
• Reinforce your experiences with SQL such as querying, filtering, and joining data.