May 18, 2024  
Official Course Syllabi 2018-2019 
    
Official Course Syllabi 2018-2019 [ARCHIVED CATALOG]

Add to Favorites (opens a new window)

ITCS 1170 - Database Design & Implementation With SQL & XML


Credit Hours: 4.00
(4 contact hrs)
No credit after ITCS-2280. ITCS-1170 familiarizes students with database usage, design, and implementation. It also explores fundamentals of Structured Query Language (SQL) along with Extensible Markup Language (XML).

Prerequisites:
 

Prerequisite: ITCS-1140 or ITCS-1950

Prerequisite: ITCS-1010


OUTCOMES AND OBJECTIVES
Outcome 1: Upon completion of this course, students will be able to describe a database, the different types and the various applications of databases as it pertains to common industry usage.

Objectives:

  1. Given an examination, students utilize appropriate terms, concepts and examples to explain what a database is, the various types used in industry, with a minimum 75% 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 75% 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 75% accuracy.
  2. Utilizing a modeling software package, students create an entity relationship diagram utilizing a set of normalized entities with a minimum 75% 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 75% accuracy.
  2. Given a set of design specifications, students create a database schema using DDL statements, with a minimum of 75% accuracy.
  3. Given a set of case problems, students construct multi-table queries utilizing the various join methods, with a minimum of 75% 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 75% 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 75% accuracy.
  3. Given as set of XML schemas, students validate the proper use of an instance document with a minimum of 75% accuracy.

COMMON DEGREE OUTCOMES
(Bulleted outcomes apply to the course)

  • 1. The graduate can integrate the knowledge and technological skills necessary to be a successful learner.
  • 2. The graduate can demonstrate how to think competently.
  • 3. The graduate can demonstrate how to employ mathematical knowledge.
  • 4. The graduate can demonstrate how to communicate competently.
  • 5. The graduate is sensitive to issues relating to a diverse, global society.

COURSE CONTENT OUTLINE
 

  1. Introducing Databases and Database Management Systems
  2. Designing a Database
  3. Implementing a Database using SQL
  4. Data Access and Manipulation using SQL
  5. Data Access and Security
  6. Database Processing for Business Intelligence Systems
  7. Database Processing with XML

Primary Faculty
Jenaway, Elizabeth
Secondary Faculty

Associate Dean
Evans-Mach, Patrick



Official Course Syllabus - Macomb Community College, 14500 E 12 Mile Road, Warren, MI 48088



Add to Favorites (opens a new window)