CIS 125D Software Tools 1: Databases

Fundamental relational database concepts, vocabulary, functionality and skills are covered. Students will apply those skills in a series of hands-on case problems where they design, implement, test, debug and document relational database solutions to case problems.

Credits

4

Prerequisite

Basic computer literacy

Course Learning Outcomes

Upon successful completion of this course, the student will be able to:
1. Describe in his/her own words the meaning and usage of relational database concepts and vocabulary
2. Use a representative relational database package to implement database tables, queries, forms and reports
3. Evaluate the appropriateness of the use of a relational database in the solution of a case problem
4. Design relational database tables, queries, forms and reports that could be used in the solution of a case problem
5. Test queries, forms and reports to determine the reasonableness of the results produced in a variety of circumstances
6. Debug a query, form and/or report that produces error messages and/or incorrect results
7. Automate typical database tasks