Relational Database Glossary

Table 23-5 is a glossary of terms that you can review and refer to as necessary. There are a few terms in here that appear later in the chapter.

Table 23-5. Relational database glossary

Name

Description

attribute

A column in a table, e.g., the “Name” attribute.

cardinality

The number of rows in a relation.

database integrity

You maintain database integrity by grouping statements in a “transaction” that is either executed as a whole, or has no part of it executed.

degree

The number of columns in a table.

domain

The set of permissible values for an attribute.

entity integrity

The requirement that key attributes never contain a null.

first normal form

A table in which no attributes ...

Get Just Java™ 2 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.