One of the Employees at Regional Books Is Attempting to Use

question 180

Short Answer

One of the employees at Regional Books is attempting to use the normalization process in the design of the database. She has created the following unnormalized table: Book ( ISBN , Title, Publishersade, PublisherName, (AuthorNum, AuthorLast, AuthorFirst)) How can she sanvert this unnormalized table to a table in first normal form?

---

Definitions:

Preferred Stock

A type of stock that gives holders preferential treatment over common stockholders regarding dividends and claims on assets in case of liquidation.

Common Stock

Shares of ownership in a corporation, giving holders voting rights and a share in the company's profits via dividends.

Cumulative Preferred

Cumulative preferred stock is a type of preferred stock that has a provision entitling shareholders to accumulate unpaid dividends to be paid out before any dividends can be issued to other stock classes.

Par Common Stock

The face value of common stock as designated in the company's charter, not necessarily its market value.