Question:

1. Find out all Critical Use Cases

2. Draw Context Level diagram.

3. Draw Level 0 data flow diagram depicting all the business process description provided.

4. Draw ERD showing all required entities and its relationships.

5. Draw CRUD diagram.

6. Identify and provide all the required data elements you will need for your data entities for the case study provided.

7. Provide a prototype of website design and architecture you have developed based on the case study.

Carrie Douglass Manager of the Broadway Book Shop owns a book selling shop. He began selling book as a hobby. Initially, Carrie Douglass would sell the books from his garage to friends and family. As word spread about his bookshop, he began taking orders from the customers such as University, big organizations etc. for different genre of books. He stared keeping 10 genres of books:

• Science fiction
• Satire
• Drama
• Action and Adventure
• Romance
• Mystery
• Horror
• Self help
• Guide
• Travel

This book selling hobby has since evolved into a medium-sized business, employing more than fifty workers.  Broadway Book Shop specializes in keeping above said 10 genres of books.

Broadway Book Shops main business is to acquire books from different publishers and sell and ship books to customers which include work done by Books sales representatives, managers, and ordering books from the publishers.  Each book selling transaction requires a lot of standard communication to be sent to buyers, publishers and most importantly - managing deadlines. You can consider publishers are the suppliers here.

Broadway Book Shop business processes are manual, including the creation of customer's contacts, accepting payments and issuing receipts, as well as generating letters to publishers and ordering books from different publishers. Customer's, publisher's details are maintained using a spread sheet, and appointments to meet the sales representative to ask about some book were maintained in Microsoft Outlook.

All customer and publisher's files at this initial stage are paper based and staff often spends hours searching for a particular file. Once the customers or publisher's file is found, additional time is spent looking for documents within the particular file for sale and purchase of the books. Sometimes files would go missing and then reappear after a few days. In addition to this, the Income Tax Office requires that the file from closed sales had to be kept on the Broadway Book Shop records for 5 years. Assume discount rate to be 10%. Total development cost is $45000.00

Details that are currently manually recorded on file are:-

- Customer name, address, contacts details (phone, mobile, email)

- List of Genres of books

- List of books with each Genre

- List of requested book by the customer

- Price List of the book.

- Publishers list who supplies the book to Broadway Book Shop.

- List of book sales representatives

Accounting

All invoices are created manually using pen and paper and outstanding payments are tracked by setting reminders in Microsoft Outlook Problems with the Current System

- Only one staff member can access important information at a time which causes bottlenecks especially if staff are away

- There is some duplication with paper and electronic records

- Records are held in computer applications plus in paper form

- The system does not provide an effective means for keeping deadline details

Due  to  these  problems,  some  transactions  have  not  been  handled  well  and customer complaints are increasing.

The desired new system

Carrie Douglass Manager of the Broadway Book Shop has identified that his major priority is to create a system that ties together all the key elements of Furniture transactions. He has hired your company, Australia Wide System Integration Group (AWSIG) as consultants to carry out analysis and develop the specifications for an automated Book information system.

You are to develop the report having each task clearly numbered together with your answer.

You are also expected to write an introduction and conclusion for this report. In performing the following tasks, you have to strictly follow all diagramming rules used in the text for this course.

In each task, please feel free to make any assumption necessary for the reader. The explanation of your assumptions can help the reader understand your reasoning and is as important criteria in producing your Website Design and model.

Task 1 Data Flow Diagram -  Draw one data flow diagram depicting the logical equivalent for the business process description provided

You are assigned the role to develop a new system based on the project case study. Draw a context diagram and a level-0 DFD for it. The Case study given makes reference to suppliers, Sales and Distribution which are the components of a Supply Chain Management System.

Students are required to represent minimum of the followings:

1. Purchasing from suppliers based on inventory levels

2. customer sales orders driving scheduling

3. Checking inventory levels

4. Sales customer orders processing

5. Distribution and delivery schedules, returns, and back orders.

6. Generating report at different levels for managers.

Task 2 Level the diagrams to its functional primitives:

Level the diagram by using the Level-0 DFD that you provided in Task 1. You are to draw level 1 DFD.

Task 3 To the best of your ability provide the data elements you will need for your data entities for the case study provided.:

Task 3 Draw CRUD diagram:

Identify all the data elements and data entities and Develop an ERD and transform Entity-Relation (ER) Diagram into an equivalent set of well-structured relations for the system based on the project case study

Task 4 Provide website design and architecture you will be using.

Students need to work on the case study provided to develop the website design. No Implementation is required ONLY DESIGN. Students can use any tool Such as HTML, Visio, Power point, or Dream weaver to demonstrate the design of Broadway Book Shop. Students can use take some photographs of books to display on the website they are designing.

Task 5 Presentation based on the case study:

Students need to present the website design in the designated tutorial/ class time. Students need to specify the advantages and disadvantages of tools they have used to develop the website design. The website design is a prototype. Students are not required to implement the design. No Database connectivity is required. Students can choose some default value for the label and text field they are using in the design. Students should click the photographs of the book they would like to display on the website. Students may use Book photographs/ images from the web but they are required to reference it properly.