CIT 230 - Database Systems

 
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.

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.

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

• Technological Competence
• Critical Thinking and Problem Solving

Course and Section Search