Database Intro_Yr11

2. A single entry in a table. Each record contains values for all fields. Example: A student’s full details in the “Students” table.
4. An organized collection of data that can be easily accessed, managed, and updated.
6. A single category of data stored in a table. Example: Name, Age, or Student_ID.
9. A field in one table that links to the primary key in another table, creating a relationship.
11. A type of database that stores data in tables (rows and columns) and links them using relationships.
13. The connection between two or more tables in a database (e.g., students and courses).
16. Ensuring accuracy, consistency, and reliability of data in a database.
17. Rules applied to data in a database to ensure accuracy (e.g., NOT NULL, UNIQUE).

1. A diagram used to show entities, their attributes, and relationships between them.
3. An object or concept about which data is stored (e.g., Student, Teacher, Course).
5. A structure in a database that holds data in rows and columns (like a spreadsheet).
7. Unnecessary duplication of data in a database (something normalization helps avoid).
8. The process of organizing data in tables to reduce duplication and improve efficiency.
10. A language used to communicate with and manage relational databases.
12. A request for specific data from a database, often written in SQL.
14. A unique field (or combination of fields) that identifies each record in a table. Example: Student_ID in a “Students” table.
15. A property or characteristic of an entity. Example: For entity “Student,” attributes could be Name, Age, Grade.