Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

9. Terminology. Please match each item on the left with the most appropriate ite

ID: 2412653 • Letter: 9

Question

9. Terminology. Please match each item on the left with the most appropriate item on the right. 1. Data flow 2. Data store 3. External entity 4. Field 5. Foreign key 6. Level Zero 7. Primary key 8. Process 9. Query 10. Record a. A compilation of fields in a database b. A primary key posted to another table c. Accounts receivable file d. Customer last name e. First detailed look at an information system f. First National Bank g. Paid invoices h. Prepare financial statements i. Uniquely identifies records in a database j. Which customers have balances over $500?

Explanation / Answer

1 Data Flow = g. Paid Invoices 2 Data Store = c. Accounts Receivable Files 3 External entity = f. First National Bank 4 Field = d. Customer last name 5 Foreign Key = b. A primary key posted to another table 6 Level Zero = e. First detailed look at an information system 7 Primary Key = i. Uniquely identifies records in a database 8 Process = h. Prepare financial statements 9 Query = j. Which customers have balances over $500? 10 Record = a. A compilation of fields in a database