O'Reilly logo

Absolute Beginner’s Guide to Databases by John V. Petersen

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

Normalization Applied—Review the TEB Database and Refine the Design

With a good understanding of normalization, it is time to apply the concepts to the current project, the Time Entry and Billing Database. To review, the following tables have already been identified:

  • Case

  • Client

  • ClientCase

  • Employee

  • EmployeeCase

  • Invoice

  • TimeEntryDetail

Figure 4.5 shows the relationships between the entities.

Figure 4.5. Version 4 of the Time Entry and Billing Database model represents the completed first draft of the database model.

Identifying New Columns and Tables

As you might guess, the need will arise for new tables. Before getting to that step, the existing ...

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