Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Queenies Second Hand Bookshop Queenie Quest owns a second hand book shop on the High Street of a busy town. The book shop buys and

Queenies Second Hand Bookshop Queenie Quest owns a second hand book shop on the High Street of a busy town. The book shop buys and sells second hand books, but also has a small private library of rare books which she loans to local people. She has to keep a careful record of each loan and return. Before anyone can borrow any books, they must register with the book shop and pay a deposit. The deposit is repaid when a person wishes to cease membership of the library if all the borrowed books have been returned in good condition. When someone offers a book for sale Queenie searches her catalogue of books to see if she already has a copy either in the library or for sale. If so she checks how much she paid for the copy or copies she already has. If she has several copies of the book already she may decline to buy the book, or offer a reduced price. If Queenie doesnt already have a copy of the book she will offer to buy it, paying a reasonable price depending on its condition and rarity.

Queenie has realized that the supply of second hand books locally has diminished and has decided to set up a web site where people can offer their books to Queenie to buy. She realizes that the seller of a book would have to input the condition of a book as well as the title and publication date. The web application would have to decide what price to offer by retrieving the purchase and selling price of any previous copies of the book. If the potential seller agrees to the price a transaction number would be displayed for the seller to include when sending the book. Queenie will send a cheque to the seller when the book is received. If the application could not calculate a price Queenie would like an e-mail notification so she can value the book herself.

1. (a) Draw a Context Diagram to depict the above Queenie's Second Hand Bookshop. (b) Produce a Level 1 Data Flow Diagram upon completing 1. (a)

I want the answer in Context Diagram and Level 1 Data Flow Diagram

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

T Sql Window Functions For Data Analysis And Beyond

Authors: Itzik Ben Gan

2nd Edition

0135861446, 978-0135861448

More Books

Students also viewed these Databases questions

Question

Which form of proof do you find least persuasive? Why?

Answered: 1 week ago