CS 450-001: Database
Management
Spring 2014
Professor Alex Brodsky
Office: Nguen
Engineering Bldg 4418, Phone:(703) 993-1529, Fax:(703)993-1710
Email: brodsky@gmu.edu
Prerequisites: Prerequisites
Grade
of C or better in CS 310 and CS 330.
Each student enrolled in this class
certifies
that he/she has the prerequisites listed above
Required
textbook (1 of the following):
1. Database
Systems, 2nd ed. by Kifer, Bernstein and Lewis, Addison
Wesley
Or:
2. Database
Management Systems, 3-rd ed. by Raghu Ramakrishnan & Johannes
Gehrkem, McGraw-Hill
Or:
3. Fundamentals
of Database Systems, by Elmasri and Navathe,4th ed., Addison Wesley, 2004
Recommended:
Oracle 10g reference material, e.g., http://www.oracle.com/technology/products/database/oracle10g/index.html
On-Line Course Resources:
GMU Blackboard (courses.gmu.edu) CS
450-001 (please check frequently, at least once weekly before class for
announcements)
Lectures:
Art and
Design Building L008
Wednesday
1:30 – 2:45 PM (see schedule below)
Professor's
Office Hours: Thursday 4:00 – 5:30 PM (no need to
schedule, but please call to verify before coming)
Teaching
Assistant: Shalini
Bavanaka
Office hours: Tuesday 5:00 – 7:00 PM
Requirements:
The students are expected to attend all lectures and finish homework
assignments on time. The assignment and due dates as noted above are
approximate ones. The precise dates will be given on the Blackboard
announcements. The students are also expected to attend the two in-class
examinations.
Project:
Important dates are listed. See project assignment for details.
Computings
Resources:
General.
Oracle database management system is installed in an IT&E Unix server,
which is accessible online.
VPN and Oracle Account Setup and Access.
Go to the website, http://labs.ite.gmu.edu/index.php/Services/Services, to
follow the procedures to setup your VPN and Oracle account. First, you need to
install the VPN and make it work so that you can also access the DB at home or
your workplace. Then follow the procedure to get the Oracle account and access
it.
Working with Oracle. Oracle 10g
reference material, e.g., http://www.oracle.com/technology/products/database/oracle10g/index.html
Grading policy:The final grades assigned to the students
are based on their performance on homework assignments (16%), midterm exam (33%),
final exam (44%) and a semester-long project (7%). The score of 90% or higher
guarantees an A grade, of 75% or higher - a B grade, of 60% or higher - a C grade.
Late homework and project submission is NOT allowed. A submission is considered
on time if submitted before electronically on Blackboard on or before required
submission date/time.
Tentative Class Schedule
|
Date |
Topic |
Reading
(Ramakrishnan) |
HW
Assigned |
HW
Due |
Project
Due |
|
Thu,
1/23 |
Intro |
Chapter
1 |
|
|
|
|
Tue,
1/28 |
ER
Model |
Chapter
2 |
HA
1 |
|
|
|
Thu,
1/30 |
Cont. |
|
|
|
|
|
Tue,
2/4 |
ER
& Relational Model |
|
|
|
|
|
Thu,
2/6 |
Cont. |
|
|
|
|
|
Tue,
2/11 |
Relational
Algebra |
Chapter
4 |
HA
2 |
HA
1 |
|
|
Thu,
2/13 |
Cont. |
|
|
|
|
|
Tue,
2/18 |
Relational
Calculus |
Chapter
4 |
|
|
|
|
Thu,
2/20 |
Cont. |
|
|
|
|
|
Tue,
2/25 |
SQL-I |
Chapter
5.1 – 5.7 |
HA3 |
HA2 |
|
|
Thu,
2/27 |
Cont. |
|
|
|
|
|
Tue,
3/4 |
Catch-up
and review |
|
|
|
|
|
Thu,
3/6 |
Midterm
Exam |
|
|
|
Project
Assigned |
|
Tue,
3/11 |
No
class – Spring break |
|
|
|
|
|
Thu,
3/13 |
No
class – Spring break |
|
|
|
|
|
Tue,
3/18 |
SQL-II |
Chapter
5.1 – 5.7 |
|
|
|
|
Thu,
3/20 |
Cont. |
|
|
|
|
|
Tue,
3/25 |
Cont. |
|
|
|
|
|
Thu,
3/27 |
Cont. |
|
|
|
|
|
Tue,
4/1 |
Cont. |
|
|
|
|
|
Thu,
4/3 |
Cont. |
|
|
|
|
|
Tue,
4/8 |
Schema
Refinement and Normalization |
Chapter
15 |
HA
4 |
|
Preliminary
Project Submission |
|
Thu,
4/10 |
Cont. |
|
|
|
|
|
Tue,
4/15 |
Cont. |
|
|
|
|
|
Thu,
4/17 |
Cont. |
|
|
|
|
|
Tue,
4/22 |
Cont. |
|
|
|
|
|
Thu,
4/24 |
Cont. |
|
|
|
|
|
Tue,
4/29 |
No
Class – work on projects |
|
|
HA
4 |
|
|
Thu,
5/1 |
No
Class – work on projects |
|
|
|
|
|
Tue,
5/6 |
Optional
Catch-up and Review |
|
|
|
Final
Project Submission |
|
Thu,
5/8 |
Advanced
Topics |
TBD |
|
|
|
|
Tue,
5/13 |
Final
Exam |
|
|
|
|