CPT 242 - Database

Lecture Hours: 3 Credits: 3

Description: This course introduces data base models and the fundamentals of data base design. Topics include data base structure, data base processing, and application programs which access a data base.

Prerequisite(s): Take CPT 170 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 website

Required Materials:

USB Flash Drive
Microsoft Office Professional Edition (Word, Excel, Access, PowerPoint)

Grading System:
An overall grade of C or higher is required for transferability.

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 Course Policies that include:

Identity Verification
Required materials for all online courses
Mandatory Attendance Requirement
Orientation and Support
Proctored Exams

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

Academic Integrity
Add/Drop period
Attendance
Classroom Conduct
Equal Access
IT Access
Online Behavior
Online Confidentiality
Services For Students with Disabilities
Student Concerns
Student Help Services
Withdrawals

Official Course Syllabus
2023-2024