Class Meetings: Mondays, 4:30 - 7:10 PM in Krug Hall Room 7.
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
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/
Grade of "C" or better in CS 310 (Data Structures) and CS 330 (Formal Methods and Models).
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.
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.