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

The Database Schema

The Purchase Management application will use the existing WeMakeCars database. The Production department will maintain the tblRequisitions table. The system administrator too will maintain all master tables, such as tblItemMaster, tblSuppliers, and tblItemSupplierCostList. The Purchase Management application will manipulate the remaining tables. Figure 24.5 shows the database schema.

Figure 24.5. Schema for the WeMakeCars database.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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