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

Model the Time Entry and Billing Database

Now that you have a good understanding of what database modeling is, you can employ the techniques to your current project—the Time Entry and Billing Database. Through the course of interviews and the analysis of business documents and forms, you have identified the following entities:

  • Clients

  • Employees

  • Cases

  • Invoices

  • TimeEntryDetail

In the course of your analysis, you have identified the following relationships:

  • Clients can have one or more cases.

  • Clients can have one or more invoices.

  • Invoices are made up of one or more TimeEntryDetail records.

  • Time is charged to a case.

  • Employees charge time to a case.

Figure 3.16 shows the database model at this point in the development process. As you will soon see, ...

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