# 13.2: Introduction to Table Relationships

$$\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.