Chapter 11, Problem 2SG

Explanation of Solution

Field:

In relational database, group of related row is called record, which is also called database object or entity. A data in a row or column of a table is called fields.

• In other words, the group of related column is called field.

Field name:

• A field name is one that uniquely identifies each field.
• For searching the data in the database, the field name must be specified...

Explanation of Solution

Common data types:

Some of the commonly used data types are:

• CHAR(n)
• VARCHAR(n)
• DATE
• DECIMAL(p,q)
• INT
• SMALLINT

“CHAR” data type:

A “CHAR” data type is a data type that represents the characters in the character set. It is used to specify the letters, special characters and columns containing numbers.

“VARCHAR” data type:

The “VARCHAR” data type is used to store a character string which extends up to “n” character. Here, “n” specifies the maximum number of character that the particular column tends to hold.

“DATE” data type:

This data type is used to store date and sometimes, time values. Usually DBMS stores the value of date in the numeric format according to the Julian calendar...