Already have an account? Get multiple benefits of using own account!
Login in your account..!
Remember me
Don't have an account? Create your account in less than a minutes,
Forgot password? how can I recover my password now!
Enter right registered email to receive password!
Queensland Fruit Growers distribute fresh fruit juices throughout Australia. The systems and procedures in the company have evolved over many years. A recent Performance Audit has highlighted deficiencies in the company systems and procedures. The Board of Directors have employed a consultant to document the current systems starting with the order processing system.The customer orders, which are all credit sales, arrive by email or phone and in the processing of an order several other documents are created.The documents created are:• A packing slip which is used by the warehouse to fill the order.• A customer invoice which is sent after the fruit juice has been shipped.• When the order is not accepted an order rejection note is forwarded to the customer.• A receivable notice, which is a copy of the customer invoice, is forwarded to the accounting department so that the accounts receivable records can be updated.
The consultant reviewed the facts he had collected and prepared the following narrative summary:When an order is received by the order processing clerk they check the customer's credit file to confirm credit approval and to ensure that the order amount is within the agreed credit limit. If neither of these conditions is met then the order is forwarded to the credit control department. If the order meets both conditions the order processing clerk enters the details into the system using a standard order form. This information is used to update the customer file which contains name, address and other data. The form is then put in the open order file.When the credit department receives a rejected order the credit clerk determines why the order has been rejected. If the credit limit has been exceeded the customer is informed that their credit limit has been exceeded and that the fruit juice can only be delivered after a payment is received to bring the account back into agreed limits. If the customer does not have an agreed credit limit then a credit application is forwarded to the customer with a notification that the produce will be delivered as soon as credit is approved.When an order is received the system checks the inventory levels to determine if the fruit juice is available. If the fruit juice is available a packing slip is prepared and sent to the warehouse. When notification of despatch of fruit juice is received from the warehouse, an invoice is prepared. One copy is filed in the order processing department and a second copy is forwarded to the customer and a third copy is forwarded to the accounting department to update the accounts receivable. A note is placed in the customer file to confirm that an invoice has been sent.
• Requirement 1: o From the information presented in the case above complete the following- document flowchart for the order processing system, and- data flow diagram DFD at Level 0 for the order processing system.• Requirement 2: o Identify any deficiencies in system (if any) and the information needs for effective management of the order processing system in particular and the revenue cycle in general.• Requirement 3: o Make recommendations and suggestions to management to make the system more efficient and/or make improvements you see as appropriate. In doing so, you should consider adopting recent (since 2008) advances in information systems in one or two (but no more than two) of the following technologies- EDI/EDNIT- EFT/FEDI- RFID- ERPIn making recommendations, you need to justify them using a literature search that must include sources outside your set text and readings such as journal articles, business press, web sites making sure you cite all references used.• Requirement 4: o Highlight to management the complementing features of narrative descriptions and diagramming tools.
Write a SELECT statement that returns two columns: VendorName and PaymentSum, where PaymentSum is the sum of the PaymentTotal column.
write a 350-word summary describing two of the most popular database vendors in the marketplace. answer the following
A simple database with a single table contains data concerning car registration. The table contains four fields that store data relating to registration number (unique), make of car, year of manufacture and car colour
Create a link list in ADT c to maintain employee information like name,empid,basic salary and address.1.add employee info to the list if the empid is valid.
requirementscreate a database from scratch that contains at a minimum the elements listed below. the type of database
imagine that you have been assigned as a project manager to manage your companys e-commerce website where customers can
question 1. consider the relational schemapartpart-id name costsubpartpart-id subpart-id counta tuple p1 p2 3 in the
i. describe the application that you would like to design. this should include the purpose of the application and an
Produce an Entity-Relationship diagram which represents the above activities of the insurance company. Indicate the names and degrees of all the relationships. Give appropriate attributes for each entity shown, and identify the primary key for eac..
your database has been a hit. you have been called back to the customers headquarters and they want a detailed report
Create a database design specification Enhanced Entity Relationship Diagram (EERD) and Relational Data Model from the given business description - Database Management System
Draw a UML class diagram that models the aspects of job agencies that are described below.
Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!
whatsapp: +1-415-670-9521
Phone: +1-415-670-9521
Email: [email protected]
All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd