CPT 242 - Database

Class: 3 Credits: 3
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 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

Required Materials:

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

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 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
2022-2023