|
Provided by: Serebra Learning Corporation CIW Database Specialist Part 2: Logical and Physical DesignCIW Database Specialist |
 |
This is the second course in a four part series that teaches students about normalization and logical and physical database design. This course will cover the normalization about the first second and third normal forms and also about Boyce-Codd Normal Form logical database design resolving relationships creating a logical data model and the various integrity constraints physical database design which introduces physical design creating enterprise constraints and database performance and access.
|
|
||||||||||
Audience
The intended audiences for this course include individuals who design implement and maintain database schemas; design and develop database client applications and components; and perform database administration and maintenance database developers enterprise developers application developers software engineers and Web developers. Recommend competency in object-oriented theory and Java programming. This course is mapped to the Master CIW Enterprise Developer certification program and exam 1D0-441. In addition students should have taken the first part of this series (87056).
Objective
- Identify features of normalization.
- Identify features of functional dependency.
- Identify features of first normal form (1NF).
- Identify considerations for creating a logical database design.
- Identify the types of relationships in a relational data model.
- Identify methods of resolving complex relationships.
- Identify characteristics of physical database design.
- Identify guidelines for creating base relations.
- Identify keywords used in data definition language (DDL).
Topics Include
Unit 1: Normalization
- Identify features of normalization.
- Identify features of functional dependency.
- Identify features of 1NF.
- Identify features of second normal form (2NF).
- Identify features of third normal form (3NF).
- Identify features of Boyce-Codd normal form (BCNF).
- Identify features of advanced normal forms.
Unit 2: Logical Database Design
- Identify considerations for creating a logical database design.
- Identify the types of relationships in a relational data model.
- Identify methods of resolving complex relationships.
- Identify guidelines for resolving relationships with attributes.
- Identify guidelines for identifying redundant relationships.
- Identify the syntax for organizing a relation by using the database definition language (DBDL).
- Identify guidelines for validating a logical data model.
- Identify features of domain integrity.
- Identify features of entity integrity.
- Identify features of referential integrity.
- Identify features of enterprise integrity.
- Sequence the steps for creating an enterprise data model.
- Identify advantages of using Computer-Aided Software Engineering (CASE) tools.
Unit 3: Physical Database Design
- Identify characteristics of physical database design.
- Identify guidelines for creating base relations.
- Identify keywords used in DDL.
- Access the Interactive Structured Query Language (SQL) Window.
- Create an InterBase relation.
- Identify guidelines for creating enterprise constraints.
- Identify guidelines for determining referential constraints.
- Identify features of secondary indexes.
- Identify features of denormalization.
- Identify guidelines for creating user views.
- Identify characteristics of database access rules.
Duration
8
Minimum Requirements
The CDROM version of this course requires:
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
- At least a double speed CDROM drive.
- An MPC compliant sound card with attached speakers or headphones is recommended (Currently only the CDROM version supports audio).
- At least a 486DX 33Mhz CPU.
- Microsoft Windows 3.1 or higher and a Microsoft compatible mouse.
- At least 8MB RAM and 22MB available hard disk space or file server space.
- At least VGA graphics capability with a minimum 512K video RAM (1MB video RAM recommended).
Media
Serebra Learning Corporation 119 - 7565 132nd Street Surrey BC V3W 1K5 Canada
