CIT 230 - Database Systems
4 Lecture Hours
Prerequisites: CIT 111 or CIT 130 or CIT 145 or CIT 161 or permission of the instructor.
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.
Upon successful completion of the course, the student will:
- Demonstrate an understanding of database design terminology, concepts and applications.
- Create data modeling using the Entity-Relationship (E-R) model.
- Construct a database using SQL.
- Demonstrate application processing using SQL.
- Create a database application system with a representative DBMS that includes appropriate programming procedures, form, report and menu/applications generators.
- Identify DBMS administrative functions, including concurrency control, database security and recovery processes.
- Database concepts and terminology
- The relational model
- Structured Query Language (SQL)
- The Entity-Relationship (E-R) model
- Database normalization
- DBMS design and implementation
- Programming methodology for automating procedures: syntax, control structures and algorithm development
- DBMS administrative functions, concurrency controls and database security
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:
Approved By: Bullock, Quintin Date Approved: 03/15/2019
- Technological Competence
- Critical Thinking and Problem Solving
Course and Section Search
Add to Portfolio (opens a new window)