Principles of Database Systems

Course number: 
CIS 4331
Fall 2015
Name E-mail Office location
Eduard Dragut
Science Education and Research Center (SERC), Room 348
  • Course or Test: CIS 3207. Minimum Grade of C-. May not be taken concurrently.
  • Course or Test: CIS 2166. Minimum Grade of C-. May not be taken concurrently.
  • Programming ability in Java, C/C++, or C# are also required.
Database System Concepts (Sixth Edition) by Avi Silberschatz, Henry F. Korth, S. Sudarshan book website.

  • Database Management Systems, (Third Edition), by Raghu Ramakrishnan and Johannes Gehrke. McGraw Hill, 2003 book website.
  • Database Systems: The Complete Book (2nd edition),Hector Garcia-Molina, Jeffrey Ullman and Jennifer Widom, Prentice Hall, ISBN 0-131-87325-3, 2008 book website.
  • Database Systems: A Practical Approach to Design, Implementation, and Management. Thomas Connolly and Carolyn Begg. Addison Wesley, 5th edition, ISBN 0-321-52306-7, 2009.
  • Oracle Database 11g SQL and PL/SQL: A Brief Primer. download/pdf
Topics covered: 
This course also introduces database application development using Java and Oracle database. We will cover the following topics:
- Database Introductions, Basic Concepts
- Database System Concepts and Architecture
- Relational Model
- Relation Algebra
- Database Application Development: JAVA
- Data Modelling Using the Entity-Relationship (ER) Model
- Transform ER Schema to Relational Schema
- Views, Stored Procedures, Triggers
- Database Application Development: JAVA
- Introduction to Indexing
- Introduction to Transaction and Locking
- Introduction to Concurrent Control
- Other topics: Distributed Databases, Column stores vs. Row stores, NoSQL
Course goals: 
Database systems from user/developer perspective: querying using SQL and relational algebra, design database schemas using ER/UML diagrams, normalization, and programming using database APIs. Construction of database-driven applications (e.g., websites, e-ecommerce) and experience with current database technologies.
Attendance policy: 
Attendance to all meetings of the class is mandatory.
Accomodations for Students with Disabilities: 
Any student who has a need for accommodation based on the impact of a documented disability, including special accommodations for access to technology resources and electronic instructional materials required for the course, should contact me privately to discuss the specific situation by the end of the second week of classes or as soon as practical. If you have not done so already, please contact Disability Resources and Services (DRS) at 215-204-1280 in 100 Ritter Annex to learn more about the resources available to you. I will work with DRS to coordinate reasonable accommodations for all students with documented disabilities. (
Student and Faculty Academic Rights and Responsibilities: 
Freedom to teach and freedom to learn are inseparable facets of academic freedom. The University has a policy on Student and Faculty and Academic Rights and Responsibilities (Policy #03.70.02) which can be accessed through the following