Courses/Computer Science/CPSC 203/CPSC 203 2007Fall L04/CPSC 203 2007Fall L04 Lectures/Lecture 13

'Lecture 13'
Rather than a formal lecture today, we will focus on a Q & A session to help prepare you for the mid-term exam on Thursday.

The objectives of today's class are:


 * House Keeping
 * Reminders:
 * Midterm is next Thursday (you have the whole class).
 * Assignment 1 Due Monday Oct. 29th at Mid-night. Submit by BlackBoard.


 * Topics
 * Example of a Relational Database Design (continued from last class).
 * Assignment 2 Introduction.
 * Midterm Test Q & A -- practice test review; general questions.

Iterative Database Design Exercise (from last class)
We will use the Survey Data Set.
 * We will work in "Teams" for 20 minutes -- then present our results to the group.
 * Each Team is a long table.
 * There are 2 Sub-Teams:
 * White Sub-Team are the Designers
 * Black Sub-Team are the 'Bug Finders' -- Critique design in terms of the Design Goals  above.
 * Rapidly work your way through at least 2 iterations.
 * Iteration 1: White Team initial design. Black Team Critique.
 * Iteration 2: White Team re-design. Black Team Re-Critique.
 * Last Part of Class we will have a couple of Teams present their Design.
 * Tuesday I will present a 'Normalized' Design.

MIDTERM TEST FORMAT AND POLICY

 * 1) Midterm is in regular lecture class -- October 25th, 2p.m.
 * 2) You have the full 75 minutes.
 * 3) Format is Multiple Choice (20 questions). (so how many minutes/question???)
 * 4) Your answers are on "Bubble Sheets" -- make sure to fill out your info completely.
 * 5) Post-Test we will review answers.
 * 6) Exams will not be handed back (as per finals) -- but you may make an appt. to view your exam.

Internet

 * TIA 4th Edn: Chapter 13, pp 572-578


 * TIA 3rd Edn: Chapter 13, pp 546-552

Databases
TIA 3rd Edn: Chapter 11. 462 -- 503

TIA 4th Edn: Chapter 11. pp 484 -- 525

Resources
Your Notes

The Wiki (and materials there)

Materials on BlackBoard Course Documents Section