Chapter 5, Problem 2ARQ

Explanation of Solution

Database:

Database is a collection of information that is used to store and retrieve the data. Data is organized in tables.

Hierarchy of Data:

The hierarchy of data is specified in tree-like structure. The records are connected through links. The database elements are,

• Table or File
• Records or Rows
• Fields or Columns
• Bytes or Characters

Metadata:

Metadata gives information about other data or simply, it is a data about the data.

• It provides the description about the characteristics or properties of end user data and environment of the data.
• The environment includes the source of the data, where it is stored, usage, and so on.
• It gives all the information about a data.

Relationship among the rows:

• Using the examples of “student” and the “office_visit” tables the relationship can be described as one to one relationship.
• Because the student number in the “student” table and the student number in the “office_visit” table have the unique student number.
• If any modification is made concerning the student number in the “student” table, then it is automatically updated in the “office_visit” table...