Module 2 Database Design

Introduction:

This Module is all about database design. It provides an overview of the Database Design and process. The conceptual design process will be explored and applied to the company database project. The data and database modeling will be reviewed. The Entity Relationship Diagram (ERD) for the database will be created according to the defined requirements from module 1.

Module Competencies:

• Organize a team and associated tasks and resources to gather customer requirements and business rules develop an ERD, develop the processing and security requirements, and develop the physical database structure.
• Develop an entity relationship diagram that reflects an organization’s business structure and business rules.
• Convert a conceptual model to a physical model based on the selected database management system.

Task 2:

Database Design Process – complete an ER Diagram for the proposed Database to include:

• Physical Model Diagram
• Design Presentation Slides
• Project Status
• Read / Review the following Sections from: Data Modeling-Logical Database Design
  • Section 1 (Data Modeling Theory & Concepts)
    • Workshop Section: Review and Complete the exercise
  • Section 2 (Building an Initial Data Model)
    • Workshop Section: Review and complete the exercise
  • Section 3 (Drawing A Model Using Software Engineering Tools)
    • Workshop Section: Review and complete the exercise
• Watch “Data Modeling” Video | Lynda
• Investigate on the web and in the resources: entities, attributes, domains and relationships
• Read/Review Chapter 6 (Functional Dependency and Normalization) from: Introduction to Database Management System
• Watch “Data Modeling” Video | Lynda
• Normalize set of tables
• Read / Review the following Section from: Data Modeling-Logical Database Design
  • Section 10 (Logical / Physical Model Transformation)
    • Workshop Section: Review and complete the exercise

.

• Logical Design Process
• Entity Relationship Modeling
• Normalization Process
• Physical Design Process

• Read/Review Chapter 2 (E-R and EER Models) from: Introduction to Database Management System
• Watch “Data Modeling” Video | Lynda

Database Modeling

Database Modeling: Relationships

• Develop the ER Diagram for database

Database Modeling: Optimization

Presentation Slides

Prepare presentation slides for database design

Module 2 Resources

eBook:

(http://library.books24x7.com.ezp-02.lirn.net/assetviewer.aspx?bookid=34047&chunkid=518679005&rowid=1072

http://library.books24x7.com.ezp-02.lirn.net/assetviewer.aspx?bookid=45790&chunkid=1&rowid=2

Lynda:

Database Modeling

http://www.lynda.com/Programming-tutorials/Foundations-Programming-Databases/112585-2.html

Websites:

Microsoft: http://msdn.microsoft.com/en-us/library/windows/desktop/ff728828(v=vs.85).aspx

Software:

Microsoft Visio