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. (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.)
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Design a survey form of your own. Fill it out as it might have been completed during the
(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.)
Trending now
This is a popular solution!
Step by step
Solved in 3 steps with 7 images
