This course introduces database design and creation using a DBMS product. Emphasis is placed 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.

This course is designed to develop SQL programming profi ciency. Emphasis is placed on data defi nition, 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.

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 fi les. Upon completion, students should be able to create multiple table systems that demonstrate updates, screens, and reports representative of industry requirements.