Close

browser 

Home  

CIS2109 - Syllabus  

Welcome to CIS 2109  (formerly CIS109)  !

This is an introductory course in data modeling, file management and database management systems (DBMS). It is a core course in the Information Sciences & Technology (IS&T) program in the CIS Department of the College of Science and Technology. It is a 4 credit hours course comprising of 3 hours lecture and 2 hours laboratory with a pre-requisite of a programming course (CIS 1073, formerly CIS81).
Databases are today an integral part of most information systems. In this course we will develop an understanding of how data is collected, organized, used and managed in information systems. The course covers both the traditional file management methods and database management systems.

One focus of the course is on conceptual modeling using the Entity-Relationship and Class Diagram models.  The conceptual model will provide the foundation for developing a logical and physical model of the database.  We will focus on the relational database model and see how the logical model of the database is implemented in a Database Management System. CASE tools are used in the Lab to develop the various models.

We will use both Microsoft Access and SQL Server as the Database Management System (DBMS) to develop simple information systems. This will involve designing and implementing tables, creating switchboard, forms, queries and reports to support to simple business process.

There will be a number of other database management topics covered in the course ranging from how to process data from databases using SQL, management database systems to current topics such as Data Warehousing.

This is the home page for CIS 2109, your gateway to most resources for this course. It provides information regarding course syllabus, assignments, projects, lab, links to other useful sites.  Click any of the topics on the left column to find out more about it.  Students taking the course, will need a password to gain access to the lecture notes.  To get back to this page, just click Home on the navigation bar on the left of the page.  Remember that assignments and projects will not be handed out in class. Rather, they will be posted on the web and you can download them from here.

This web resource will be used in conjunction with Temple's web conferencing, BlackBoard. You will need a separate password to access it. To get to BlackBoard click here.

For general information about the CIS Department click on:   www.temple.edu/CIS

Last Updated
Friday, August 15, 2008