CPT 242 - Database

Class: 3 Credits: 3
This course introduces database models and the fundamentals of database design. Topics include database structure, database processing, and application programs which access a database.

Prerequisite(s): Take CPT 101 with a minimum grade of “C”.

Course Topics:

Creating a Database
Building a Database and Defining Tables
Maintaining and Querying a Database
Creating Forms and Reports
Creating Advanced Queries and Enhancing Table Design
Using Form Tools and Creating Custom Forms
Creating Custom Reports
Sharing, Integrating and Analyzing Data

Textbooks:
Textbook information can be found on the Book Inn Web site

Grading System:
A grade of “C” is required for all course work.

A 90 - 100
B 80 - 89
C 70 - 79
D 60 - 69
F 0 - 59

Student Learning Outcomes:

Design and create a database
Design and create tables
Design and create queries
Design and create forms
Design and create reports
Explain the role of the database management system (DBMS) in a database integrity.

For SCC Online Courses:
If the course you are taking is online, please review the SCC Online Policies that include:

Required materials for all online courses
Mandatory Attendance Requirement
Proctored Exams

Standard SCC Course Policies:
Please review the Standard SCC Course Polices on the following topics:

Academic Integrity
Academic Misconduct
Add/Drop period
Appeals Process
Class Attendance
Classroom Behavior (traditional and online)
Classroom Conduct/Expectations
Lab Procedures (general SCC policy regarding this)
Online Confidentiality
Services For Students with Disabilities
Withdrawal Policy

Official Course Syllabus
2021-2022