IT 9804 - Data Modeling - Database Design

Institution:

Inver Hills Community College

Subject:

Description:

Summary: This course introduces students to the concepts of data modeling and database design, a skill necessary for today's data-driven environment. Topics cover practical techniques for both entity/relationship and dimensional data modeling. Students will get hands-on experience using the ERwin data modeling tool suite. Duration: 4 sessions with lecture and lab Audience: This course will be of interest to business analysts, application developers, project leaders and database administrators. Course Overview: Part I - Entity / Relationship Modeling -Benefits of Data Modeling -Types of Data Models -Entities -Attributes -Relationships -Normalization -Complex Relationships -Building the Physical Database Part II - Dimensional Data Modeling -Benefits of Dimensional Data Modeling -Star Schemas -Dimensional Modeling Process -Facts -Dimensions -Slowing Changing Dimensions -Bridge Tables -Building the Dimensional Database

Credits:

0.00

Credit Hours:

Prerequisites:

Corequisites:

Exclusions:

Level:

Instructional Type:

Seminar

Notes:

Additional Information:

Historical Version(s):

Institution Website:

www.inverhills.edu

Phone Number:

(651) 450-3000

Regional Accreditation:

North Central Association of Colleges and Schools

Calendar System:

Semester

The Course Profile information is provided and updated by third parties including the respective institutions. While the institutions are able to update their information at any time, the information is not independently validated, and no party associated with this website can accept responsibility for its accuracy.