RelationalDBDesign RelationalDBDesign

Normal Forms   «Prev 

Achieving First Normal Form

Relational databases use the terms index and key to indicate similar concepts. An index is like an index in a book, used to find specific topics, on specific pages, in a book, very quickly (without having to read the entire book). Similarly, an index in a relational database is a copy of a part of a table, perhaps structured in a specific format such as a BTree index. An index can be created on any field in a table. A key, on the other hand, is more of a concept than a physical thing because a key is also an index. In a relational database, a key is a term used to describe the fields in tables linking tables together to form relationships (such as a one-to-many relationship between two tables). A key is both a key and an index. A key is an index because it copies fields in a table into a more efficient searching structure. A key is also a key, its namesake, because it creates a special tag for a field, allowing that field to be used as a table relationship field, linking tables together into relations. There are three types of keys:
  1. primary key,
  2. unique key, and
  3. foreign key.

Books Table Relation

Books Table Relation
  1. book: Entity
  2. Items in parentheses: Attributes