Class (lecture): Tuesday and Thursday, 12:30 PM - 1:50 PM
Date Range: Jan 12, 2015 - May 06, 2015
Location: Tuttleman Learning Center 0305A
Laboratory Location: SERC 00357
Laboratory Time: Thursday, 9:00 am - 10:50 am
- Name: Eduard C. Dragut
- Email: edragut@temple.edu
- Office: SERC 448
- Office Hours: Tuesday/Thursday 2:00PM - 3:00 PM or by email appointment
- Name: Motaz Al-Hami
- Email: motaz@temple.edu
- Office: SERC 388
- Office Hours: 2 - 4PM
This course provides an introduction to Database System Concepts and Architecture, Relational Data Model and Relational Database Constraints, Data Modeling Using the Entity-Relationship (ER) Model, Database Design Stages, Normalization, Transactions, Indexing, SQL, PL/SQL, Stored Procedures, Views, Triggers, and a variety of Oracle tools. This course also introduces database application development using Java and Oracle database. We will cover the following topics:
- Database Introductions, Basic Concepts, Oracle
- Database System Concepts and Architecture
- Relational Model and 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
- Indexing
- Transaction and Locking
- Concurrent Control
- Other topics: Distributed Databases, Column stores vs. Row stores, NoSQL
- CIS 1068 Program Design. - Programming ability in Java, C/C++, or C# are also required. - If you do not meet any of these prerequisites, please see me asap.
- Required: Database System Concepts (Sixth Edition) by Avi Silberschatz, Henry F. Korth, S. Sudarshan book website
- Recommended: Murach's Oracle SQL and PL/SQL for Developers (2nd Edition)
- Recommended: Oracle Database 11g SQL and PL/SQL: A Brief Primer. download/pdf
- Recommended: ORACLE 10g PROGRAMMING A Primer. Rajshekhar Sunderraman. book website
- Homework (at least 4, not more than 6)
- Projects (3 - 4 Java/SQL projects)
- Midterm Exam (Date: TBD)
- Final Exam (Date: TBD). Final exam is cumulative.
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.
- CIS 5301 students have to do an extra project on a database related topic.
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.
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.