Park.edu Home > Skip Navigation LinksICS Home > Majors and Courses > Courses >

IS 362 : Applied Database Management

Course Description

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

Learning Outcomes

  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 the role of web-enabling databases, object-oriented database, and relational database.

Teaching Directives:

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

View the approved textbook list.

^ Back to the Top

---------------------------------

University Resources


This page was last modified on Monday, September 12, 2011