Official Course Description: MCCCD Approval: 07/22/08
MST146 20026-20086	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.

Go to Competencies    Go to Outline
 

MCCCD Official Course Competencies:
MST146   20026-20086	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   20026-20086	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