Q2. Data Models

• _______________ is the process of creating a simplified visual diagram of a software system and the data elements it contains, using text and symbols to represent the data and how it flows.

________________ In this phase, data relationships were identified.

______________ In this phase, provides the data architecture framework that will guide the physical model.

____________ In this phase, it allows database administrators to move forward with planning.

________________ data models organize data in a treelike arrangement of parent and child records.

________________ model maps the relationships between data elements stored in different tables that contain sets of rows and columns, making it easy to identify data relationships and create entity relationship (ER) diagrams.

• ________________ A variation of the relational model that can also be used with other types of databases, ER models visually map entities, their attributes and the relationships between different entities.

_______________ are primarily used in data warehouses and data marts that support BI applications. They were designed to improve data retrieval speeds for analytics.

_______________this approach is similar to the ER method in how it represents data, attributes and relationships, but it abstracts entities into objects.

__________ data model is a more modern offshoot of network and hierarchical models.