Data modeling
- Is a conceptual representation of data structure.
- It is very powerful of expressing & communicating the business requirement.
- Model represent nature of data & Business rule.
- Data model helps functional & Technical team in designing database.
- Data modeler responsible for designing the data model & they communicate with functional team to get requirement and technical team to implement the database.
Importance of Data Model
- Make sure that all data object provided by functional team are completely & accurately represented.
- Data model very used full to technical team to built physical database.
- Data model will be used to define significance of business, Relational tables, primary & foreign key & stored procedure.
- Make sure that all data object provided by functional team are completely & accurately represented.
- Data model very used full to technical team to built physical database. Data model will be used to define significance of business, Relational tables, primary & foreign key & stored procedure.
Step to Create Data Model
- Get Business Requirement
- Create High level Conceptual Data Model
- Create Logical Data Model.
- Select target database where data modelling tool create the physical schema.
- Create Entities and attributes.
- Assign Data type to Attributes.
- Create Primary & Unique to attributes.
- Create indexes on a attributes.
- Create foreign key relationship between attributes.
- Create physical data model.
- Create SQL script from physical data model & forward toDBA.
- Maintain logical & physical Data model.
Data Modelling Development Life Cycle
First Phase : Gathering business
requirements
Data
Modeller have to interact with business analysts to get the functional
requirement and with End users to find out the reporting needs.
Second Phase: Conceptual Data
Modelling
This data
model includes all entities, relationship and it will not contain much details
about attributes. This is initial planning phase.
Third Phase: Logical Data Model
A Logical
Model is the version of the model that represent all of the business
requirements of an organization.
Fourth Phase: Physical Data Model.
This is a
complete model that include all required tables, column, relationship, database
properties for the physical implementation of data Database.
0 comments:
Post a Comment