Intro to data 2

• Relational Database - A relational database uses relations or two-dimensional tables to store information.
• Object Relational Database - is a database management system similar to a relational database, but with an object-oriented database model
• Data modeling is the process of creating a simplified diagram of a software system and the data elements it contains, using text and symbols to represent the data and how it flows.
• Conceptual Model - It is the typical starting point of data modeling, identifying the various data sets and data flow through the organization.
• Logical Model - It describes the data flow and database content. It adds detail to the overall structure in the conceptual model.
• Components of the Logical Model

  Entities: Represents a set of things, persons, or concepts relevant to business.
• Components of the Logical Model

  Relationships: represents an association between two of the above entities.
• Components of the Logical Model

  Attributes: is a descriptive piece characteristic or any other information that is useful to further describe an entity.
• Physical Model - It describes the specifics of how the logical model will be realized. It is specific to a designated database software system.
• Data Modeling Techniques

  Entity-Relationship Data Modeling: It visually map entities, their attributes and the relationships between different entities.
• Data Modeling Techniques

  Dimensional Modeling: They consist of fact tables that contain data about transactions or other events and dimension tables that list attributes of the entities in the fact tables.
• Data Modeling Techniques

  Graph Modeling: Typically paired with graph databases, it's often used to describe data sets that contain complex relationships.