• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

The Database Schema

The Online Appraisal application uses the existing ElectricComp database to store the information regarding policies and appraisals. Some tables are already present in this database, such as tblLogins and tblEmployees, and these are used for validation purposes. These tables are maintained by other applications, like the payroll system and time office system. Figure 18.7 shows the database schema for the ElectricComp database.

Figure 18.7. The schema for the ElectricComp database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint