IS 362: Applied Database Management

Course Description:

This course builds on the Data Management Concepts course and focuses on the creation, administration and use of databases. This course assumes a knowledge of database system concepts. The student will be introduced to application program development in a database environment with emphasis on setting up, modifying, and querying a database. Prerequisite: IS 361. 3:0:3

Learning Outcomes:

Upon completion of this course, the student should be able to:

1. Explain and apply the fundamentals of Structured Query Language (SQL).
2. Use SQL to create the tables, build report forms and create queries for updating and displaying data within a database.
3. Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
4. Design and build a relational database.
5. Assess the duties of the database administrator.
6. Identify the creation and use of metadata and data dictionaries.
7. Identify the issues surrounding design of an effective database solution such as concurrency, efficiency, management of and security.
8. Use Case Tool(s) to design database schemas.
9. Describe and understand the role of web-enabling databases, object-oriented database, and relational database.

Assessment Measures:

Assessment Tool	Linkage to Learning Outcome #:
Homework Assignments:
Instructor will utilize various exercises in modeling and SQL to evaluate student's ability to demonstrate objectives and understand concepts.	1-9
To achieve "creativity and problem solving skills, "students must be required to produce programming project solutions from a given problem description. Note that objectives are not met if a student is only able to produce solutions by pasting together given code fragments. Although this is appropriate at times, it does not enforce the development of these skills.	2-4,8
Exams:
Tests will be used to evaluate student's ability to understand terminology and basic concepts of applying data management. This should include at minimum a final and include at least one or more of the following: short answer, trace given code, debug given code, and/or develop a fragment of code given a problem description.	1-8

Textbooks

To view the approved textbook list, click here.