CITA 340 - Database Concepts

Credit Hours: 3
Lecture Hours: 3
Laboratory Hours: 0

Prerequisite(s): CITA 130

Restriction(s): None

Corequisite(s): None

The course is a study of the terminology, hardware, and software associated with data base systems. Topics include file organizations and access methods, historical development of data bases, data organization and structure, relational data bases, types of data base languages, CODASYL data description language and comparison of data base techniques and traditional approaches. Students will design, write, test and debug programs that manage traditional files and databases.

Student Learning Outcomes of the Course:

Define File System Data Processing and Data Base Management Systems
Define the Relational Database Model, primary keys and Integrity Rules
Explain and Design a macro
Develop the Entity Relationship Model
Apply the basics of the Structured Query language (SQL)