Test Your Knowledge

  1. What does the word relationship mean in reference to a relational database?

  2. What is the term for the process of removing duplicate data and optimizing tables?

  3. What are the three rules of the First Normal Form?

  4. How can you make a table satisfy the Second Normal Form?

  5. What do you put in a column to tie together two tables that contain items having a one-to-many relationship?

  6. How can you create a database with a many-to-many relationship?

  7. What commands initiate and end a MySQL transaction?

  8. What feature does MySQL provide to enable you to examine how a query will work in detail?

  9. What command would you use to back up the database publications to a file called publications.sql?

See Chapter 9 Answers in Appendix A for the answers to these questions.

Get Learning PHP, MySQL, JavaScript, and CSS, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial