|
Provided by: Serebra Learning Corporation Data ModelingData Modelling |
 |
Training
Provided by Serebra Learning Corporation
To be able to use a database to store data, you have to design it. The first step in designing a database is data modeling. Data modeling enables a database designer to create a model that represents the way in which information is likely to be organized in the database. This data model is then reviewed by the people who are expected to use the final database. Subsequent steps in database designing are performed only after the data model is approved. Individuals wishing to learn about database design. Database administrators would also benefit from this course.
|
|
||||||||||
Data Modeling
Audience
Individuals wishing to learn about database design. Database administrators would also benefit from this course.
Topics
Introduction to Data Modeling
- Overview of Data Modeling
- Components of Data Modeling
Developing a Basic Data Model
- Identifying Entities and Entity Type Hierarchies
- Identifying Entity Relationships
- Identifying Attributes
Normalizing and Minimizing the Data Model
- Normalization
- Ensuring Quality Design
Developing the Physical Model
- Documenting Physical Design Statistics
- Transition fr
Objectives
Upon completion of this course, the student will be able to:
- define data modeling
- list the features of a good data model describe the procedure of creating a data model list the key components of a logical data model
- list the steps involved in building a logical data model
- identify entities
- define entity type hierarchies
- describe the different types of entity relationships
- describe the features of an associative entity
- describe the types of attributes categorized on the basis of different classification criteria
- define the various categories of attribute types
- describe the concept of attribute keys in the context of referential integrity
- understand the concept of normalization
- normalize a data model to various forms of normalization
- define a well-designed data model
- understand data design rules
- list the statistics that need to be ga
About The Training Provider: Serebra Learning Corporation
Serebra Learning Corporation - Serebra Learning Corporation provides technology-based training solutions through a combination of Cortex, its proprietary learning management system (LMS), and a curriculum catalog with over 1,825 current courseware titles. Founded in 1987 (as FirstClass Systems, with a name change to Serebra in 2001), Serebra has over sixteen years" experience delivering e-learning solutions to both...
