Database and File Management Systems

Course number: 
CIS 2109
Fall 2016
Name E-mail Office location
Nancy (Athanasia Polychronopoulou)
Science Education and Research Center (SERC), Room 341

o CIS 1073 or CIS 1068
o CIS 1166

1. Modern Database Management, 11th Edition. by Jeffrey A. Hoffer, V. Ramesh, Heikki
Topi, Published by Pearson
2. Class notes posted on blackboard
3. Oracle Database documentation
4. Kimball Group – Slowly changing Dimensions – Online documentation
Topics covered: 
1) Introduction to role of data, files and databases in information systems
2) Database development process
3) Data modeling concepts and the E-R model
4) Database design concepts (logical and physical)
5) Normalization
6) Advanced SQL
7) Develop an appreciation for several DBMS's (MySQL, ORACLE)
8) A broad range of data management issues including data integrity, security and
concurrent access control
9) Utilization of a CASE tool for data modeling and schema creation
10) Datawarehousing – Business Intelligence
11) Non – Relational databases
Course goals: 
At the completion of this course, the student should possess the following skills:
· Ability to query relational databases using complex SQL queries
· Ability to use SQL to create basic database objects (tables, keys, constraints)
· Ability to interpret business rules and use ER/UML design tools for building database
· Ability to detect anomalies and transform existing databases in an appropriate normal
· Understand the importance of data security , transaction integrity, concurrent access
· Ability to interact with a relational database from a programming environment such as
· Understand the difference between operational and historical databases
· Be aware that relational databases are not the only kind of database systems in use
Attendance policy: 
Class and lab attendance is advised but is not mandatory.
Class participation is important and can affect your final grade. There is a strict policy of
homework assignment and lab deadlines.
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