Location

Class (lecture): Monday and Wednesday, 12:30 PM - 1:50 PM
Date Range: Aug 26 - Dec 18, 2019
Location: Tuttleman Learning Center | Room 302
Laboratory Location: SERC 357
Laboratory Time: Tuesday, 11:00 AM - 12:50 PM

Instructor

- Name: Eduard C. Dragut
- Email: edragut@temple.edu
- Office: SERC 448
- Office Hours: Wednesday 10:00AM - 12:00 PM or by email appointment

Teaching Assistant

- Name: Dheera Suhalka
- Email: tuj46253@temple.edu
- Office: Thursday 10AM - 12PM
- Office Hours: SERC 304

Course Descriptions

This course provides an introduction to 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-commerce) and experience with current database technologies. We will cover the following topics:
- Database Introductions, Basic Concepts
- Database System Concepts and Architecture
- Relational Model
- Relation Algebra
- SQL
- Database Application Development: JAVA
- Data Modelling Using the Entity-Relationship (ER) Model
- Transform ER Schema to Relational Schema
- PL/SQL
- 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

Prerequisites

  • CIS 3207. Minimum Grade of C-. May not be taken concurrently.
  • CIS 2166. Minimum Grade of C-. May not be taken concurrently.
  • Programming ability in Java, C/C++, or C# are also required.
- If you do not meet any of these prerequisites, please see me asap.

Textbook

- Required: Database System Concepts (Sixth Edition) by Avi Silberschatz, Henry F. Korth, S. Sudarshan book website
Recommended:

  • 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

Workload

- Homework (6 to 10 assignments)
- Project (a semester long project)
- Midterm Exam (Date: TBD)
- Final Exam (Date: TBD). Final exam is cumulative.

Grading

The final grade will be based upon the following:
- Homeworks: 20%.
- Project: 30%.
- Midterm Exam: 20%
- Final Exam: 30%
- Extra-credit points may be given, up to 5%, based on the activity in class and the labs.
- Graduate students are responsible for a substantial research and development project.

Late Submission Policy

Late submission is subject to a 10% penalty for each day late. After three days, late submissions will not be accepted. Students are strongly advised that any act of cheating will result in a score of 0 for the entire assignment and repeat offences will be reported to the Office of the Dean of Students and will result in an automatic F grade. You are encouraged to discuss problems and ideas but the final solution or code must be your own.

Classroom Requirements

  • Cell phones must be turned off or set on vibrate during class.
  • Laptop/notebook computers and tablets cannot be used during class.

Disability Disclosure

Any student who has a need for accommodation based on the impact of a disability should contact me privately to discuss the specific situation as soon as possible. Contact Disability Resources and Services at 215-204-1280 in Room 100, Ritter Annex to coordinate reasonable accommodations for students with documented disabilities.