Maricopa Community Colleges  CIS175BC   20036-20086 
Official Course Description: MCCCD Approval: 07/22/08
CIS175BC 20036-20086 L+L 2 Credit(s) 3 Period(s)
Designing Data Services/Data Models
Procedures for extraction of data requirements from a conception model. Generation of a logical data design proceeding through the physical data design. Includes database systems and data access technologies.
Prerequisites: Experience in the basic administration of Microsoft Windows 2000.
Cross-References: CCT225AC
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
CIS175BC   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)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
CIS175BC   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
                  Go to Description    Go to top of Competencies    Go to top of Outline