solution

Dogs-R-Us and K-9, Inc. are two retail stores that cater to the needs of dog owners in the greater Charleston area. There is healthy competition between these two establishments. Both operate 52 weeks a year and both sell approximately the same type and dollar value of items. Table 12.4 provides the cost of goods sold, the average inventory level, and unit value of each item sold in the two stores. a. Compare the two retail stores in terms of average aggregate inventory value. b. Compare the two retail stores in terms of weeks of supply. c. Compare the two retail stores in terms of inventory turnover.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Hashing Algorithm

The systems programmer uses a hashing algorithm to determine storage addresses. The hashing structure is 9,997/key. The resulting number is then used to locate the record. The first two digits after the decimal point represent the cylinder number, while the second two digits represent the surface number. The fifth, sixth, and seventh digits after the decimal point represent the record number. This algorithm results in a unique address 99 percent of the time. What happens the remainder of the time when the results of the algorithm are not unique? Explain in detail the storage process when Key=3 is processed first, Key=2307 at a later date, and shortly thereafter Key=39.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

Structured Query Language

The vice president of finance has noticed in the aging of the accounts receivable that the amount of overdue accounts is substantially higher than anticipated. He wants to investigate this problem. To do so, he requires a report of overdue accounts containing the attributes shown in the top half of the of Problem 3 table on the next page. The bottom half of the table contains the data fields and relevant files in the relational database system. Further, he wants to alert the salespeople of any customers not paying their bills on time. Using the SQL commands given in this chapter, write the code necessary to generate a report of overdue accounts that are greater than $5,000 and more than 30 days due. Each customer has an assigned salesperson.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

solution

File Organization

For the following situations, indicate the most appropriate type of file organization. Explain your choice.

a. A local utility company has 80,000 residential customers and 10,000 commercial customers. The monthly billings are staggered throughout the month and, as a result, the cash receipts are fairly uniform throughout the month. For 99 percent of all accounts, one check per month is received. These receipts are recorded in a batch file, and the customer account records are updated biweekly. In a typical month, customer inquiries are received at the rate of about twenty per day.

b. A national credit card agency has 12 million customer accounts. On average, 30 million purchases and 700,000 receipts of payments are processed per day. Additionally, the customer support hot line provides information to approximately 150,000 credit card holders and 30,000 merchants per day.

c. An airline reservation system assumes that the traveler knows the departing city. From that point, fares and flight times are examined based on the destination. Once a flight is identified as being acceptable to the traveler, then the availability is checked and, if necessary, a seat is reserved. The volume of transactions exceeds one-half million per day.

d. A library system stocks more than 2 million books and has 30,000 patrons. Each patron is allowed to check out five books. On average, there are 1.3 copies of each title in the library. Over 3,000 books are checked out each day, with approximately the same amount being returned daily. The check-outs are posted immediately, as well as any returns of overdue books by patrons who wish to pay their fines.

 
"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"