CITA 130 - Introduction to Database Systems

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

Prerequisite(s): CITA 110 for non-computer majors

Restriction(s): None

Corequisite(s): None

This course is an introduction to the use and design of data base management systems (DBMS). The student will gain practical knowledge of DBMS software using a leading personal computer package. The student will be directed through the setup of tables, the use of forms and reports, introductory macro controls, simple database control programming, database administration, and database query procedures. The student will also be introduced to database design concepts including entity relationship diagrams and normalization.

Student Learning Outcomes of the Course:

Student is able to create a database file
Student understands the organizations of objects within the file
Student understands the use of, and the creation of queries
Student understands the creation and use of forms and reports
Student is able to create a table and use appropriate field types
Student is able to enter data correctly within the table.
Student is introduced to macros and is able to create and execute a simple macro
Student is introduced to a procedural language
Student learns what normalization is and the steps of normalization
Student is able to normalize a simple table to 3rd normal form