The final exam will be similar in structure to our midterm exams. Specifically, the largest section of the exam will be short answer covering the material we studied in Chapters 9 and 11 plus additional material (e.g. XML and JSON). In particular, architecture of 2-tier and n-tier systems. You are responsible for Java/JDBC and php in a LAMP/WAMP setting (you do not have to write code, but explain code that is provided). No coding details in other languages. There will be a question related to security threats related to SQL/databases.

Ch. 9 (20 pts.)

Ch.11, XML plus JSON (based on Stanford videos) (30 pts.)

Another section will be on the project presentations You will be given a choice of questions in this section--you won't have to answer them all. The best preparation for this is to have attended the presentations and reviewed the Moodle forum for this content. There will also be questions related to Alex Hubers talk and Q&A (5 pts. each)

The final small section will be comprehensive. This will include 3 or 4 questions that synthesize our work or feature critical issues or skills--like  E-R diagrams, normalization, producing schema from E-R diagrams,  and especially basic SQL, including joins and subqueries. (20 pts.) 

Last modified: Friday, September 23, 2016, 1:26 PM