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:
- Explain and apply the fundamentals of Structured Query Language (SQL).
-
Use SQL to create the tables, build report forms and create queries for updating and
displaying data within a database.
- Utilize SQL to build queries to extract data from multiple tables based on selection criteria.
- Design and build a relational database.
- Assess the duties of the database administrator.
- Identify the creation and use of metadata and data dictionaries.
-
Identify the issues surrounding design of an effective database solution such as concurrency,
efficiency, management of and security.
- Use Case Tool(s) to design database schemas.
-
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.
