Please find below Page 17 In Chapter 1, page 17, there is an EER diagram for the
ID: 3743632 • Letter: P
Question
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 keyExplanation / Answer
1) general_ledger_accounts has a primary key called account_number that relates to the default_account_number(foreign key) in accounts
2) terms has a primary key called terms_id that relates to the terms_id(foreign key) in invoices
Client:Client is an entity which asks for resources or services from another entity called server
Server:Server is an entity which provides resources or services in response to client's requests
Database Server: Database server consists of database applications and provides services to clients requests
Primary key: It is an unique identifier in a database whicg helps to identify records in an unique manner and they can't be repeated.
Foreign key:A foreign key is an entuty in one table which acts as primary key in another table