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 Models: helps to identify High-level, static business structures and conceptsEx: Time, Product, Sales and Stores and how do they relate other.
Logical Data Models (LDMs): required to identify and define Entity types, data 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 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