JavaScript Editor Javascript validator     Website design 

Team LiB
Previous Section Next Section

Introducing the Spy Database

In this chapter you will build a database to manage your international spy ring. (You do have an international spy ring, don't you?) Saving the world is a complicated task, so you'll need a database to keep track of all your agents. Secret agents are assigned to various operations around the globe, and certain agents have certain skills. The examples in this chapter will take you through the construction of such a database. You'll see how to construct the database in MySQL. In the final chapter, you'll use this database to make a really powerful spymaster application in PHP.

The spy database reflects a few facts about my spy organization (called the Pantheon of Humanitarian Performance, or PHP):

This list of rules helps to explain some characteristics of the data. In database parlance, they are called business rules. I'll need to design the database so that these rules are enforced.

Start example

I set up this particular set of rules in a somewhat arbitrary way because they help make my database as simple as possible while still illustrating most of the main problems you'll encounter in data design. Usually you don't get to make up business rules. Instead, you'll need to learn them by talking to those who use the data every day.

End example

Team LiB
Previous Section Next Section

JavaScript Editor Javascript validator     Website design сдача в аренду помещений в люберцах.