Relationships in Data


  • A relational database is relational because relationships are formed between keys in the tables during the normalization process
    • this design defines a unique identifier to be assigned to a record of data in the table, which distinguishes that record from every other record in that table
    • A key used to identify a record is referred to as a primary key
    • When a primary key is used in another table to refer to your record, it is known as a foreign key

Primary key is a unique identifier for a record that cannot contain duplicates and is used to reference a record.

Foreign key is a field or fields that are primary in another table.