Core Web Application Development with PHP and MySQL

Chapter 9. Designing and Creating Your Database

Given the basic understanding of databases and database servers presented in the previous chapter, it is now time to start looking at what we might put in them and how we might structure our information. We will also start looking at how to go about controlling who has permissions to read, modify, or remove the data.

Over the course of this chapter, we will

• Plan what data we will put into our databases

• Think about how to organize the data in the databases, and offer some techniques and strategies for doing so

• Learn about keys and primary keys

• Begin using the ANSI SQL language

• Create database user accounts and give them various permissions

• Learn how to create databases and tables