Class Meetings: Thursday, 4:30 pm - 7:10 pm in Robinson Hall, Room A111.
Office Hours: Thursdays 1:00-3:30 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
Office Hours: TBD,
Office: 5321 in the Nguyen Engineering Building
Email: vyerneni@masonlive.gmu.edu
Skype: yernenivenkat
We will use Blackboard System for all postings of reading assignments, slides, homework assignments, class discussions, group projects, and email communication.
The GMU Honor Code is in effect at all times.
An expanded statement of the GMU Honor Code is posted here: http://www.gmu.edu/academics/catalog/9798/honorcod.html
The Computer Science Department's Honor Code is posted here: http://cs.gmu.edu/wiki/pmwiki.php/HonorCode/CSHonorCodePolicies.
Grade of "C" or better in CS 310 (Data Structures) and CS 330 (Formal Methods and Models).
This course covers basics 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.
Knowledge of fundamental concepts of file and database management.
Knowledge of database design principles, and ability to model real-world environments using the ER model.
Knowledge of the formal principles of the relational database model and its query languages, and ability to design relational databases and express queries in the relational algebra and calculus.
Knowledge of the Structured Query Language (SQL) and database programming principles, and ability to author SQL queries and implement Java database applications using the Oracle database system.
Knowledge of the basic principles of the mathematical theory of database design, and ability to design databases that adhere to Boyce-Codd Normal Form.
Experience in the complete database creative process: from database design, to database constuction, to database programming.
(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.
Your final grade will be determined by your performance as follows:
| 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.
Quizzes may be given at the beginning of class. You may earn up to 3% extra credit for these quizzes.