click below
click below
Normal Size Small Size show me how
Ciw lesson 6
Lesson 6
Question | Answer |
---|---|
Table | a collection of data about a specific topic, organized into columns and rows |
Field | a category of information in a table (a column) |
Record | a collection of information consisting of one or more related fields about a specific entity (a row) |
Common field | a field, contained in two or more tables, that forms a relationship between the tables |
Relationship | a connection between two or more tables based on a common field |
Primary key | a field containing a value that uniquely identifies each record in a table |
Foreign key | a field in a related table that refers to the primary key in another table |