IT 240 Introduction to Databases

Kumail Razvi

Winter 2019-2020
Class number: 22384
Section number: 801
Tu 6:00PM - 9:15PM
LEVAN 00302 Lincoln Park Campus


This course will introduce students to the design, implementation and use of desktop databases. Major topics include: modeling using ER diagrams, creating and maintaining a database using a PC based application, compose and use queries in Structured Query Language, create and customize forms and reports, and integrate databases with other sources of data and applications.


Database Concepts 9th Edition David Kroenke and David Auer, Prentice Hall, 2014 ISBN: 9780135188149



Learning Outcomes

Identify the use of databases

Determine the risks and effects of data redundancy, inconsistencies and lack of integrity in poorly designed databases

Construct Structured Query Language (SQL) statements to perform basic database operations.

Create Entity Relationship Diagrams to graphically model database.

Construct and maintain a database within a domain that implements the constraints of the relational database model.

School policies:

Changes to Syllabus

This syllabus is subject to change as necessary during the quarter. If a change occurs, it will be thoroughly addressed during class, posted under Announcements in D2L and sent via email.

Online Course Evaluations

Evaluations are a way for students to provide valuable feedback regarding their instructor and the course. Detailed feedback will enable the instructor to continuously tailor teaching methods and course content to meet the learning goals of the course and the academic needs of the students. They are a requirement of the course and are key to continue to provide you with the highest quality of teaching. The evaluations are anonymous; the instructor and administration do not track who entered what responses. A program is used to check if the student completed the evaluations, but the evaluation is completely separate from the student’s identity. Since 100% participation is our goal, students are sent periodic reminders over three weeks. Students do not receive reminders once they complete the evaluation. Students complete the evaluation online in CampusConnect.

Academic Integrity and Plagiarism

This course will be subject to the university's academic integrity policy. More information can be found at If you have any questions be sure to consult with your professor.

Academic Policies

All students are required to manage their class schedules each term in accordance with the deadlines for enrolling and withdrawing as indicated in the University Academic Calendar. Information on enrollment, withdrawal, grading and incompletes can be found at

Students with Disabilities

Students who feel they may need an accommodation based on the impact of a disability should contact the instructor privately to discuss their specific needs. All discussions will remain confidential.
To ensure that you receive the most appropriate accommodation based on your needs, contact the instructor as early as possible in the quarter (preferably within the first week of class), and make sure that you have contacted the Center for Students with Disabilities (CSD) at:
Lewis Center 1420, 25 East Jackson Blvd.
Phone number: (312)362-8002
Fax: (312)362-6544
TTY: (773)325.7296