Data Modeling

Business or System analyst is good to have minimum programming knowledge

or some tech key elements such as database concepts, SQL or Code Analysis, which helps to communicate with Dev folks during Analysis/Design/Development phase.

 What is Databases and Data Structures: Database is the collection of data in a  well arranged manner, like table & Data Structure is the way of arranging information in a database so that it becomes easy to access information whenever needed, like how it is stored.

Data Modeling: Data modeling helps to define and analyze data requirements, it is often first step in database design & how data items relate to each other. There are three levels of Data modeling as follows: Conceptual model, Logical Models and Physical Models respectively:

To make it simple, I got these Modeling diagrams from Google images, & examples are based on these following Models! have fun 

Conceptual Modeling Logical Modeling Physical Modeling
conceptual-data-modelConceptual Data Models: helps to identify High-level, static business structures and conceptsEx: Time, Product, Sales and Stores and how do they relate other.

 

logical-data-model 

Logical Data Models (LDMs): required to identify and define Entity typesdata attributes and relationships between entities

Ex: Time (Time, Day, Month), Product (Product ID – Description, Price, Location), Sales (Items Sold, Sales Amount) and Stores (Stores location, Store Description)

physical-data-modelPhysical Data Models (PDMs): required to design internal schema database designEx: Time (Integer or VARCHAR), Product (Integer or VARCHAR), Sales (Integer or VARCHAR) and Stores (Integer or VARCHAR)

Though we are not responsible to creating the database tables, however we might be responsible for designing these models…as you see these models increases the complexity in a respective way, so always recommended to first start with the conceptual data model to understand high level different entities in our data and how they relate to one another, then move on to the logical data model so we understand the details of our data without worrying about how they will actually implemented, and finally the physical data model so we know exactly how to implement our data model in the database.

Tools to design Data Modeling: Out of many, very commonly used tools Toad Data Modeler, ERwin Data Modeler

- See more at: http://myprojectanalysis.com/data-modeling/#sthash.38oxKcrC.dpuf

Share this article

Contact info

About us

Newsletter

Join the network: We are Business Folks, analyzing IT projects.
Top
We use cookies to improve our website. By continuing to use this website, you are giving consent to cookies being used. More details…