Question

Design a survey form of your own. Fill it out as it might have been completed during the database design for Henry Books. For any questions you have too little information to answer, make a reasonable guess.

Answer 1

(Ray Henry, the owner of a bookstore chain named Henry Books, gathers and organizes information about branches, publishers, authors, and books. Each local branch of the bookstore has a number that uniquely identifies the branch. In addition, Ray tracks the branch’s name, location, and number of employees. Each publisher has a code that uniquely identifies the publisher. In addition, Ray tracks the publisher’s name and city. The only user of the Book database is Ray, but you do not want to treat the entire project as a single user view. Ray has provided you with all the reports the system must produce, and you will treat each report as a user view. Ray has given you the following requirements:

User View 1 Requirements: For each publisher, list the publisher code, publisher name, and city in which the publisher is located.

User View 2 Requirements: For each branch, list the number, name, and location.

User View 3 Requirements: For each book, list its code, title, publisher code, publisher name, and whether it is a paperback.

User View 4 Requirements: For each book, list its code, title, and type. In addition, list the name(s) of the author(s). If a book has more than one author, all names must appear in the order in which they are listed on the book’s cover. The author order is not always alphabetical.

User View 5 Requirements: For each branch, list its number and name. In addition, for each copy of a book in the branch, list the code and title of the book, the condition of the book, and the price. A branch may have multiple copies of the same book, each with a different quality (condition) and price. The copies of the same book in a branch are assigned numbers to distinguish one copy from another.

User View 6 Requirements: For each book, list its code and title. In addition, for each branch that currently has a copy of the book in stock, list the copy number, quality, and price of the book.)