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.