Name:

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 enemies.name AS name, cars.color AS car_color FROM enemies, cars WHERE enemies.car_id = cars.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: muppets.name 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?