O'Reilly logo

Microsoft®C# Programming for the absolute beginner by Andy Harris

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

Working with Relational Databases

The simple spy database does the job, but it is incomplete. Any self-respecting spymaster would keep the following information on each agent:

  • CodeName

  • Specialty (each spy could have several specialties)

  • Assignment

  • Assignment description

  • Location

It might be tempting to build a slightly bigger table to hold this information. Figure 11.27 illustrates such a table.

Figure 11.27. This version of the spy database has more information, but it also introduces a number of problems.

When you carefully analyze this version of the spy database, you’ll notice a couple of problems that crop up frequently in real databases. First, ...

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