2023-2024 Yavapai College Catalog 
    
    Dec 11, 2024  
2023-2024 Yavapai College Catalog [PREVIOUS CATALOG YEAR]

CSA 282 - Database Concepts


Description: Concepts, design, implementation, evaluation, and maintenance techniques of databases. Includes fundamentals of data model, data structure and data management.

Credits: 3
Lecture: 3
Course Content:
  1. Database concepts
  2. Relational database and normalization
  3. Data models
  4. Database design
  5. SQL for building tables and queries
  6. Building and customizing a form
  7. Building and customizing a report
  8. Database processing applications
  9. Database administration

Learning Outcomes:
  1. Define database terms. (1,2)
  2. Analyze, define, and design a relational database model. (3,4)
  3. Construct a database complete with tables, queries, forms and reports using a database program. (4-7)
  4. Create SQL for data analysis and manipulation. (4,5,8)
  5. Perform database administration. (9)