Ubuntu Unleashed 2019 Edition: Covering 18.04, 18.10, 19.04

(singke) #1

FIGURE 28.1 In this visualization of how an RDBMS stores data, the
database stores four records (rows) that include name and address
information, divided into seven fields (columns) of data.


FIGURE 28.2 A single database can contain two tables—in this case,
phonebook and cd_collection.


In the sample_database example, the phonebook table contains four
records (rows) and each record hold three fields (columns) of data. The
cd_collection table holds eight records, divided into five fields of data.


If you are thinking that there is no logical relationship between the
phonebook table and the cd_collection table in the
sample_database example, you are correct. In a relational database,
users can store multiple tables of data in a single database, even if the data in
one table is unrelated to the data in others.

Free download pdf