ITCS 1170 - Database Design & Implementation With SQL & XML

Prerequisite: ITCS-1140 or ITCS-1950

Prerequisite: ITCS-1010

Objectives:

1. Given an examination, students utilize appropriate terms, concepts and examples to explain what a database is, the various types and used in industry, with a minimum 85% accuracy.
2. Given an examination, students utilize appropriate terms, concepts and examples to describe end user interaction with databases and database maintenance, with a minimum of 85% accuracy.

Outcome 2: Upon completion of this course, students will be able to model and design a simple transaction processing database system utilizing the relational database model.

Objectives:

1. Given a case scenario, students identify entities, attributes and relationships and then normalize these entities to third normal form with a minimum 85% accuracy.
2. Utilizing a modeling software package, students create an entity relationship diagram utilizing a set of normalized entities with a minimum 85% accuracy.

Outcome 3: Upon completion of this course, students will be able to illustrate how to construct a basic SQL statement, formulate a multi-table query using various join techniques, and demonstrate server-side database administration commands.

Objectives:

1. Given a set of base tables, students demonstrate construction of a single-table query, with a minimum of 85% accuracy.
2. Given a set of design specifications, students create a database schema using DDL statements, with a minimum of 85% accuracy.
3. Given a set of case problems, students construct multi-table queries utilizing the various join methods, with a minimum of 85% accuracy.
4. Given a database schema, students construct both DDL and Outcome

Outcome 4: Upon completion of this course, students will be able to describe Extensible Markup Language (XML) and demonstrate how it is used.

Objectives:

1. Given a case scenario, students describe what XML is and how XML Document Object Model (DOM), XML Path Language (XPath), XSL Transformations (XSLT), and XQuery are used to create business solutions, with a minimum of 85% accuracy.
2. Given a set of base tables and a Relational Database Management System, students generate XML tags for a database schema, with a minimum of 85% accuracy.
3. Given as set of XML schemas, students validate the proper use of an instance document with a minimum of 85% accuracy.

1. Introducing Data and Data Management
2. Introducing Databases and Database Management Systems
3. Data Modeling
4. Designing a Database
5. Implementing a Database using SQL
6. Understanding the SQL Language
7. Data Access and Manipulation using SQL
8. Improving Data Access
9. Database Administration
10. Data Access and Security
11. Supporting Database Applications
12. Database Processing for Business Intelligence Systems
13. Database Processing with XML