Overview
1. What is ODBC? How is it related to SQL/CLI? List the three main approaches to database programming. What are the advantages and disadvantages of each approach? A minimum of 1 reference from the online textbook is required, along with APA formatting.
2. What is the difference between primary and secondary storage? Discuss the mechanism used to read data from or write data to the disk. What is the difference between static and dynamic files? A minimum of 1 reference from the online textbook is required, along with APA formatting.
3. Discuss the different types of parameters that are used in database query cost functions. Where is this information used to determine the query path kept?
Discuss the cost components for a function used to estimate query execution cost. Which cost components are used most often as the basis for cost functions for database queries?
---
For question 1, please reference Chapters 10, 11, and 12 from the attached documents/PDFs. For question 2, please reference Chapters 14, 16, 17. For question 3 please reference Chapter 18. Each answer should be in APA 7 format and contain about 200 words. Thank you!