9.1 Databases

Fields, Records, and Keys

• Field: A single piece of data (Column).
• Record: A complete set of data for one item (Row).
• Primary Key: A unique identifier for a record (e.g., StudentID).

Querying Data

To extract data from a table, we use the following SQL structure:

SELECT Field1, Field2
FROM TableName
WHERE Condition
ORDER BY Field1 ASC;