Instructor: Prof. Harry Wechsler wechsler@gmu.edu
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)
http://registrar.gmu.edu/calendars/2011Fall.html
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
http://registrar.gmu.edu/calendars/2011FallExam.html
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.
Tentative Schedule:
Lectures 1
- 2: Database Management Systems (DBMS) and Database Architectures ~ September
1 - 8
Textbook
/Slides: Chaps. 1 - 2
Papers: TBD
Homework: TBD
Lecture 3 -
4: Relational Data Model and Basic SQL ~ September 15 - 22
Textbook /
Slides: Chap. 3 - 4
Papers: TBD
Homework: TBD
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
Papers: TBD
Homework: TBD
Lecture 7: More
SQL and REVIEW ~ October 13
Textbook /
Slides: Chap. 5
Papers: TBD
Homework: TBD
Lecture 8: MIDTERM ~ October 20
Lecture 9: Relational
Algebra ~ October 27
Textbook /
Slides: Chap. 6
Papers: TBD
Homework: TBD
Lecture 10:
ER and EER to Relational Mapping ~ November 3
Textbook /
Slides: Chap. 9
Papers: TBD
Homework: TBD
Lecture11: Database
Programming Techniques ~ November 10
Textbook /
Slides: Chap. 13
Papers: TBD
Homework: TBD
Lecture 12:
Normalization ~ November 17
Textbook /
Slides: Chap. 15
Papers: TBD
Homework: TBD
Lecture 13:
Database Security & Data Warehousing ~ December 1
Textbook /
Slides: Chap. 24 and 29
Papers: TBD
Homework: TBD
Lecture 14:
Data Mining and REVIEW ~ December 8
Textbook /
Slides: Chap. 28
Papers: TBD
Homework: TBD
ACADEMIC INTEGRITY
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”
http://library.gmu.edu/mudge/IM/IMRef.html
COUNSELING AND PSYCHOLOGICAL SERVICES
(CAPS): (703) 993-2380;
http://caps.gmu.edu
UNIVERSITY POLICIES
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.