O'Reilly logo

Learning PHP, MySQL, and JavaScript by Robin Nixon

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Test Your Knowledge: Questions

Question 9-1

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

Question 9-2

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

Question 9-3

What are the three rules of First Normal Form?

Question 9-4

How can you make a table satisfy Second Normal Form?

Question 9-5

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

Question 9-6

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

Question 9-7

What commands initiate and end a MySQL transaction?

Question 9-8

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

Question 9-9

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

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required