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 Chaser’s Bark Shop 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
2026-2027
|
