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 ...

Get Absolute Beginner’s Guide to Databases now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial