Syllabus

INFS 614-002 (14630): Graduate Introduction to Database Management

George Mason University

Spring, 2014

 

Course Description:  Introduces database systems, emphasizing the study of database models and languages and practice of database design and programming.  Topics include:  Entity-Relationship model, relational model and its formal query languages, SQL, theory of relational database design, and object-oriented and logic-based databases.

 

Instructor:  Dr. Ken Smith.  Email: ksmits[AT]gmu[DOT]edu.  Office phone -- (703) 983-6115 (at the MITRE Corporation in McLean, VA), and fax number -- 983-3308 (attn Prof. Smith).   Office email:  kps[AT]mitre[DOT]org.

 

Textbooks.

Required: Database Management Systems 3rd ed., Raghu Ramakrishnan and Johannes Gehrke, McGraw-Hill.

Optional: Oracle 10g Programming: A Primer by Sunderraman, Addison-Wesley, 2008.

 

Prerequisites: INFS 501 (Discrete mathematics), 515 (Computer architectures/organization), 519 (Program design / Data structures), and SWE  510 (Object-oriented programming in Java) or equivalent.  You must either have a grade of B or better in each of these courses, or produce evidence (e.g., transcript, acceptance letter) that one or more of these courses have been waived due to prior work.  You must satisfy the course prerequisites to register for and stay in this course.  If you have specific questions, please meet with your academic advisor.

 

Course website: http://cs.gmu.edu/~ksmits/INFS614  The course will be administered via this website. Homework and announcements will appear here. Read it at least once a week.

 

Other useful websites: Volgenau School of Engineering (Computing Resources)  (click on student FAQs) for VSE computing labs, accounts, and Oracle DBMS information.

 

Lectures: Thursdays from 7:20 till 10:00 pm in Innovation Hall 134.  Office hours before or after class, or by appointment.

 

Graduate Teaching Assistant:  TBA

 

Grading Policy: Approximate weights towards the final grades: Homework -- 12% (Assignment 1a, 1b, 2, 3, 4, 5: 2% each), Project --10%, Midterm Exam -- 35%, Final Exam (comprehensive) -- 43%.  Late submissions are NOT accepted unless agreed by the instructor before the due time. (A submission is considered late if it is not handed in before lecture begins on the due date.)   All Oracle homework assignments must run properly on the GMU Oracle instance running in the labs.

 

Working together vs. individually:  For this class homework & exams require individual work. Study groups are encouraged, however homework solutions and write ups MUST be the result of individual effort.  Similarly, study groups for examinations are encouraged.  However, both exams are individual effort and closed book.   More details at the GMU Honor Code.

 

Tentative Schedule:

Week

Date

Topic

Text

HW assigned

HW due

1

1/23

Introduction

1

 

 

2

1/30

The ER Model

2

1a

 

3

2/6

The Relational Model

3

1b

1a

4

2/13

Relational Algebra

4.1-4.2

2

1b

5

2/20

Relational Calculus

4.3

3

2

6

2/27

Midterm Review

 

 

3

7

3/6

Midterm Examination

 

 

 

8

3/13

Spring Break - No Class

 

 

 

9

3/20

SQL:  Basics

5.1-5.3

P.1

 

10

3/27

SQL:  Nested Queries

5.4

4

P.1

11

4/3

SQL:  Aggregate Queries

5.5

P.2

 

12

4/10

Functional Dependencies

19.1-19.3

 5

4

13

4/17

Normalization

19.4-19.6

 

  

14

4/24

Guest Lectures

 

 

 P.2

15

5/1

Review

 

 

 5

16

TBA

Final Examination