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

Create: a) trace table for the below scenario. b)flowchart for the below scenario. c)UML diagram for the below scenario. A gas station attendant in the 1950's performs a series of actions for every customer that comes in. The list is as follows. greet customerask for required type of gas and amountask whether customer needs other servicesask for required amount of moneygive money to cashierwait for change and receiptgive change and receipt to customersay thank you and goodbye. He does not follow these actions when he is not on shift or when there is no customer to serve. There should also be instructions for when to stop performing an action. Think about how this might be created in a computer program.
Scenario – 2 Suppose that you are developing ERD about reality shows on TV. For each reality show, itsname, genre, basic_info and participants name. Any reality show has at least two or moreparticipants. Reality show may run for multiple days during the week. For each producer, thecompany name, company country is stored. A show is produced by exactly one producer. Andone producer produces exactly one show. For each television, its name, start year, head officeis stored. A television may broadcast multiple shows. Each show is broadcasted by exactly onetelevision. For each user, his/her username, password, and age is stored. A user may ratemultiple shows, and a show may be rated by multiple users. Each rating has a score of 0 to 10.Every show comes with Advertisement. Advertisement may belong to Single or more shows.Every advertisement will have customer who will pay for different packages for advertisements.Advertisements may vary from Reality show. Task to do: i. Identify Entities…
Create a Crow's Foot ERD to include the following business rules for the ProdCo company:a. Each sales representative writes many invoices.b. invoice is written by one sales representative.c. Each sales representative is assigned to one department.d. Each department has many sales representative.e. Each customer can generate many invoicesd. Each invoice is generated by one customer
34) The key function of a reservation system is to serve as the repository of all the bookings that have been accepted for future flights. Is this sentence valid A. True B. False C. Not applicable D.None of the above
I need an ER diagram for the following information For Hotel: HotelID (unique) and ANoOfRooms (number of rooms in the hotel) For Hotel: HotelID (unique) and ANoOfFloors (number of floors in the hotel) For each Room: RNO (partially unique, unique in the hotel) and ANoOfBeds (number of beds in the room) For each customer: CID (unique), CName (unique), For each manager: MID (unique), MFullName (composed of MFName and MLName), MBonus (not every manager has a bonus), MSalary, multiple MPhones For each employee: EID (unique), EName Each hotel has one or more rooms Each room is located on exactly one floor Each room is cleaned by one or two employees Each employee cleans 1-3 floors Each employee cleans 6-15 rooms Each customer has one or many rooms Each customer has booked one or mamy rooms Each room is booked by a customer or no one Each floor has one or many rooms Each manager resides in exactly one room Each manager resides on exactly one floor Each hotel either has one manager residing…
how the insert statement affect the whole process on the following entities: Business Software Game Development Entertainment 5-6 sentences each
Can you please help me to convert the class diagram into an ERD diagram with the relationships, constraints, fields and primary/foreign keys.Donor username: String +password: int PreviousDonations +donation Total: int setUsername(); getPassword(): setPassword() + calculate Total: Checkout setDonation Total(): display PreviousDonations(); DonationItems amount double 1.. calculate Total: Checkout) target double setTarget() displayDonationCount() 1 selAmount Manager Cart calculate Total double userinfo: String setTotal) getCardDetails() displayCheckout: Payment +payment CheckCard Featureltoms +amount: double calculate Total: Checkout) getAmount) displayFeaturettems(): number: int expDate: int cvNum: int Authorized Debit
1)Modeling: Make a CDM from the following scenario: * A retail company wants to manage their sales activity. We have the following information- The date of sale, with the possibility of rolling up to the week, month, quarter and year- the store where the sale was made: store name, brand, address, city, department and region. - The employee associated with each sale: surname, first name, date of birth, social security number. Each employee is associated with a store.the customer who purchased the product surname, first name, date of birth, address. The product sold product name, d - iption, category, unit price. The order: quantity sold, amount of turnover, amount of margin. A transaction can consist of one or more orders. The indicators (quantity, turnover, margin) can be negative if it is a reimbursement. 2) In your MCD above, what are the dimension tables? * 3)In your MCD above, what are the fact tables?
Question 1: Create an ERD that can be implemented for a medical clinic, using at least the following business rules: A patient can make many appointments with one or more doctors in the clinic, and a doctor can accept appointments with many patients. However, each appointment is made with only one doctor, and each appointment references a single patient. Emergency cases do not require an appointment. However, an emergency is entered into the appointment book as "unscheduled" for appointment management purposes. If kept, an appointment yields a visit with the doctor specified in the appointment. The visit yields a diagnosis and, when appropriate, treatment. Each visit updates the patient's records to provide a medical history. Each patient visit creates a bill. Each patient visit is billed by one doctor, and each doctor can bill many patients. Each bill must be paid. However, a bill may be…
25. Which expression below will return the time an individual entity spent in the system in Simio, using built-in Simio functions (i.e. not user-defined functions)? a. TimeNow - TimeCreated b. TimeInSystem c. ModelEntity.TimeInSystem d. TimeNow - ModelEntity.TimeCreated e. TimeNow - ModelEntity.TimeInSystem
Q2. (a.) Define term with an example a. Contingency reserves
Exercise 7-6 Symbolize the following so as to reveal as much logical structure as possible. Indicate the meanings of your abbreviations. 1. All marsupials have pouches. 3. Actually, not all marsupials have pouches. 5. Kangaroos and opossums are both marsupials. 7. Koala bears are not really bears at all. 9. Marsupials can be found in their natural habitats in both Australia and North America. 11.