CS 450 - Database Concepts

Class Meetings: Mondays, 4:30 - 7:10 PM in Krug Hall Room 7.

Instructor: Dr Larry Kerschberg

Office Hours: Mondays and Wednesdays 2:00-4:00 PM, or by email appointment. Skype chats are also welcome by appointment.
Office: 4412 in the Nguyen Engineering Building.
Email: kersch@gmu.edu
Skype: kersch

GTA: Yuyang Gao

Office Hours: Mondays and Tuesdays, 4:30-6:00 PM
Office: TBA
Email: ygao13@gmu.edu

We will use Blackboard System for all postings of reading assignments, slides, homework assignments, class discussions, group projects, and email communication.

The GMU and CS Depatment Honor codes are in effect at all times.

The GMU Honor Code is posted here: http://oai.gmu.edu/the-mason-honor-code-2/

The Computer Science Department's Honor Code is posted here: http://cs.gmu.edu/resources/honor-code/

Prerequisites:

Grade of "C" or better in CS 310 (Data Structures) and CS 330 (Formal Methods and Models).

Course Topics

This course covers basic-to-intermediate knowledge for the design, implementation, and use of relational database systems. The main topics include the relational data model, Entity-Relationship (ER) model for database design, Relational Algebra, SQL, database programming, functional dependencies and normalization, and indexing.

Computer and Device Policy

No laptops, phones, tablets or other electronic devices may be used during the class. They are to be turned off during lectures and exams. You may use your devices during the class break-time. Please print out the lecture slides before coming to class.

ABET Course Outcomes

Course Textbooks

(1) Elmasri and Navathe, Fundamentals of Database Systems, 6th ed., Addison Wesley, 2011, ISBN-13: 978-0-13-608620-8.

(2) Sunderraman, Oracle 10g Programming, A Primer, Addison-Wesley, 2008, ISBN-13: 978-0-321-46304-3.

Grading Policy

Your final grade will be determined by your performance as follows:

Grade Components and Percentages
Assignments
20
Project
20
Midterm Exam
25
Final Exam
35

Homework assignments and projects are to be submitted on time via Blackboard.
The assignments and projects are to be done individually, unless specified otherwise, and the honor code is in effect at all times.