Maricopa Community Colleges  MST146   20006-20025 
Official Course Description: MCCCD Approval: 06/27/00
MST146 20006-20025 L+L 2 Credit(s) 3 Period(s)
Data Modeling and Relational Database Design
Top-down, systematic approach to developing a relational database and defining requirements as entities, attributes, and relationships. Developing an entity-relationship (ER) diagram that accurately reflects the business. Mapping the ER diagram to an initial database design. Prerequisites: CIS105, or MST140, or permission of instructor.
 
Course Note:Under the terms and conditions specified in the legal agreement between Microsoft Corporation and each AATP campus in the Maricopa Community College District, Microsoft requires that "all instructors of Microsoft Official Curriculum and Microsoft Approved Study Guides pass the Microsoft Certified Professional exam in the product area of the courseware being delivered."
Go to Competencies    Go to Outline
 
MCCCD Official Course Competencies:
 
MST146   20006-20025 Data Modeling and Relational Database Design
1. Describe the stages of the database development process. (I)
2. Develop basic data models. (II)
3. Develop data models. (III)
4. Map a simple entity-relationship (ER) diagram to an initial database table design. (IV)
5. Map a complex ER diagram to an initial database table design. (V)
Go to Description    Go to top of Competencies
 
MCCCD Official Course Outline:
 
MST146   20006-20025 Data Modeling and Relational Database Design
    I. Stages of Database Development Process
        A. Top-down database development approach
        B. How this approach relates to entire system development life cycle
      II. Basic Data Models
          A. Analyzing basic user information requirements
          B. Developing entity-relationship (ER) diagrams expressing the requirements
        III. Data Models
            A. Analyzing complex user information requirements
            B. Developing ER diagrams by applying advanced data modeling concepts
          IV. Mapping a Simple ER Diagram to Initial Database Table Design
              A. Applying principles and concepts of relational database design
              B. Mapping the ER diagram
            V. Mapping a Complex ER diagram to Initial Database Table Design
                A. Evaluating and choosing appropriate design options for complex entities, attributes, and relationships
                B. Mapping the complex ER diagram
            Go to Description    Go to top of Competencies    Go to top of Outline