Database Management Systems

Course number: 
CIS 2109
Semester: 
Fall 2015
Instructors:
Name E-mail Office location
Athanasia Polychronopoulou n.polychr@temple.edu
Science Education and Research Center (SERC), Room 341
Prerequisites: 
CIS 1068 | Minimum Grade of C- | May not be taken concurrently.
Textbooks: 
  1. Modern Database Management, 11th Edition. by Jeffrey A. Hoffer, V. Ramesh, Heikki Topi, Published by Pearson
  2. Class notes posted on blackboard
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. Advanced SQL
  6. Develop an appreciation for several DBMS's (ACCESS, SQL Server and ORACLE)
  7. A broad range of data management issues including data integrity and security
  8. Utilization of a CASE tool for data modeling and schema creation
Course goals: 
This is an introductory course in database management systems (DBMS) and file management systems. The course will cover the role of data, files and databases in information systems, data modeling concepts, data definition and manipulation using SQL, issues in data management and the development and implementation of database applications. Students will work in the Lab on various assignments including prototyping and SQL, utilizing state of the art DBMS and CASE tools. 
 
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. (http://www.temple.edu/studentaffairs/disability/accommodations/).
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 http://policies.temple.edu/PDF/99.pdf.