120 likes | 129 Views
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:
E N D
Introduction to DatabasesComputer Science 557September 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
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 • Do not cause a distraction • 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)