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:
- 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.
- 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:
- Given a case scenario, students identify entities, attributes and relationships and then normalize these entities to third normal form with a minimum 75% accuracy.
- 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:
- Given a set of base tables, students demonstrate construction of a single-table query, with a minimum of 75% accuracy.
- Given a set of design specifications, students create a database schema using DDL statements, with a minimum of 75% accuracy.
- Given a set of case problems, students construct multi-table queries utilizing the various join methods, with a minimum of 75% accuracy.
- 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:
- 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.
- 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.
- 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
- Introducing Databases and Database Management Systems
- Designing a Database
- Implementing a Database using SQL
- Data Access and Manipulation using SQL
- Data Access and Security
- Database Processing for Business Intelligence Systems
- 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)
|