COMPSCI 1BA3 Lecture Notes - Foreign Key, Unique Key, Meridian Regional Airport

• School: McMaster University
• Department: Computer Science
• Course: COMPSCI 1BA3
• Professor: Anthony Hurst

Document Summary

Organizing data: first step identify individual fields. Field: a single characteristic/ attribute of a person, place, object, event, or idea: group related fields together into tables. Table: a collection of fields that describes a person, place, object, event or idea. Field value: the specific value or content of a field. Database or relational databases: a collection of related tables. Common field: you connect the records in the spate tables through a common field that appears in both tables. Primary key: is a field or a collection of fields, whose values uniquely identify each record in a table. *no two records can contain the same value for the primary key field. When you include the primary key from one table as a field in a second table to form a relationship between the two tables, it is called a foreign key in the second table.