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, 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.