Fall 2010

Database ManagementCRN: 70791 – INFS 614 – 002

Instructor:  Prof. Harry Wechsler wechsler@gmu.edu

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

Prerequisite:  INFS 501, 519, 515, and SWE 510 or equivalent.

Day, Time, and Venue: R Thursday, 7:20 pm – 10:00 pm,

Innovation Hall 208

http://registrar.gmu.edu/calendars/2010Fall.html

[First day of classes, Thursday, September 2]

[No class on Thursday, November 25, Thanksgiving]

[Last day of classes, Thursday, December 9]

http://registrar.gmu.edu/calendars/2010FallExam.html

[Final Exam: Thursday, December 16, 7:30 – 10:15 pm]

Office Hours: Thursday, 6:00 pm – 7:00 pm (ENGR - 4448)

Textbook (required):  Elmasri and Navathe,   Fundamentals of Database Systems, 6th Edition, Pearson / Addison Wesley, 2007

Textbook (required):  Sunderraman, Oracle10g Programming, Pearson / Addison Wesley, 2008

 

Syllabus:

 

·        Primer on Abstraction, Modeling, Set Theory, and Database Requirements, Design, and Management

 

·        Database Design Using Entity-Relationship (ER) and Enhanced-Entity-Relationship (EER)

 

·        Relational Algebra and Calculus, and Query Languages

 

·        Structured Query Language (SQL) and Database Programming Principles Using ORACLE

 

·        Database Normalization

 

·        Object-Oriented and Logic-Based Databases

 

·        Security, Privacy, and Ethics.

 

·        Data Warehousing, Data Mining, and Active Databases

 

Grading:

·        Homework Assignments 40 %

·        Mid Term Thursday, October 14 20 %

·        Final  –  40%

GRADE and SCALE:

A          93 – 100

A-         90 – 92

B+        87 – 89

B          83 – 86

B-         80 – 82

C+        77 – 79

C          73 – 76

C-         70 – 72

D+        67 – 69

D          64 – 66

F          below 64

Honor Code:

 

You are expected to abide by the GMU honor code. Homework assignments and exams are individual efforts. Information on the university honor code can be found at http://academicintegrity.gmu.edu/honorcode/.

Additional departmental CS information: http://cs.gmu.edu/wiki/pmwiki.php/HonorCode/CSHonorCodePolicies

 

Logistics:

 

Electronic class communication using ONLY GMU email using as subject INFS 614 Fall  2010