Course Number / Section:	CIS 2109 / 001 and 002
Course Title:	Database and File Management Systems
Instructor:	Dr. Gary Baram
Office:	Wachman Hall, Room 305
Email:	baram@temple.edu
Phone:	215-204-6847
Web Site for Complete Syllabus:	http://ww2.cis.temple.edu/barampublic/cis109/syllabus.htm
Course Web Pages:	http://ww2.cis.temple.edu/barampublic/cis109
Prerequisites:	CIS 1073
Textbook(s):	Modern Database Management, 7^th 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.