Skip to main content
Business LibreTexts

13.2: Introduction to Table Relationships

  • Page ID
    46632
  • \( \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}}\)

    What you’ll learn to do: Discuss table relationships

    To understand table relationships it is important to have an understanding of some basic database principles. We will explore the underlying properties of relational databases, how they are organized, and how they add value to commercial enterprises. Then we will discuss the important concept of normalized data versus flat file data organization, which is crucial to understand what makes a relational database work. Finally we will learn about the three types of relationships between tables in relational databases like Access.

    Contributors and Attributions

    CC licensed content, Original
    • Introduction to Table Relationships. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution

    13.2: Introduction to Table Relationships is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.

    • Was this article helpful?