Accounting Information Systems 8th Edition by James Hall

تمرين 78

NORMALIZATION OF DATA
A college bookstore maintains all of its records on index cards. This has proven to be a very tedious chore, and the manager has asked you to design a database that will simplify this task. The index cards are preprinted and contain the following labels:
Title:
Author(s):
Edition:
Publisher:
Publisher Address:
Publisher Phone #:
Cost of Text:
Selling Price:
Number on Hand:
Professor: Class:
Semester:
Year:
Professor Phone #:
Using your understanding of the business rules that exist in most colleges and for most college bookstores, prepare the base tables (in third normal form) that will be required to translate the index card information into a working database for the bookstore.