database design 23
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
- Section 1 (Data Modeling Theory & Concepts)
- 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
- Section 10 (Logical / Physical Model Transformation)
.
- 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: 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=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