DBA 110  Database Concepts

This course introduces database design and creation using a DBMS product. Emphasis is on data dictionaries, normalization, data integrity, data modeling, and creation of simple tables, queries, reports, and forms. Upon completion, students should be able to design and implement normalized database structures by creating simple database tables, queries, reports, and forms.

Course Hours Per Week: Class, 2; Lab, 3

Semester Hours Credit: 3

Prerequisite: CIS 110

Corequisite: None

DBA 115  Database Applications

This course applies concepts learned in DBA 110 to a specific DBMS. Topics include manipulating multiple tables, advanced queries, screens and reports, linking, and command files. Upon completion, students should be able to create multiple table systems that demonstrate updates, screens, and reports representative of industry requirements.

Course Hours Per Week: Class, 2; Lab, 3

Semester Hours Credit: 3

Prerequisite: DBA 110

Corequisite: None

DBA 120  Database Programming I

This course is designed to develop SQL programming proficiency. Emphasis is on data definition, data manipulation, and data control statements as well as on report generation. Upon completion, students should be able to write programs which create, update, and produce reports.

Course Hours Per Week: Class, 2; Lab, 2

Semester Hours Credit: 3

Prerequisite: CIS 110 or CIS 115

Corequisite: None

DBA 220  Oracle DB Programming II

This course is designed to enhance programming skills developed in DBA 120. Topics include application development with GUI front-ends and embedded programming. Upon completion, students should be able to develop an Oracle DBMS application which includes a GUI front-end and report generation.

Course Hours Per Week: Class, 2; Lab, 2

Semester Hours Credit: 3

Prerequisite: DBA 120

Corequisite: None