Oct 26, 2020  
2018-2019 Catalog 
2018-2019 Catalog [ARCHIVED CATALOG]

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 .
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

Textbook information can be found on the Book Inn Web site www.sccsc.edu/bookstore
Required Materials:
  • USB Flash Drive (min. capacity 8 Gb.)
  • Skills Assessment Manager Office 2013 (SAM 2013) - Assessment, Projects, and Training Microsoft
  • Office 2013 and Microsoft Office 2013 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:
  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 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

SCC Logo
Official Course Syllabus