INFS 614 – Fall   2011

Database Management  70644  INFS 614 - 002

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.