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.
Accounting Information Systems
10th Edition
ISBN:9781337619202
Author:Hall, James A.
Publisher:Hall, James A.
Chapter13: Systems Development And Program Change Activities
Section: Chapter Questions
Problem 1P: ANNOUNCING A NEW INFORMATION SYSTEM The AJAX Company is considering implementing a new accounting...
Related questions
Question
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.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 4 images
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Recommended textbooks for you
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Auditing: A Risk Based-Approach to Conducting a Q…
Accounting
ISBN:
9781305080577
Author:
Karla M Johnstone, Audrey A. Gramling, Larry E. Rittenberg
Publisher:
South-Western College Pub
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:
9781133935940
Author:
Ulric J. Gelinas
Publisher:
CENGAGE L
College Accounting, Chapters 1-27
Accounting
ISBN:
9781337794756
Author:
HEINTZ, James A.
Publisher:
Cengage Learning,