Skip to main content
Engineering LibreTexts

1.4: Chapter 4 Types of Data Models

  • Page ID
    6877
  • \( \newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} } \) \( \newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}} \)\(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\) \(\newcommand{\id}{\mathrm{id}}\) \( \newcommand{\Span}{\mathrm{span}}\) \( \newcommand{\kernel}{\mathrm{null}\,}\) \( \newcommand{\range}{\mathrm{range}\,}\) \( \newcommand{\RealPart}{\mathrm{Re}}\) \( \newcommand{\ImaginaryPart}{\mathrm{Im}}\) \( \newcommand{\Argument}{\mathrm{Arg}}\) \( \newcommand{\norm}[1]{\| #1 \|}\) \( \newcommand{\inner}[2]{\langle #1, #2 \rangle}\) \( \newcommand{\Span}{\mathrm{span}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)

    Authors: Adrienne Watt & Nelson Eng

    High-level Conceptual Data Models

    High-level conceptual data models provide concepts for presenting data in ways that are close to the way people perceive data. A typical example is the entity relationship model, which uses main concepts like entities, attributes and relationships. An entity represents a real-world object such as an employee or a project. The entity has attributes that represent properties such as an employee’s name, address and birthdate. A relationship represents an association among entities; for example, an employee works on many projects. A relationship exists between the employee and each project.

    Record-based Logical Data Models

    Record-based logical data models provide concepts users can understand but are not too far from the way data is stored in the computer. Three well-known data models of this type are relational data models, network data models and hierarchical data models.

    • The relational model represents data asrelations, or tables. For example, in the membership system at Science World, each membership has many members (see Figure 2.2 in Chapter 2). The membership identifier, expiry date and address information are fields in the membership. The members are individuals such as Mickey, Minnie, Mighty, Door, Tom, King, Man and Moose. Each record is said to be an instance of the membership table.
    • The network model represents data as record types. This model also represents a limited type of one to many relationship called a set type, as shown in Figure 4.1.
    Diagram displaying 8 rectangular boxes and arrows crossing between them. The boxes contain labels such as EMPS and SUPPLIERS. Labels are also outside of these rectangles.

    Figure 4.1. Network model diagram.

    • The hierarchical model represents data as a hierarchical tree structure. Each branch of the hierarchy represents a number of related records. Figure 4.2 shows this schema in hierarchical model notation.
    Diagram with labels in capitals connected by lines.

    Figure 4.2. Hierarchical model diagram.

    Key Terms

    hierarchical model: represents data as a hierarchical tree structure

    instance: a record within a table

    network model: represents data as record types

    relation: another term for table

    relational model: represents data as relations or tables

    set type: a limited type of one to many relationship

    Exercises

    1. What is a data model?
    2. What is a high-level conceptual data model?
    3. What is an entity? An attribute? A relationship?
    4. List and briefly describe the common record-based logical data models.

    Attribution

    This chapter of Database Design is a derivative copy of Database System Concepts by Nguyen Kim Anh licensed under Creative Commons Attribution License 3.0 license

    The following material was written by Adrienne Watt:

    1. Key Terms
    2. Exercises

    This page titled 1.4: Chapter 4 Types of Data Models is shared under a CC BY license and was authored, remixed, and/or curated by Adrienne Watt (BCCampus) .

    • Was this article helpful?