Please find below Page 17

In Chapter 1, page 17, there is an EER diagram for the AP (Accounts Payable) database. (Note that this diagram is also shown in SLIDE 21 in the Chapter 1 PowerPoint slides). Take a look at the diagram and determine what foreign key for the tables in 1 and 2 below relate to a primary key in another table for all tables. As an example, the terms table has a primary key (term sid) that relates it to the foreign key (default_terms_id) in the vendors table. Thus the foreign key default_terms_ id relates the vendors table to the primary key term s_id in the terms table. Based on the above, answer these two questions: 1. How is the general_ledger_accounts table related to the vendors table? 2. How is the terms table related to the invoices table? Once you answer the questions above, define the following terms from Chapter 1: Client Server Database server Foreign key Primary key