Quiz 9

Regarding Reading 9.

  1. If a database is in First Normal Form (1NF), what does that mean?
  2. Which is the most widely used Normal Form?
  3. Translate the following SQL statement into English:
    SELECT AS name, cars.color AS car_color FROM enemies, cars WHERE enemies.car_id =;

    "Computer, show me a list of my enemies' __________ and their car ___________."
  4. What's wrong with this statement: SELECT * FROM muppets WHERE age = NULL;
  5. Say you execute a SQL statement and you receive an error like SQL error: may not be NULL what kind of constraint do you think is on the name column?
  6. What about if you receive the error SQL error: columns first_name, last_name are not unique?