Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need ERD for those usecases. Context diagram Sales order confirmation Maintains supplier data, maintains inv. Data, request reports Customer Manager Customer data; sales orders

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed

I need ERD for those usecases.

Context diagram Sales order confirmation Maintains supplier data, maintains inv. Data, request reports Customer Manager Customer data; sales orders Maintain Cust. Data, Sales Order Processing, Maintain supp. Data, Purchase reorder process, maintain inv. Data, display reports Summary reports Use Case Name: Maintain Customer data LID:1 Importance Level: High Primary Actor: Customer Short Description: This describes how the customer data will be created, updated, and deleted. Trigger: New customer wants to purchase from Eagledyne/current customer wishes to update cust. Data type: external Major Inputs: Major Outputs: Description Source Desription Destination customer name customer cust. Id, name, customer account cust. Location customer location, phone database phone number customer email customer account customer account deletion archive database acct delete request customer Major Steps Performed Information for Steps 1 New customer creates customer account name, location, email & phone number 2 Current customer updates customer account 3 System auto assigns a unique customer ID to each new customer 4 Customer deletes account updates all/partial cust. acct info( name, location, emal, phone number) system sequentially assigns next available unique id number customer requests deletion of acct; acct is moved to archive Use Case Name: Sales Order Processing LID:2 Importance Level: high Primary Actor: Customer Short Description: This describes the process by which a customer places a sales order and the storage of sales orders Trigger: Customer wishes to purchase parts type: external Major Inputs: Major Outputs: Description Source Desription Destination part description/keywords customer sales order info (cust, sales order database qty of parts customer part, date, price, etc) purchase confirmation customer sales order customer email confirmation Major Steps Performed 1 customer searches for desired part(s) Information for Steps part description, type, keywords 2 customer selects part desired part is selected 3 customer specifies order quantity number of parts to be purchased 4 customer confirms order selects check out option 5 Systems stores sales order information part, qty, unit price, total price, date, cust id, etc 6 Sytems sends confirmation email to customer sales order confirmation; cust. Email Use Case Name: Maintain Supplier Data LID:3 Importance Level: High Primary Actor: Manager Short Description: This describes the process by which the manager inserts, updates, deletes supplier data Trigger: type: Manager wishes to create or edit supplier data external Source manager Major Inputs: Description supplier name supplier location supplier email supplier deletion request Major Outputs: Desription supp. Id, name, location, phone Destination supplier account database manager manager manager account deletion supplier account archive database Major Steps Performed 1 manager creates supplier account Information for Steps name, location, email & phone number 2 Manager updates current supplier account updates all/partial supp. acct info( name, location, emal, phone number) 3 System auto assigns a unique supplier ID to each new supplier system sequentially assigns next available unique id number manager requests deletion of acct; acct is moved to archive 4 Manager deletes supplier account Use Case Name: Purchase Re-order Processing LID:4 Importance Level: High Primary Actor: Manager Short Description: This describes the process by which the manager places purchase re-orders and the storage of said purchase re-orders to a supplier Trigger: Manager needs to re-stock store inventory type: external Major Inputs: Major Outputs: Description Source Desription Destination part description/keywords manager purch. Re-order info (supplD, purchase re-order gty of parts part, date, price, etc) manager database purchase confirmation manager *this process could potentially occur completely outside of the system* (could be done within supplier's system) Major Steps Performed 1 manager searches for desired part(s) Information for Steps part description, type, keywords 2 manager selects part desired part is selected 3 manager specifies order quantity number of parts to be purchased 4 manager confirms order selects check out option 5 Systems stores purchase re-order information part, qty, unit price, total price, date, cust id, etc Use Case Name: Maintain Inventory Data LID: 5 Importance Level: high Primary Actor: manager Short Description: This describes the process by which inventory data is created, updated, or deleted. Trigger: type: Inventory needs to be created/updated/deleted external Source Major Inputs: Description part description part type/family part unit price part 'in-stock'qty part deletion request Major Outputs: Desription part record (id, descr, type, unit price, gty) Destination inventory database manager manager manager manager manager part record is deleted inventory archive database Major Steps Performed 1 Manager creates new part record Information for Steps part description, type/family, unit price, 'in-stock' qty 2 System auto assigns a unique part ID to each new part 3 Manager updates part record system sequentially assigns next available unique Id number either one or many part record properties are updated 4 Manager deletes part record manager requests certain part record deletion; moved to archive Use Case Name: Display Summary Reports LID: 6 Importance Level: medium Primary Actor: Manager Short Description: This describes the process by which the manager requests desired reports from the system. Trigger: Manager needs to perform business analysis type: external Major Inputs: Major Outputs: Description Source Desription Destination report request manager inventory report excel spreadsheet sales order report excel spreadsheet purchase reorder report excel spreadsheet Major Steps Performed 1 manager requests desired report from the system inventory, sales order, or purchase reorder 2 requested report is exported into excel spreadsheet for report manipulation all fields from individual sales order, purchase reorder, or inventory records are

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

Securing SQL Server Protecting Your Database From Attackers

Authors: Denny Cherry

1st Edition

1597496251, 978-1597496254

More Books

Students also viewed these Databases questions