CIT 214

Practical and applied approach to database management design and development. Introduction to database planning, design and management, data modeling and representation, and fundamental concepts of database access. Includes the study of design models with a focus on the relational model and includes the commonly used database systems. Will include hands-on experiences. Prerequisite: CIT 168

What the Professor says...

Regarding the question of how the course material will help the student have a successful career? When considering the focus on Database Design and Development, this skill and the knowledge of Databases is critical among many career fields. Having this knowledge will go a long way in helping students broaden their attractability among corporations seeking to fill a wide variety of opportunities. As one can see via the list of course outcomes, students that complete CIT 214 are gaining hands-on experience within this course and are practicing the processes, etc., which helps students obtain a more clear understanding.  

What Students Say...

From a student: "I really enjoyed CIT 214 as it provided me with a practical and applied approach to database management design and development. The course covered a range of topics such as database planning, design, and management, data modeling, and representation. One of the most valuable skills that I gained from this course was the ability to apply SQL to create, read, update, and delete relational tables and records. Additionally, the course provided me with a clear understanding of recognized database principles such as basic entity relationship modeling, which allowed me to develop database designs more efficiently. I also appreciated the hands-on experiences and the opportunity to design and implement a normalized relational database. Overall, the course was very informative and has given me a great foundation in the field of database design and development. I feel confident that the knowledge and skills gained from CIT 214 will help me in my future career pursuits."

Helpful Tips...

At the end of this course, students should be able to: 

CIT 214.1 Explain common database terms and concepts.

CIT 214.2 Apply SQL to create, read, update, and delete relational tables and records.

CIT 214.3 Apply recognized database principles such as basic entity relationship modeling to develop database designs.

CIT 214.4 Design and implement a normalized relational database.

CIT 214.5 Describe current trends in the database field.

CIT 214.6 Identify factors that need to be considered when selecting database management systems.