Chapter 5, Problem 5.2RQ

Explanation of Solution

Attribute:

In database management system, an attribute refers to a database field. It also refers to a database component.

• Generally columns in the table are called as an attributes.

Steps for transforming attributes into columns:

• Initially create a table for each entity.
• Each attributes in an entity must have a column in the corresponding table.
• Specify one column as the primary key for that table.

Column properties:

While transforming attributes into columns, it should specify some column properties. They are:

• Null status
• Data type
• Specify data constraints
• Default value

Example:

Consider the example of transforming attributes into columns is as follows:

Attribute: