Mar 01, 2021  
2020-2021 Catalog 
    
2020-2021 Catalog
Add to Portfolio (opens a new window)

CIT 230 - Database Systems


Credits: 4
4 Lecture Hours

Prerequisites: CIT 111  or CIT 130  or CIT 145  or CIT 161  or permission of the instructor.

 
Description
This course covers information systems design and implementation within a database management system (DBMS) environment.  Students learn to create data models of user's needs, gain foundation skills in database design and learn to use standard Structured Query Language (SQL) to interact with databases. The focus of the course includes the relational database model, the Entity-Relationship (E-R) model, SQL, database design and implementation, database normalization and multiuser DBMS administrative management.


Learning Outcomes
Upon successful completion of the course, the student will:

  1. Demonstrate an understanding of database design terminology, concepts and applications.
  2. Create data modeling using the Entity-Relationship (E-R) model.
  3. Construct a database using SQL.
  4. Demonstrate application processing using SQL.
  5. Create a database application system with a representative DBMS that includes appropriate programming procedures, form, report and menu/applications generators.
  6. Identify DBMS administrative functions, including concurrency control, database security and recovery processes.
Listed Topics
  1. Database concepts and terminology
  2. The relational model
  3. Structured Query Language (SQL)
  4. The Entity-Relationship (E-R) model
  5. Database normalization
  6. DBMS design and implementation
  7. Programming methodology for automating procedures: syntax, control structures and algorithm development
  8. DBMS administrative functions, concurrency controls and database security
Reference Materials
Textbooks/materials, current and appropriate software, multimedia for lecture and demonstration as required by instructor; access to the Internet.
Students who successfully complete this course acquire general knowledge, skills and abilities that align with CCAC's definition of an educated person. Specifically, this course fulfills these General Education Goals:
  • Technological Competence
  • Critical Thinking and Problem Solving
Approved By: Bullock, Quintin Date Approved: 03/15/2019


Course and Section Search




Add to Portfolio (opens a new window)