Data definition involves describing the properties of the data that go into each database table, specifically the fields or columns that make up the database.
Database. a collection of related information organized for rapid search and retrieval.
Record. a collection of fields that appear as a row in a database or table.
The term DATABASE describes a collection of data organized in a manner that allows access, retrieval, and use of that data.
What is a field record table and query?
Field: A field refers to an area within a record which is reserved for a specific piece of data. Eg. Employee ID.
Table: Table is the collection of records of specific types. E.g. Employee table is a collection of record related to all the employees.
Queries can perform many different functions in a database. Their most common function is to retrieve specific data from the tables.