Jul 19, 2024  
2023-2024 Catalog 
    
2023-2024 Catalog Archived

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:
  1. Design and create a database
  2. Design and create tables
  3. Design and create queries
  4. Design and create forms
  5. Design and create reports
  6. 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


SCC Logo
Official Course Syllabus
2023-2024