Transcript Slide 1 - Computer Science Department

Introduction to Databases
Computer Science 557
September 2007
Instructor: Joe Bockhorst
University of Wisconsin - Milwaukee
• Class is currently full (30 students)
– See me if you wish to enroll
• Class email:
– Enrolled students should receive an email from me
later today
• Course web site:
– http://www.uwm.edu/~joebock/557
– Assignments, some lecture notes
Required Textbook
($95 on Amazon.com)
Office Hours
• My office is 1159 on the 11th floor of EMS
• Office Hours
– Informally, a few minutes after class. (we can go to
the new EMS coffee shop if this classroom is needed)
– Formally, 10-11 Mondays, 1:30-2:30 Thursdays
– By appointment (if you’d like to meet some other time,
please send me an email to arrange a meeting. Do
not assume I will be in my office)
Course Rules
1) Do not cause a distraction
2) Do not cheat (see academic misconduct policy)
Grading
• 50% - Homework and Programs
– Approximately 1 assignment every two weeks,
• 20% programs (3-4)
• 20% written homework assignments (3-4)
• 10% 1 mini-project
• 20% - Midterm (in class on Oct 16)
• 30% - Final (10AM – 12PM, Tuesday Dec 18)
– Comprehensive, but more questions will be on topics
discussed following the midterm
Assignments
• Written homework assignments
– “Sampling” may be used for grading
• Programming assignments include both C++ or
Java and SQL (a database query language)
– I assume you know either Java or C++ (not SQL)
– Grading will be mostly electronic
Student Computer Labs
• E256, E280, E285, E384, E270
Late Policy
• Assignments due 11:59 PM (usually on Fridays)
– 2 day grace period with no penalty
– 20% penalty for each 24 period late (start counting
from due date)
• I pledge that
– Assignments will be available on or before the
Tuesday in the week preceding the Friday deadline
• Thus you will have at least 11 days for each
assignment
• You pledge that
– You will not ask for an extension
Powerpoint Vs Whiteboard
• Powerpoint encourages words over pictures (not
good)
• But powerpoint can be saved, tweaked, easily
shared, …
• I plan to use a mix of whiteboard and powerpoint
– Powerpoint notes will be available, but not everything
we do will be in powerpoint... Thus I recommend
taking some notes
– we’ll keep the lights up
• Your thoughts?
Background Assumed
• You will be required to write computer programs
in order to successfully complete this course
• Some programs will be in Java or C++
• CS 201 required / CS 351 recommended
• If you are not familiar with UNIX shell...
Tentative Schedule
•
•
•
•
•
•
•
•
•
•
Sept 21 (Program 1: Heap Files)
Oct 5 (Program 2: Indexes)
Oct 12 (Homework 1: Relational Algebra)
Oct 16 (MIDTERM EXAM)
Nov 2 (Program 3: SQL)
Nov 9 (Homework 2: Database Design / ER)
Nov 16 (Program 4: Applications)
Dec 7 (Homework 3: Rel. op implementation)
Last Week (mini-project demos)
Dec 18 (FINAL EXAM)