Comparing the Three Approaches
What is ODBC? How is it related to SQL/CLI?
What is JDBC? Is it an example of embedded SQL or of using function calls?List the three main approaches to database programming. What are the advantages and disadvantages of each approach?
What is the impedance mismatch problem? Which of the three programming approaches minimizes this problem?
Describe the concept of a cursor and how it is used in embedded SQL.
10.6. What is SQLJ used for? Describe the two types of iterators available in SQLJ.
Exercises
Consider the database shown in Figure 1.2, whose schema is shown in Figure 2.1. Write a program segment to read a student’s name and print his or her grade point average, assuming that A = 4, B = 3, C = 2, and D = 1 points.
Use embedded SQL with C as the host language.
Repeat Exercise 10.7, but use SQLJ with Java as the host language.
Consider the library relational database schema in Figure 6.6. Write a program segment that retrieves the list of books that became overdue yesterday
and that prints the book title and borrower name for each. Use embedded
SQL with C as the host language.
Repeat Exercise 10.9, but use SQLJ with Java as the host language
Logical and Critical Reasoning
Some sample ideas to consider incorporating in your theme. Please use these as inspiration – remember, the aim is to explore a topic of your choosing – these are suggestions to help you choose a topic, but remember not to answer these questions. Come up with your own original theme/topic/thesis:
What is the nature of thinking?
What are the historical influences on logical reasoning today?
How does understanding logic and reasoning help in thinking more clearly?
How does forming a worldview happen, and how do worldview and framing language influence thinking?
What are some common mistakes in reasoning and why do we make them?
What are the differences between deductive and inductive reasoning and how we use them?
What makes an argument valid, invalid, sound, or strong?
What are scientific reasoning and the scientific method and what is the role of experiment and observation?
What is reasonable doubt and how can we use it to reason better and think more logically?
