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