Course Number / Section:

CIS 2109 / 001 and 002

Course Title:

Database and File Management Systems


Dr. Gary Baram


Wachman Hall, Room 305




Web Site for Complete  Syllabus:

Course Web Pages:



CIS 1073


Modern Database Management, 7th Edition. by Jeffrey A. Hoffer, Mary B. Prescott and Fred R. Mcfadden. Published by Prentice Hall.

Class notes posted on the website  



Course Goals:

•   Develop an appreciation of the role of data, files and databases in information systems.

•   Understand the database development activities during the System Development Life Cycle (SDLC)

•   Be familiar with data modeling concepts (E-R and Class diagrams) used in database development.

•    Be able to create databases and pose complex SQL queries of relational databases.  

•    Develop an appreciation for several DBMS's (ACCESS, SQL Server and ORACLE)

•    Be familiar with a broad range of data management issues including data integrity and security. 

•   Utilize a CASE tool for data modeling and schema creation.




Topics Covered:

Students will develop an understanding of  DBMS, data modeling., SQL and how to develop simple information system utilizing a  DBMS.




Attendance Policy:


Attending classes is critical for you to be successful in this course.  The “other” portion of your grade includes your attendance.   Class and lab participation are integral for this class to be effective.