Chat with AI
Accounting Information Systems 8th Edition by James Hall
Edition 8ISBN: 978-1111972141Accounting Information Systems 8th Edition by James Hall
Edition 8ISBN: 978-1111972141 Exercise 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.
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.
Explanation
Verified
Verified
College Book Store Database Ta...
Accounting Information Systems 8th Edition by James Hall
Why don’t you like this exercise?
Other Minimum 8 character and maximum 255 character
Character 255
