Chapter 2, Problem 1RQ

Program Plan Intro

Data Model:

• Data Model refers to the logical inter relationship and the data flow involved between different data elements.
• It defines how data is processed, connected and stored inside the system.
• A data model can be either concrete or abstract.
• It consists of components such as data types, data items, data sources, event sources, and links.
• The three styles of data model are conceptual data model, physical data model, and logical data model.

Explanation of Solution

Importance of Data Models:

• The main function of a data model is that they help to understand complexity of real world environment.
• The data model is used by the database designer to enhance the interaction among designers, application programmers, and end users.
• Data models will help to represent the required data and the format that is used for different businesses processes.
• They help to prevent data redundancy.
• The database design tools have made the development of data models to possibly diminish the database design error potential.
• It also helps to eliminate the discrepancies between the database designs components and the real world data environment.