Scenario 1 Case Study : Online Bookshop System – www.lonelyplanet.com
A major book retailer is planning to develop a computer system to handle their new online bookshop: lonelyplanet.com. You have been chosen to do the analysis and design using Object-Oriented approach. The following requirements have been identified:
A) Customers can search for books on the lonelyplanet.com website, either by author name, or words in the title. A list of all matching books is returned to customers. A customer does not need to be logged-in in order to search.
B) The system records all the customers of the lonelyplanet.com who have ever logged in. A customer may be an individual customer or a business customer.
C) Each customer has a username and password. Business customers may have several usernames and passwords, corresponding to different divisions within the business.
D) When a customer has selected a book to buy at the lonelyplanet.com website. The system prompts for the customer’s username and password. The customer enters these details. The system verifies the customer’s identity and retrieves the customer’s name and address, then prompts for credit card details. The customer enters these details. The system checks the credit card details. The system shows the customer the book and delivery price. The customer confirms the transaction.
E) The system records all books available at lonelyplanet.com. For each book, the author, title and ISBN number are recorded. The number of each book in stock is also stored, along with the number on order by customers. Books may be temporarily unavailable.
F) All books are stored in the lonelyplanet.com warehouse. The warehouse can be contacted via a secure Internet connection.
G) For each customer, a permanent record of books bought by that customer is maintained. Likewise, for each book, a record of customers who have bought that book is kept.
H) A customer order consists of one or more order lines, each corresponding to a particular book. A customer may choose to defer the shipment of an order until all the order lines have been filled.
I) When the warehouse fills all or part of customer order, an email is sent to the customer informing them of what has been shipped.
J) If a book ordered by a customer turns out to be unavailable, the corresponding order line is flagged and an email is sent to the customer informing them of the problem. At this stage the customer can cancel this order line.
K) Although lonelyplanet.com will initially sell only books, it is envisaged that in future it will offer further products, such as CDs and DVDs. The list of possible future products has not yet been finalized.
Outcome:
1. Design and implement IT strategies in an organization.
2. Implement different business systems.
Introduction:
Organizations are finding benefits from using information systems to coordinate activities and decisions spanning multiple functional area, entire firms and even entire industries. Business processes refer to the manner in which work is organized, coordinated and focused to produce a valuable product or service. Hence, it is important to identify the business processes to find IT intervention.
Choose any suitable business organization and research the selected organization by studying various factors. You may obtain data from the organisation’s website or people of the organisation or even from various sources in the library, etc.. Besides, you will be given research articles, hand-outs and case studies to study and analyse. Based on the research and information gathered, execute following tasks making suitable additional assumptions:
Task 1:
The evaluation will be done on the strength and the quality of analysis presented in the proposal. You need to submit a work proposal for this assignment in the form of a completed Word document, which must include:
a) What you will do with the given tasks and the dates by which they have to be completed
b) General overview of initial understanding of solutions to all the tasks
c) Identification of Literature Resources
Task 2:
Identify and analyse in detail on any three roles of IT in the selected organisation (Maximum of three pages).
Task 3:
Perform SWOT analysis for the chosen organization. Provide detailed analysis and justification for your analysis based on your research on chosen organization. (Maximum of two pages).
Task 4:
Create a database to store organisation related data. Derive and create minimum five tables to store data based on your research on chosen organisation. Make appropriate choices for the table attributes. List and implement minimum five integrity rules/constraints that you would recommend to ensure the quality of the data (Indicate the primary key, foreign key and constraints/business rules. Critically analyze the business rules based on your research on the topic.