Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Sport Goods Direct (SGD) is a directly selling catalogue based retailer of sporting equipment. Customers select the items and complete an order form, which is

Sport Goods Direct (SGD) is a directly selling catalogue based retailer of sporting equipment. Customers select the items and complete an order form, which is processed by SGD. Recently SGD has seen a considerable growth in the business with a lot more sales than in the first quarter of the year 2017. Demand for their stock has grown, therefore they need a well-designed relational database for stock maintenance and customer record purposes. Sporting Goods Direct wants to build an e-commerce web application to sell items online. SGD sells many Items under many Categories. Initial analysis reveals that System Actors in SGD Online System include: Online Customer Company Staff Initial analysis also reveals the following use case scenarios Customer scenarios: Search items/products and place orders A customer visits the SGD web site; he/she can then search for an item based on several criteria (e.g. category, price etc.). If suitable result(s) found, the customer could select an item and be provided with details of the item including category, price, availability, descriptions, photos etc. If the item is available for order, the total cost of the item is supplied to the customer, and the customer confirms the order for which an order reference number is provided. However, if there are insufficient items available for the order the customer is asked to make another search. Staff scenarios: Add items SGD staff adds details of a new items. Items details include name, description, price, quantity, item id etc. Remove items SGD staff can remove an item i.e. make it unavailable for order. Description of problem to be solved

Capture all business requirements using UML and ER diagrams.

Deliverables Your front-end implementation should follow standards specified by World Wide Web Consortium (W3C) and design diagrams (Use case, ER and storyboard diagrams).

Please can I have an ER diagram, s Use case diagram and storyboard for the above scenario.

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

Database Processing Fundamentals Design

Authors: Marion Donnie Dutton Don F. Seaman

14th Edition Globel Edition

1292107634, 978-1292107639

More Books

Students also viewed these Databases questions

Question

What is Ramayana, who is its creator, why was Ramayana written?

Answered: 1 week ago

Question

To solve by the graphical methods 2x +3y = 9 9x - 8y = 10

Answered: 1 week ago

Question

1. Diagnose and solve a transfer of training problem.

Answered: 1 week ago