CIS 214 PHP and MySQL

__Chapter 8 Homework Date
due: ____04/16/2012__

Your name: _______________________________________________

__ __

1. |
A description of the data (the tables and columns) in your database, along with any other related objects and the way they all connect is known as a_________. |
Answer: |

2. |
Creating a __________ of a table lets you keep the design of the table separate from the data thatâ€™s inside of it. |
Answer: |

3. |
A __________ key is a column in a table that references the primary key of another table. |
Answer: |

4. |
Large arrows show primary keys connecting to foreign keys to wire together __________. |
Answer: |

5. |
One-to-One: exactly one row of a parent table is related to one row of a __________ table. |
Answer: |

6. |
One-to-Many: exactly one row of a parent table is related to __________ rows of a child table. |
Answer: |

7. |
Many-to-Many: Multiple __________ of a parent table are related to multiple rows of a child table. |
Answer: |

8. |
Data-driven forms rely on __________ in a MySQL database to generate HTML form fields. |
Answer: |

9. |
The __________ operator can be used to code if-else statements in a more compact form. |
Answer: |

10. |
Normalization means designing a __________ to reduce duplicate data and improve the relationships between data. |
Answer: |

11. |
Atomic data is data that has been broken down into the smallest __________ needed for a given database. |
Answer: |

12. |
Making your data atomic is the __________ step in creating a normal table. |
Answer: |

13. |
Normalization has its benefits, namely improvements in database __________ and speed. |
Answer: |

14. |
Normalizing a database involves strictly __________ to a series of design steps. |
Answer: |

15. |
More tables usually lead to messier__________ . |
Answer: |

16. |
A __________ grabs results from multiple tables in a single query. |
Answer: |

17. |
Dot notation allows you to __________ the table a column belongs to within a join. |
Answer: |

18. |
An INNER __________ combines rows from two tables using comparison operators in a condition. |
Answer: |

19. |
Rewrite ON with __________ for more concise inner join queries that match on a common column. |
Answer: |

20. |
The column names must be the same in order to use the __________ statement in an inner join. |
Answer: |

21. |
An __________ allows you to rename a table or column within a query to help simplify the query in some way. |
Answer: |

22. |
When a column is __________ with an alias, the alias is what appears in the query results. |
Answer: |

23. |
Joins are more efficient and require less code than __________ queries. |
Answer: |

__ __

__ __

*For instructor use:*

**Total Correct: _______________________**

**Percent: _______________________**

**Grade: _______________________**