INFS 614-002/DL1: Database Management Fall 2012
Professor Alex Brodsky
Office: Nguen
Engineering Bldg 4418, Phone:(703) 993-1529 Fax:(703)993-1710
Email: brodsky@gmu.edu
Prerequisites: INFS 501, 515, 519, SWE 510 or equivalent
Required textbook:
Database Management Systems, 3-rd ed. by Raghu Ramakrishnan & Johannes Gehrkem, McGraw-Hill.
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)
INFS-614-002 (please check frequently, at least once weekly before class for announcements)
Lectures: Nguen
Engineering Building, room 2608 (electronic class room), Monday 4:30 – 7:20 PM (see
schedule below)
Professor's Office Hours: Wednesday 4:00 – 5:30 PM (no need to schedule, but
call to verify before coming)
Teaching Assistant:
Sharmila Ramamoorthy and Venkat Yerneni
Office hours: TBD
Requirements: The students are expected to attend all lectures and finish homework assignments on time. Late submissions are not allowed. The assignment and due dates as noted above are approximate ones. 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 (15%), midterm exam (34%), 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. Faxed-in submission
is accepted but the student should inform the instructor appropriately
Tentative Class Schedule
Week |
Date |
Topic |
Reading |
HW Assigned |
HW Due |
Project Due |
1 |
Aug 27 |
Intro |
Chapter 1 |
HA 1 |
|
|
2 |
Sep 3 |
Labor Day - no class |
|
|
|
|
3 |
Sep 10 |
ER & Relational Model |
Chapter 3 |
|
|
|
4 |
Sep 17 |
Relational Algebra |
Chapter 4 |
HA 2 |
HA 1 |
|
5 |
Sep 24 |
Relational Algebra & Calculus |
Chapter 4 |
|
|
|
6 |
Oct 1 |
SQL-I |
Chapter 5.1 – 5.7 |
HA3 |
HA2 |
|
7 |
Oct 8 |
Colombus Day – no class |
|
|
|
|
8 |
Oct 9 Tuesday |
SQL-II |
Chapter 5.1 – 5.7 |
|
|
|
9 |
Oct 15 |
Catch-up and review for midterm exam |
|
|
HA3 |
|
10 |
Oct 22 |
Midterm Exam |
|
|
|
|
11 |
Oct 29 |
SQL-III |
Chapter 5.1 – 5.7 |
HA4 |
|
|
12 |
Nov 5 |
Schema Refinement and Normalization |
Chapter 15 |
|
|
|
13 |
Nov 12 |
Cont. |
Chapter 51 |
HA5 |
HA4 |
|
14 |
Nov 19 |
Cont. |
|
|
|
|
15 |
Nov 26 |
Advanced topics |
TBD |
|
HA5 |
|
16 |
Dec 3 |
Catch-up and review for final exam |
TBD |
|
|
Project Due |
17 |
Dec 10 |
Reading Day – no class |
|
|
|
|
18 |
Dec 17 |
Final exam |
|
|
|
|