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

Textbooks:
Textbook information can be found on the Book Inn Web site

Required Materials:

Computer with Internet Access, Google Chrome browser, and anti-virus software.

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

Required materials for all online courses
Mandatory Attendance Requirement
Proctored Exams

Face Covering Requirements:
All faculty, staff and students must wear a face mask/covering at all times (absent a medical condition) on all SCC campuses when safe social distancing measures are not possible or difficult to follow. For further details, refer to the Student Guidelines for Face Coverings and Social Distancing on the SCC Coronavirus COVID-19 Information page.

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

Official Course Syllabus
2020-2021