MCCCD Official Course Competencies:

CCT225AC  20036-20086

Designing Data Services/Data Models

1.

Explain design processes as they pertain to business solutions and data-centric solutions. (I)

2.

Identify phases in the project life cycle. (I)

3.

Analyze business requirements. (II)

4.

Create a logical data design. (III)

5.

Identify primary components of the entity/relationship (ER) model. (III)

6.

Develop an ER model. (III)

7.

Explain procedures for normalization of logical data models. (IV)

8.

Create a physical data model. (V)

9.

Analyze data usage characteristics. (V)

10.

Explain optimization techniques for increasing database performance. (V)

11.

Identify business rules relating to data integrity. (VI)

12.

Demonstrate procedures for implementing data integrity procedures. (VI)

13.

Determine the role of data services for a business solution. (VII)

14.

Explain characteristics of various data access technologies. (VII)

15.

Select appropriate data access technology for given situations. (VII)

16.

Identify various types of hardware and software for implementing a data store. (VIII)

17.

Select appropriate data storage technologies. (VIII)

MCCCD Official Course Outline:

CCT225AC  20036-20086

Designing Data Services/Data Models

I. Solution Design Processes

A. Terms

B. Design Processes

1. Process Model

2. Gathering Requirements

3. Design Process Model

4. Data

5. Benefits

C. Services-Based Design

1. Application Model

2. Cooperating Services

3. Data Services

4. Benefits

D. Project Life Cycle

II. Data

A. Investigation Process

1. Gathering Information

2. Analyzing Information

3. Creating Use Codes

B. Requirements

1. Characteristics

2. Categories

3. Functional Data Requirement Identification

4. Non-Functional Data Requirement Identification

5. Data Validation

III. Logical Data Design

A. Need

B. Derivation Procedures

C. Entities/Attributes

1. Identification

2. Derivation

D. Data Relationships

1. Overview

2. Between Entities

3. Cardinality

4. Existence

E. Entity/Relationship (ER) Modeling

1. Syntax

2. Model Creation

IV. Normalization

A. Implementation

1. Keys

2. Primary Key

3. Foreign Keys

B. Model Basics

1. First Normal Form

2. Second Normal Form

3. Third Normal Form

C. Benefits

V. Physical Data

A. Design

1. Description

2. Identification

3. Common Types

B. Relationship Implementation

1. One-to-One

2. One-to-Many

3. Many-to-Many

C. Data Optimization Techniques

1. Goals

2. Data Creation

3. Data Retrieval

4. Data Updates

5. Data Deletion

VI. Data Integrity

A. Basic

1. Categories

2. Referential Integrity

3. Data Validation

4. Requirements

B. Implementation

1. Business Rules

2. Deployment

3. Database

4. Programmatic

5. Guidelines

VII. Data Services

A. Design

B. Deployment

C. Data Access

1. Relational

2. Non-Relational

3. Benefits

4. Flexibility

D. Host-Based Systems

1. Design

2. Access

3. Selection

VIII. Data Storage

A. Product Selection

1. User Community

2. System Performance

3. System Maintenance

B. Technologies

1. Excel

2. Jet

3. Visual FoxPro

4. Microsoft Data Engine (MSDE)

5. Structured Query Language (SQL)

C. Considerations

1. Backup/Restore

2. Redundant Array of Independent Disks (RAID)

3. Clustering

4. Disaster Recovery