Database Terminologies - JSS3 Computer Studies Lesson Note

1. Table: A table is a fundamental component of a relational database, representing a collection of related data organized in rows and columns.

2. Record: A record is a complete set of data in a table, corresponding to a single entity or item.

3. Field: A field is a single data element within a record, representing a specific attribute or characteristic.

4. Primary Key: A primary key is a unique identifier for each record in a table, ensuring data integrity and facilitating efficient data retrieval.

5. Foreign Key: A foreign key is a field in a table that links to the primary key of another table, establishing relationships between tables.