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
· 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
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