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 |