DBA 115 Database Applications

Lecture: 2 Lab: 2 Clinic: 0 Credits: 3

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.

Pre-requisite(s): DBA 110.
Course is typically offered in Fall.
Course has transfer restrictions - 10 years

Student Learning Outcomes (SLOs)
At completion of the course, the student should be able to do the following:

Apply the process of normalization to third normal form in a multi-table entity-relationship diagram (ERD) individual class project.
Produce a database schema from a conceptual database design and an ERD as an individual class project.
Explain database security issues through research papers and classroom discussion.
Assess the importance of indexes in database performance tuning as part of a class project.
Create a database in Access from a logical schema as part of a class project.