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