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:

What is File System Data Processing
What is Data Base Management Systems
What are Business Rules and why are they important
What is the Relational Database Model
What are Keys and Integrity Rules
Learn and Develop the Entity Relationship Model
Learn the Normalization process
Learn the basics of the Structured Query language (SQL)
Use an DBMS software package to set up a database
What are Distributed Databases
What is a Data Warehouse