Very small example bookstore database

Best-Book-Buy Online ([url removed, login to view]) Bookstore Project

Requirements Specification Document

1. Introduction

The purpose of this case study is to present a data-intensive application for which a database can be designed. It is described with sufficient degree of detail so that the application can be implemented in languages like Java or Visual Basic using ODBC connectivity to the relational database. This case study is an illustration of the typical project we have been using to teach an undergraduate class in database design.

The user interface is defined in screen format – these screens can be implemented using Visual Basic or Java as needed, or a simpler version of the interface using simple text menus may be implemented. There are a few reports included in the application specification. They are for illustrative purposes and may be modified as well. The methodology to be followed uses conceptual design in the Entity Relationship Model (Chapter 3), followed by a mapping of the ER schema into the relational schema (Chapter 7). The application is broken into a number of tasks and the inputs and outputs are related to the tasks by means of an Information Flow Diagram. Students should use Chapter 12 to understand the overall process of database design used for design of large databases. SQL programming (Chapter 8) and database access from application programs (Chapter 9) is illustrated with examples for implementing the tasks.

3-B is an information management system that supports some of the services involved in an online bookstore, such as The information system that we describe here is a simplified version of a full-fledged online bookstore system. The reader may consider this document as an initial specification provided by the end-users and requirement analysts on what the application should look like. In other words, this document can be considered as the initial requirement specification document.

When the customer accesses [url removed, login to view], the first page that she1 sees is depicted below.

Figure 1: Welcome screen.

1 We will use she to refer to the customer with no intended bias.


The rest of this document is organized as follows. We describe the operations and screens that a user will go through when one of the above options are selected. Then, we discuss some general aspects relevant to the system as a whole.

2. Search Only

Let’s say that the user only wants to search the bookstore for a specific book. She clicks “Search Only” and the screen in Figure 2 pops up. Internally, the system will create a temporary shopping cart for this new user. Briefly, a shopping cart is just a temporary structure in main memory that will hold the books that the user may decide to purchase while browsing The shopping cart is an important component of the system, and we defer more detailed discussion on this component to later in this document after presenting the main functionalities of the system.

Figure 2: Search screen.

The user enters some keywords in the “Search For” field, determines where these keywords should be examined (e.g., on the title of a book), and within which category. By default, the system assumes that the user wants to search using “Keyword anywhere” over all categories. The search is executed by clicking the “Search” button. When the system finishes executing the search, the screen depicted in Figure 3 pops up. The option “Manage Shopping Cart” is addressed next.

Initially, the “Search” button is deactivated, and it will only be activated when the user enters some keywords in the “Search For” field. The search is conducted by checking whether the keywords provided appear at the beginning of the field(s) indicated in “Search In.” For this system, we do consider the case where the keywords can appear in any position in the field. Otherwise, an index at the word level would be required, and the cost of maintaining such index as well as navigating it could become prohibitive, degrading significantly the performance o

Skills: eCommerce, HTML, Shopping Carts, Website Design

See more: bookstore database example, shopping cart database design example, example bookstore database, bookstore database design, database structure bookstore example, small bookstore databases, bookstore database, database design online bookstore, bookstore information system examples, example requirements specification bookstore, example database bookstore, example system process bookstore, database design example online bookstore, bookstore database system example, example database access bookstore, small database design examples, small bookstore database, example database structure bookstore, example database design online bookstore, simple database books small bookstore, bookstore database design example, requirement bookstore database design, database bookstore illustrated example, design small bookstore, word page design buy

About the Employer:
( 0 reviews ) Delhi, India

Project ID: #2559533

8 freelancers are bidding on average $407 for this job


Hi, We have throughly read your requirements and believe that we can deliver exceptional results. We hope you will consider using our services. Best Regards,

$160 USD in 8 days
(437 Reviews)

We are a team of dedicated, serious and highly experienced developers & designers, 24x7 available. After reviewing your project requirement we are highly interested in your project. Please check your Private Message fo More

$350 USD in 7 days
(53 Reviews)

hi abhishekj1202, we have read your requirements and interested in job ..... please check PMB for our work and expertise ..... regards, sajjj

$399 USD in 18 days
(40 Reviews)

I am ready and expert in PHP and MYSQL

$250 USD in 7 days
(27 Reviews)

We are a team of developers and designers who are in this field from more than 6 [url removed, login to view] check your PMB for details. If you will give us the project then we will do that better quality of work within the time peri More

$450 USD in 17 days
(15 Reviews)

More than 8 year Experienced creative designers and Professional Developer's team is here to finish your project up to your satisfaction. Our ability is to develop quality products on-time and on-budget without sacrifi More

$199 USD in 10 days
(23 Reviews)

I am ready to start. Please check PM for details.

$138 USD in 8 days
(30 Reviews)

Hi, This is jeni from Bistechsupport. Thanks for placing my bid on this lovable project. Yes, we could able to do this Project. We have done more than 500 sites. A very few samples are dropped down for More

$145 USD in 7 days
(22 Reviews)

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$1500 USD in 1 day
(0 Reviews)

Custom software development: w w w . The Administrator removed this message for containing contact details which breaches our Terms of Service . i o

$250 USD in 1 day
(0 Reviews)