C.1 Consider the Price Right Electronics Inc. flowchart presented below in Figure 1. Write a narrative description of the business process it depicts. FIGURE 1 Customer Customer order Marketing Sales order Sales order system Sales order (to customer) Credit New customer credit check Master file of customer credit limits Warehouse Maintain inventory master file Stock status report Compare for material availability Assemble order Sales order (to shipping and receiving) Update inventory master file Shipping and Receiving Pack and ship order Sales order/ packing slip (to customer) Accept and inspect material C.2 Describe at least two strengths and at least two weaknesses of the flowchart itself. Then, identify and describe at least two strengths and at least two weaknesses of the process it depicts. For each process weakness, suggest a way to correct it.

C.1 Consider the Price Right Electronics Inc. flowchart presented below in Figure 1. Write a narrative description of the business process it depicts. FIGURE 1 Customer Customer order Marketing Sales order Sales order system Sales order (to customer) Credit New customer credit check Master file of customer credit limits Warehouse Maintain inventory master file Stock status report Compare for material availability Assemble order Sales order (to shipping and receiving) Update inventory master file Shipping and Receiving Pack and ship order Sales order/ packing slip (to customer) Accept and inspect material C.2 Describe at least two strengths and at least two weaknesses of the flowchart itself. Then, identify and describe at least two strengths and at least two weaknesses of the process it depicts. For each process weakness, suggest a way to correct it.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Restaurant Management System For Restaurant Personnel- Show restaurant tables- Show table status (available, occupied, and dirty)- Change table status- Enter customer order- Modify order details- Cancel order- Make payment Write one scenario and design the corresponding Sequence Diagram that describeone of the main use cases
How does task information relate to dependencies?
Convert the use case diagram to activity diagram
Create a relational schema for this diagram
5, Analysis and Design (20 points) The WSP is a collection of overlapping applications for warehouse management, its Entity/Relationship diagram representing the entities involved in is shown in the figure 2. 1 CUSTOMER 1 stored at n n owns ITEM PLACE Figure 2 All the functions (element processes) of the WSP system are listed in figure 3. - Add customer Change customer data Delete customer - Delete place - Print customer item list - Print bill - Print stored items list - Query customers Query customer's items - Query places Query stored items Receive payment Deposit item Retrieve item Add place Change place data Figure 3 (1), please draw the domain class diagram and (2), please draw the use case diagram for the system. The domain class diagram and Use case diagrams can be drawn with modeling tools, or they can be drawn by hand, photographed, and inserted here. (for each diagram, 5 points for the correct format, 5 points for correct content) Answer question 5 here
18. The process of checking that all functions required by the customer were included in the requirements document is called: O Validity O Verifiability O Traceability O Completeness
What is the cardinality for the entity Department in the following ERD? Employee Department Employee number First name Last name Job title Dept number Dept number works Dept name in Dept location Instruction: Use proper spelling and/or punctuation in your answer.
Customer details Customer Customer details Account details Open Account Customer Service Assistant 2. Transaction his tory Check Transaction Transaction history Updated account balance Deposit amount Account Deposit Cash Cuatomer Withdrawn amount Updated account balance Withdraw Cash Transaction detals Order detals Transaction Place Order Order detals Broker Transaction details «Third Party> Stock Exchange Center 3. Pick any of the above systems and design the Entity-Relationship Diagram (ERD) for that system based on the proposed data stores. (*
II. Application: Read, understand and analyze the following case and provide answers to the below questions. 3. Design a use case diagram for hotel management system with at least two actors and four use cases. The features of the system depend on the following: · Manage Customers’ Information and Status · Manage Hotel Rooms Info and Status · Manage Hotel Info and Status · Monitor Hotel Transaction Records with customers
Define Use-Case Diagram and explain the figure shown below
o Create a use case diagram for the following requirements o The customer makes a request to purchase a product. The company and the customer negotiate the price if the customer wants. If they agree and the product amount in the system is enough, the company is delivered to the customer by cargo. o Use include and extend relationship at least once
1) Develop an activity diagram according to the following scenarios. Flow of activities for scenario of Order Clerk creates telephone order Main Flow 1. Customer calls RMO and gets order clerk. la. Order Clerk enters customer information. 2a. If an existing customer, order clerk verifies customer information. 26. If a new customer, invoke Maintain customer account information use case to add a new customer. 3. Clerk initiates the creation of a new order. 4. Customer requests an item to be added to the order. 5. Clerk verifies the item and adds it to the order. 6. Repeat step 4 and 5 until all items are added to the order. 7. Customer indicates end of order; clerk enters end of order; system computes total. 8. Customer submits payment; clerk enters amount; system verifies payment. 9. System finalizes order.