Question

3. Define the terms : record, field, table and query. ​

Answer 1

Answer:

$\huge\red{A}\pink{N}\orange{S}\green{W}\blue{E}{R}$

A record is a data structure that groups together related items of data. These are slightly more complex than arrays as you can store more than one type of data together. For example, with a game, it could be useful to set up a data structure which collects a player's login and their score in one structure.

A field is one or more bytes in size. A collection of fields makes up a data record; for example, ORDER #, NAME, ADDRESS, CITY, etc. The terms field and "box" are often used synonymously such as a "search field" or "search box" on a Web page. The field is the common denominator for database searches.

A table is a collection of related data held in a table format within a database. It consists of columns and rows. ... Views also function as relational tables, but their data are calculated at query time. External tables (in Informix or Oracle, for example) can also be thought of as views.

Query, a precise request for information retrieval with database and information systems. Query language, a computer language used to make queries into databases and information systems. Query string, in the World Wide Web, is an optional part of a URL. Web search query, a query entered by users into web search engines.