Instructor: Prof. Harry Wechsler email@example.com
Course Description – Prerequisites: INFS 501, 515, 519, and SWE 510; or equivalent. Introduction to database systems, emphasize 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. Computing lab is required. No substitutions can be made for this class.
Objectives – Theory and Practice at the interface between Databases, Management Information Systems, Knowledge Representation, and Security & Privacy to develop reliable and robust applications geared for real-world information intensive applications including but not limited to administration, health and business enterprises, and homeland security. Course aligned with the objectives of the Master in Information Systems (see http://cs.gmu.edu/programs/masters/infs/ )
Prerequisite: INFS 501, 515, 519, and SWE 510. NOTE: Continuing enrollment and grading require proof that student has completed the prerequisites.
Time, Day, and Venue: R – Thursday, 7:20 pm – 10:00 pm, Robinson Hall A111.
Office Hours: Thursday, 6:15 – 7:15 pm (ENGR - 4448)
First day of classes: Thursday, September 1
Midterm (“closed books and notes”): Thursday, October 20
Thanksgiving recess -- November 23 – 27: No Class on November 24
Last day of classes: Thursday, December 8
Final Exam: Thursday, December 15, 7:30 – 10:15 pm
Grade Composition: 100%
- homework: 30%
- mid-term: 30%
- FINAL: 40%
Textbook: (1) Elmasri and Navathe, Fundamentals of Database Systems, 6th ed., Addison Wesley, 2011; and (2) Sunderraman, Oracle 10g Programming, A Primer, Addison-Wesley, 2008.
Lectures 1 - 2: Database Management Systems (DBMS) and Database Architectures ~ September 1 - 8
Textbook /Slides: Chaps. 1 - 2
Lecture 3 - 4: Relational Data Model and Basic SQL ~ September 15 - 22
Textbook / Slides: Chap. 3 - 4
Lecture 5 - 6: Data Modeling Using the Entity-Relationship (ER)
and Enhanced-Entity Relationship (EER) Models ~ September 29 – October 6
Textbook / Slides: Chap. 7 - 8
Lecture 7: More SQL and REVIEW ~ October 13
Textbook / Slides: Chap. 5
Lecture 8: MIDTERM ~ October 20
Lecture 9: Relational Algebra ~ October 27
Textbook / Slides: Chap. 6
Lecture 10: ER and EER to Relational Mapping ~ November 3
Textbook / Slides: Chap. 9
Lecture11: Database Programming Techniques ~ November 10
Textbook / Slides: Chap. 13
Lecture 12: Normalization ~ November 17
Textbook / Slides: Chap. 15
Lecture 13: Database Security & Data Warehousing ~ December 1
Textbook / Slides: Chap. 24 and 29
Lecture 14: Data Mining and REVIEW ~ December 8
Textbook / Slides: Chap. 28
GMU is an Honor Code university; please see the University Catalog for a full
description of the code and the honor committee process. The principle of academic
integrity is taken very seriously and violations are treated gravely. What does academic integrity mean in this course? Essentially this: when you are responsible for a task, you will perform that task. When you rely on someone else’s work in an aspect of the performance of that task, you will give full credit in the proper, accepted form. Another aspect of academic integrity is the free play of ideas. Vigorous discussion and debate are encouraged in this course, with the firm expectation that all aspects of the class will be conducted with civility and respect for differing ideas, perspectives, and traditions. When in doubt (of any kind) please ask for guidance and clarification.
GMU EMAIL ACCOUNTS
Students must use their Mason email accounts—either the existing “MEMO” system or a new “MASONLIVE” account to receive important University information, including messages related to this class. See http://masonlive.gmu.edu for more information.
OFFICE OF DISABILITY SERVICES
If you are a student with a disability and you need academic accommodations, please see me and contact the Office of Disability Services (ODS) at 993-2474. All academic accommodations must be arranged through the ODS. http://ods.gmu.edu
OTHER USEFUL CAMPUS RESOURCES:
WRITING CENTER: A114 Robinson Hall; (703) 993-1200; http://writingcenter.gmu.edu
UNIVERSITY LIBRARIES “Ask a Librarian”
COUNSELING AND PSYCHOLOGICAL SERVICES (CAPS): (703) 993-2380;
The University Catalog, http://catalog.gmu.edu, is the central resource for university
policies affecting student, faculty, and staff conduct in university academic affairs. Other
policies are available at http://universitypolicy.gmu.edu/. All members of the university
community are responsible for knowing and following established policies.