O'Reilly logo

PHP, MySQL, & JavaScript All-in-One For Dummies by Richard Blum

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

Chapter 3

Designing and Building a Database

IN THIS CHAPTER

check Understanding how to design a database

check Creating a database in MySQL

check Building tables using different tools

In the preceding chapter, you learned your way around the MySQL server interface tools. The next step in the process of building a dynamic web application is to create a database and tables for the data required for your application.

In this chapter, I show you how to determine just what data is required for an application and how to divide it into tables to manage the data. Then I show you how to create databases using the popular MySQL server interface tools. Finally, I explain how to create the tables by using each of the tools, so that you can manage the data in your applications.

Managing Your Data

When you start out a new dynamic web application, your first decision, before you even start any coding, is how to handle the application data. Often you’re faced with a myriad of data elements you need to track, such as employee, customer, and product information for a store. The trick to successfully managing all that information is in how to sort it all out.

The process of structuring application data into tables ...

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