Figure 1 shows a simple example of what this new table might look like. Now you can add as many phone numbers as you'll ever want, and your database won't have to be changed again to allow this to happen. Each committee number occurs several times in this table, once for each person who belongs on the corresponding committee, and any of the member numbers can also appear more than once, if the person who matches that number is on more than one committee. As you can see, the flexibility that we achieve through good database design is virtually unlimited. And once you understand the concepts, you can apply them to many different situations.
Every class includes many students, and each student takes several classes.
Jo K. Horan is a database developer, consultant, and trainer, specializing in Alpha Four and Alpha Five.