Accounting Information Systems
10th Edition
ISBN: 9781337619202
Author: Hall, James A.
Publisher: Cengage Learning,
expand_more
expand_more
format_list_bulleted
Question
Chapter 9, Problem 6P
To determine
Draw partial relational database for Company PGP. Also, label database tables assigning necessary attributes, foreign and primary key assuming that invoice, purchase orders and receipts contains many items.
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Arcontica Classic Furniture (ACF) manufactures a range of rustic chairs, lawn furniture, and interior furnishing including lamps, desks, and bed frames. ACF's customer base comprises both private customers and retail outlets. Consumer's sales are for cash or by credit card, but business customers are for cash or by credit card, but business customers are extended a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online, by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepares a sales order, and sends the stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department updates the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR…
Green Pond Nursery Supply (GPNS) is a gardencenter wholesaler in eastern Pennsylvania that sellsand distributes a wide range of garden productsand equipment including organic fertilizers, premiumflower and grass seeds, organic pesticides, and gardenspreaders. GPNS’s customers are primarilysmall garden centers and landscape companies in theMid-Atlantic states. Sales are on credit.GPNS’s current information system includes manualprocedures supported by independent (nonnetworked)PCs in each department. Communicationsbetween departments are entirely throughhard-copy documents. Recently, GPNS has beenreceiving complaints from suppliers regarding paymenterrors. Management believes that these complaintsstem, in part, from their antiquated computersystem. You have been hired to assess GPNS’s proceduresand internal controls. The following is adescription of GPNS’s expenditure cycle.Purchasing ProcessThe purchasing agent receives an inventory statusreport from the inventory control…
Arcontica Classic Furniture manufactures a of rustic chairs, lawn furniture, and interior purnishing including lamps, desks and bed frames. AFC's customer base comprises both private customers and retail outlets. consumer's sales are for cash or by credit card, but business costumers are for cash or by credit card, but business costumers are extended by a line of credit. New business customers undergo a credit check before receiving a credit line. All sales are made online by fax or mailed in hard copy order. When a credit order is received, the sales clerk verifies inventory availability, prepare a sales order, and sends stock release copy to the warehouse clerk who picks the goods and arranges shipment. He then prepares the bills of lading and sends copies of the shipping notices to the billing department and inventory control. The billing department update the sales journal and sends an invoice to the customer. The clerk then sends the shipping notice to the AR department where…
Chapter 9 Solutions
Accounting Information Systems
Ch. 9 - Prob. 1RQCh. 9 - Prob. 2RQCh. 9 - Prob. 3RQCh. 9 - Prob. 4RQCh. 9 - Prob. 5RQCh. 9 - Prob. 6RQCh. 9 - Prob. 7RQCh. 9 - Prob. 8RQCh. 9 - Prob. 9RQCh. 9 - Prob. 10RQ
Ch. 9 - Prob. 11RQCh. 9 - Prob. 12RQCh. 9 - Prob. 13RQCh. 9 - Prob. 14RQCh. 9 - Prob. 15RQCh. 9 - Prob. 16RQCh. 9 - Prob. 17RQCh. 9 - What are the conditions for third normal form...Ch. 9 - Prob. 19RQCh. 9 - Prob. 20RQCh. 9 - Prob. 21RQCh. 9 - What is a user view?Ch. 9 - Prob. 23RQCh. 9 - Prob. 24RQCh. 9 - Prob. 25RQCh. 9 - Prob. 1DQCh. 9 - Prob. 2DQCh. 9 - Prob. 3DQCh. 9 - Prob. 4DQCh. 9 - Prob. 5DQCh. 9 - Prob. 6DQCh. 9 - Prob. 7DQCh. 9 - Prob. 8DQCh. 9 - Prob. 9DQCh. 9 - Prob. 10DQCh. 9 - Prob. 11DQCh. 9 - Prob. 12DQCh. 9 - Prob. 13DQCh. 9 - Prob. 14DQCh. 9 - Prob. 15DQCh. 9 - Discuss the accounting implications of the update,...Ch. 9 - Prob. 17DQCh. 9 - Prob. 18DQCh. 9 - Prob. 19DQCh. 9 - Prob. 20DQCh. 9 - Prob. 1MCQCh. 9 - Prob. 2MCQCh. 9 - Prob. 3MCQCh. 9 - Prob. 4MCQCh. 9 - Prob. 5MCQCh. 9 - Prob. 6MCQCh. 9 - Prob. 7MCQCh. 9 - Prob. 8MCQCh. 9 - Prob. 9MCQCh. 9 - Prob. 10MCQCh. 9 - Prob. 11MCQCh. 9 - Prob. 12MCQCh. 9 - Prob. 13MCQCh. 9 - Prob. 14MCQCh. 9 - Prob. 15MCQCh. 9 - Prob. 16MCQCh. 9 - Prob. 17MCQCh. 9 - Prob. 18MCQCh. 9 - The Mega Supply Corporation has three divisions:...Ch. 9 - Prob. 2PCh. 9 - Lesters Rentals is located in Cincinnati, Ohio....Ch. 9 - Prob. 4PCh. 9 - Prob. 5PCh. 9 - Prob. 6PCh. 9 - Prob. 7PCh. 9 - Prob. 8PCh. 9 - Prob. 9PCh. 9 - Prob. 10PCh. 9 - Prob. 11PCh. 9 - Prob. 12PCh. 9 - Prepare the 3NF base tables needed to produce the...Ch. 9 - Prob. 14PCh. 9 - Prob. 15PCh. 9 - Prob. 16PCh. 9 - Prob. 17PCh. 9 - Prob. 18PCh. 9 - Prob. 21PCh. 9 - Prob. 22PCh. 9 - Prob. 23PCh. 9 - Prob. 24P
Knowledge Booster
Similar questions
- GREEN POND NURSERY (STAND ALONE PC-BASED ACCOUNTINGSYSTEM)Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and gar den spreaders. GPNS's customers are primarily small garden centers and landscape companies in the Mid-Atlantic states. Sales are on credit.GPNS's current information system includes manual procedures supported by independent (non networked) PCs in each department. Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these com plaints stem, in part, from their antiquated computer system. You have been hired to assess GPNS's procedures and internal controls. The following is a description of GPNS's expenditure cycle.Purchasing ProcessThe purchasing…arrow_forwardGREEN POND NURSERY (STANDALONE PC-BASED ACCOUNTING SYSTEM) Green Pond Nursery Supply (GPNS) is a garden center wholesaler in eastern Pennsylvania that sells and distributes a wide range of garden products and equipment including organic fertilizers, premium flower and grass seeds, organic pesticides, and garden spreaders. GPNSs customers are primarily small garden centers and landscape companies in the Mid-Atlantic States. Sales are on credit. GPNSs current information system includes manual procedures supported by independent (non-networked) PCs in each department Communications between departments are entirely through hard-copy documents. Recently, GPNS has been receiving complaints from suppliers regarding payment errors. Management believes that these complaints stem, in part, from their antiquated computer system. You have been hired to assess GPNSs procedures and internal controls. The following is a description of GPNSs expenditure cycle. Purchasing Process The purchasing agent receives an inventory status report from the inventory control department, which identifies the items that need to be reordered. The agent selects the suppliers, enters this information into the computer terminal to create a digital purchase order, and then prints three hard copies of the purchase order. He sends one copy to the supplier; one copy to the AP department, where it is filed temporarily, and files the third copy in the purchasing department. When the goods are received, the receiving department inspects and verifies them using the packing slip, which is attached to the goods. The receiving clerk manually prepares two hard copies of a receiving report. One copy accompanies the goods to the warehouse for storage. The receiving clerk sends the second copy to the purchasing agent who closes the open purchase order. The purchase agent then forwards the receiving report to the inventory control clerk. The inventory control clerk receives the receiving report and updates the inventory subsidiary. At the close of business, the clerk prepares an inventory summary, which he sends to the general ledger clerk. Accounts Payable and Cash Disbursements Procedures The AP clerk receives the suppliers invoice and reconciles it with the purchase order in the temporary file. From her computer terminal, the clerk records the purchase in the purchases journal and records the liability by adding a record to the AP subsidiary ledger. The purchases order and invoice are then filed in the department. Each day, the AP clerk visually searches the AP subsidiary ledger from her terminal for invoices that are due to be paid. The clerk prepares the check and records it in the digital check register. The negotiable portion of the check is mailed to the vendor, and a check copy is filed. The clerk then closes the liability in the AP subsidiary ledger and prepares a journal voucher, which she sends to the general ledger clerk. Upon receipt of the inventory summary and journal voucher, the general ledger clerk updates the inventory control, AP control, and cash accounts. Required a. Create a data flow diagram of the current system. b. Create a system flowchart of the existing system. c. Analyze the physical internal control weaknesses in the system. d. (Optional) Prepare a system flowchart of a redesigned computer-based system that resolves the control weaknesses that you identified. Explain your solution.arrow_forwardMOUNTAIN ADVENTURE: WHITE WATER AND CAMPING SUPPLIES (NETWORKED COMPUTER SYSTEM AND MANUAL PROCEDURES) MOUNTAIN ADVENTURE is a Montana-based wholesaler of rafting and camping equipment that serves outdoor sports camping retailers throughout the northwest. You have been hired by MOUNTAIN ADVENTURE to evaluate their processes, risks, and internal controls. The following paragraphs describe Outdoor Adventure’s revenue cycle procedures. Revenue Cycle SALES ORDER PROCESSING PROCEDURES. Customer orders are mailed or e-mailed to the sales department. When the order is received the sales clerk checks the customer’s creditworthiness from a computer terminal by running a validation application. The credit-check program determines if the customer’s account is up-to-date regarding payments and the customer has not exceeded his or her credit limit. Computer controls in the application prevent further processing of any transactions that fails the credit check. Under certain extenuating…arrow_forward
- GREEN PRODUCTS GARDENSUPPLY (STAND-ALONE PC-BASEDACCOUNTING SYSTEM)Green Products Garden (GPG) Supply sells and distributesa wide range of garden products and equipmentincluding organic fertilizers, premium flowerand grass seeds, organic pesticides, and gardenspreaders. GPG’s headquarters and warehouse islocated in Hopewell, Virginia. Their customers areprimarily small garden centers and landscape companiesin the Mid-Atlantic States. Sales are oncredit.GPG’s current information system includes manualprocedures supported by independent (nonnetworked)PCs in each department. Communicationsbetween departments is entirely through hardcopydocuments. Recently, GPG has been receivingcomplaints from customers and suppliers about billing,shipping, and payment errors. Managementbelieves that these complaints stem, in part, fromtheir antiquated computer system. You have beenhired to assess GPG’s procedures and internal controls.The following is a description of GPG’s revenue cycle. Sales…arrow_forwardJC Company sells various merchandize ( building materials, stationery, house hold goods, and assortd groceries) to the general public and government workers on both cash and credit basis. You are a student at one of the universities and the sole trader for JC Company approaches you to write a company profile for him.arrow_forward(Warranty, Customer Loyalty Program) Hale Hardware takes pride as the “shop around the corner” that can compete with the big-box home improvement stores by providing good service from knowledgeable sales associates (many of whom are retired local handymen). Hale has developed the following two revenue arrangements to enhance its relationships with customers and increase its bottom line.1. Hale sells a specialty portable winch that is popular with many of the local customers for use at their lake homes (putting docks in and out, launching boats, etc.). The Hale winch is a standard manufacture winch that Hale modifies so the winch can be used for a variety of tasks. Hale sold 70 of these winches during 2019 at a total price of $21,000, with a warranty guarantee that the product was free of any defects. The cost of winches sold is $16,000. The assurance warranties extend for a 3-year period with an estimated cost of $2,100. In addition, Hale sold extended warranties related to 20 Hale…arrow_forward
- (Warranty, Customer Loyalty Program) Hale Hardware takes pride as the “shop around the corner” that can compete with the big-box home improvement stores by providing good service from knowledgeable sales associates (many of whom are retired local handymen). Hale has developed the following two revenue arrangements to enhance its relationships with customers and increase its bottom line.1. Hale sells a specialty portable winch that is popular with many of the local customers for use at their lake homes (putting docks in and out, launching boats, etc.). The Hale winch is a standard manufacture winch that Hale modifies so the winch can be used for a variety of tasks. Hale sold 70 of these winches during 2017 at a total price of $21,000, with a warranty guarantee that the product was free of any defects. The cost of winches sold is $16,000. The assurance warranties extend for a 3-year period with an estimated cost of $2,100. In addition, Hale sold extended warranties related to 20 Hale…arrow_forwardThe following narrative describes the processing of customer mail orders at Eye- Dee- A- Pet, Inc.: Eye- Dee- A- Pet, Inc. is a small manufacturing operation engaged in the selling of digital identification chips that can be implanted into household pets, such as cats and dogs. Customers (e. g., veterinary clinics, animal hospitals) send orders by mail to the sales order department, where sales order clerks open the orders and review them for accuracy. For each order, the clerks enter the customer number, and the computer displays the customer record. The clerk matches the customer information on the screen with the customer order. Assuming that they match, the clerk enters the items and quantities being ordered. The computer edits the order by comparing the input data to customer and inventory master data. Assuming that the order passes the edits, the computer records the order on the sales event data and the sales order master data and then updates the inventory to allocate the…arrow_forwardDURAPLAST’s sales department consists of 17 full-time and part-time employees. They receive orders via traditional mail, e-mail, telephone, and the occasional walk-in. Because DURAPLAST is a wholesaler, the vast majority of its business is conducted on a credit basis. The process begins in the sales department, where the sales clerk enters the customer’s order into the centralized computer sales order system. The computer and file server are housed in DURAPLAST’s small data processing department. If the customer has done business with DURAPLAST in the past his or her data are already on file. If the customer is a first-time buyer, however, the clerk creates a new record in the customer file. The system then creates a record of the transaction in the open sales order file. When the order is entered, an electronic copy of it is sent to the customer’s e-mail address as confirmation. A clerk in the warehouse department periodically reviews the open sales order file from a terminal and…arrow_forward
- Wholesome and Happy Foods is a farm-to-family grocery store located in the Pacific Northwest. The company recently installed four self-checkout lanes that allow customers to scan their own groceries and pay for their purchases using an automated checkout kiosk. The kiosks are monitored by a single attendant. In recent weeks, management has become concerned that some customers are not scanning all of the items that they bring through the self-checkout lanes. Write a brief memo suggesting features and capabilities for the kiosks that would serve as control procedures, ensuring that all items brought through the self-checkout lanes are properly scanned and purchased.arrow_forwardSmith’s Market (Small Business Cash Sales Accounting System) In 1989 Robert Smith opened a small fruit and vegetable market in Bethlehem, Pennsylvania. Originally Smith sold only produce grown on his family farm and orchard. As the market’s popularity grew, however, he added bread, canned goods, fresh meats, and a limited supply of frozen goods. Today Smith’s Market is a full-range farmers’ market with a strong local customer base. Indeed, the market’s reputation for low prices and high quality draws customers from other Pennsylvania cities and even from the neighboring state of New Jersey. Currently Smith’s has 40 employees. These include sales staff, shelf stockers, farm laborers, shift supervisors, and clerical staff. Recently Smith has noticed a decline in profits and sales, while his purchases of products for resale have continued to rise. Although the company does not prepare audited financial statements, Robert Smith has commissioned your public accounting firm to assess his…arrow_forwardMartin Shoes, Inc. manufactures and distributes orthopedic footwear. To sell its products, the marketing department requires sales personnel to call on the shoe retailers within their assigned geographic territories. Each salesperson has a laptop computer, which he or she uses to record sales orders during the day and to send these sales orders to Martin’s network nightly for updating the company’s sales order file. Each day, warehouse personnel review the current sales orders in its file, and where possible, pick the goods and ready them for shipment. (Martin ships goods via common carrier, and shipping terms are generally FOB from the shipping point.) When the shipping department completes a shipment, it also notifies the billing department, which then prepares an invoice for the customer. Payment terms vary by customer, but most are net 30. When the billing department receives a payment, the billing clerk credits the customer’s account and records the cash received. Requirements 1.…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,Pkg Acc Infor Systems MS VISIO CDFinanceISBN:9781133935940Author:Ulric J. GelinasPublisher:CENGAGE L
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
Pkg Acc Infor Systems MS VISIO CD
Finance
ISBN:9781133935940
Author:Ulric J. Gelinas
Publisher:CENGAGE L