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

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