Question

what is the difference between a database, table, record and field. draw a diagram to show this relationship.



plz answer ​

Answer 1

Answer:

A table has records (rows) and fields (columns).Fields have different typesof data, such as text, numbers, dates, and hyperlinks. A record: Contains specific data, like information about a particular employee or a product.

Answer 2

Answer:

Database is a structured set of data held in a computer, especially one that is accessible in various ways.

 Table is an arrangement of data in rows and columns, or possibly in a more complex structure. Tables are widely used in communication, research, and data analysis. Tables appear in print media, handwritten notes, computer software, architectural ornamentation, traffic signs, and many other places.

Record is the information created, received, and maintained as evidence and information by an organization or person, in pursuance of legal obligations or in the transaction of business.

Fields are the components that provide structure for a table. Fields in a table store the same category of data in the same data type.