Tag: maintain data model

Steps to create and maintain a new data model from business requirements:

These are the general guidelines to create a standard data model and in real time, a data model may not be created in the same sequential manner as shown below. Based on the enterprise’s requirements, some of the steps may be excluded or included in addition to these.

Sometimes, data modeler may be asked to develop a data model based on the existing database. In that situation, the data modeler has to reverse engineer the database and create a data model.

Note:

As a data modeler, the intention is to create tables, columns, datatype, not null, primary keys, and foreign keys. If there is a need for sequence, views, triggers and other database parameters, the data modelers should not take a hasty decision by embedding all objects in the data model. Before creating the data model, it is a good practice to understand the database object creation process by discussing with DBAs or top-notch technical executives and take it forward.

Steps to create a Logical Data Model:

Get Business requirements.

Analyze Business requirements.

Create High Level Conceptual Data Model. Get it approved.

Create a new Logical Data Model. Add the following to the logical data model.

Steps to create a Physical Data Model:

Generate SQL Scripts from Physical Data Model. Tick or check the necessary parameters in the tool, create scripts and then forward that to DBA. (DBA will execute those scripts in database).

Compare database and data model. Make sure everything is okay.

Create a change log document for differences between the current version and previous version of the data model.

Maintenance of Data Models:

Maintain Logical & Physical Data Model.

For each release (version of the data model), try to compare the present version with the previous version of the data model. Similarly, try to compare the data model with the database to find out the differences.