Skip to main content

2025-2026 College Catalog > Course Descriptions > CPS - COMPUTER SCIENCE > 100 > CPS170

http://northshore.smartcatalogiq.com/
0870eff7-0e79-4c51-8358-79638942fc70
https://searchproxy.smartcatalogiq.com/search
41c5d55e-c0a3-4ea4-969e-53439ddb878d
course
/Institutions/North-Shore-Community-College/json/Current/college-catalog-local.json
/Institutions/North-Shore-Community-College/json/Current/college-catalog.json
Contents
  • NSCC Locations
  • President's Welcome
  • Academic Calendar 2025-2026
  • Institutional Policies
  • Student Handbook
  • Academic and Student Success Services
  • Credit Programs
  • Course Descriptions
    • ACC - ACCOUNTING
    • ALH - ALLIED HEALTH
    • ANS - ANIMAL SCIENCE
    • ANT - ANTHROPOLOGY
    • ART - ART
    • ASL - AMERICAN SIGN LANGUAGE
    • AVS - AVIATION SCIENCE
    • BIO - BIOLOGY
    • BQC - QA & CONTROL BIOTECH
    • BTN - BIOTECHNOLOGY
    • BUS - BUSINESS SCIENCES
    • CAD - COMPUTER AIDED DESIGN
    • CBS - CONSTRUCTION AND BUILDING SCIENCE
    • CHE - CHEMISTRY
    • CMP - COMPOSITION
    • COS - COSMETOLOGY
    • CPS - COMPUTER SCIENCE
      • 100
        • CPS100
        • CPS101
        • CPS102
        • CPS109
        • CPS114
        • CPS122
        • CPS124
        • CPS130
        • CPS134
        • CPS136
        • CPS138
        • CPS140
        • CPS148
        • CPS168
        • CPS170
        • CPS173
        • CPS177
        • CPS182
      • 200
    • CRJ - CRIMINAL JUSTICE
    • DAN - DANCE
    • DRA - DRAMA
    • DRG - DRUG AND ALCOHOL REHAB
    • DTC - NUTRITIONAL SCI & DIET TECH
    • DVD - DEVELOPMENTAL DISABILITIES
    • ECE - EARLY CHILDHOOD EDUCATION
    • ECO - ECONOMICS
    • EDU - EDUCATION
    • EGS - ENGINEERING SCIENCE
    • EGT - ENGINEERING TECHNOLOGY
    • EMS - EMERGENCY MEDICAL SERVICES
    • ENT - ENTREPRENEURSHIP
    • ESL - ENGLISH AS A SECOND LANGUAGE
    • EVS - ENVIRONMENTAL SCIENCE
    • FFL -FIRST YEAR FOUNDATIONAL LITERACY
    • FIN - FINANCE
    • FNS - FUNERAL SERVICES
    • FPS - FIRE PROTECTION AND SAFETY
    • FRE - FRENCH
    • GEO - GEOSCIENCES
    • GRA - GRAPHIC ARTS
    • GWS - Gender and Women's Studies
    • HIS - HISTORY
    • HLS - HEALTH SUPPORT
    • HON - HONORS
    • HRT - HORTICULTURE
    • HSP - HOSPITALITY
    • HUS - HUMAN SERVICES
    • IDS - INTERDISCIPLINARY STUDIES
    • INTERNSHIP
    • LIT - LITERATURE
    • LNG - LANGUAGE
    • MAC - MEDICAL ASSISTING
    • MAT - MATHEMATICS
    • MDA - MEDIA
    • MET - MANUFACTURING TECHNOLOGY
    • MGT - MANAGEMENT
    • MKT - MARKETING
    • MUS - MUSIC
    • NSG - NURSE EDUCATION
    • OFT - OFFICE ADMINISTRATION
    • OTA - OCCUPATIONAL THERAPY ASSISTANT
    • PER - PERSONAL DEVELOPMENT
    • PHI - PHILOSOPHY
    • PHY - PHYSICS
    • PLG - PARALEGAL
    • PLS - POLITICAL SCIENCE
    • PNR - PRACTICAL NURSING
    • POR - PORTUGUESE
    • PRO - PROFESSIONAL PORTFOLIO
    • PSY - PSYCHOLOGY
    • PTA - PHYSICAL THERAPIST ASSISTANT
    • RAD - RADIOLOGIC TECHNOLOGY
    • REL - RELIGION
    • RSP - RESPIRATORY CARE
    • RUS - RUSSIAN
    • SCI - SCIENCE
    • SOC - SOCIOLOGY
    • SPE - SPEECH
    • SPN - SPANISH
    • SRG - SURGICAL TECHNOLOGY
    • VET - VETERINARY TECHNOLOGY
  • Elective Course Options
  • Non-Credit and Professional Programs
  • Faculty and Staff
  • Editor
  • Addendum
Catalog Links
  • Catalog Home
  • Site Map
  • All Catalogs
Share
Print this page
/Institutions/North-Shore-Community-College/json/catalogs.json
0870EFF7-0E79-4C51-8358-79638942FC70

CPS170 Database Theory and Applications

This course is an introduction to database theory and applications. Topics will include Database design, foundation for the relational database model, Structured Query Language (SQL), Entity Relationship (E-R) Modeling, normalization, advanced database design and implementation, and file indexing. Fulfills CPS - Computer Science, EUT - Energy Utility Directed, NDIR - Nurse Ed Directed, OPEN, STEM, and WD - Web Development electives.

Credits

4

Prerequisite

CPS100

Electives

  • CPS - Computer Science Elective
  • EUT - Energy Utility Directed Elective
  • NDIR - Nurse Ed Directed Elective
  • OPEN - Open Elective
  • STEM - STEM Elective
  • WD - Web Development