Explore BrainMass

The use of databases software

This content was STOLEN from BrainMass.com - View the original, and get the already-completed solution here!

Prepare a 2-page memorandum (350 words per page) analyzing the use of databases in a credit card organization. Include what database applications are used or may be used and why they are used (Microsoft Access, DB2, Oracle, etc.). Conclude by proposing improvements. For large organizations, restrict the scope of the paper to a Telephone call center or Customer service departments.

please include an abstract and include any references EXCLUDING information found in http://en.wikipedia

© BrainMass Inc. brainmass.com October 25, 2018, 12:18 am ad1c9bdddf

Solution Preview

The response addresses the queries posted in 1049 words with references.

//The given discussion paper is in the form of a memorandum. In the introduction part of the memo I am describing the detailed information of database and their use in the various forms for different purposes in credit card organizations. The concept of the database is described me in the introduction part of the discussion paper.//


Date: January 16, 2009


From: XYZ

Subject: Database

Collection of Data, used to store in the Computer.

Objective: To Analyze the use of databases and describe their applications.


This paper gives a detailed analysis of the methods of using a database in the credit card organization. There is also a description of database applications, which are used by the credit card organizations. There are various types of databases like Microsoft access, oracle and D2B, which are used by these credit card organizations to analyze the functioning and identifying any error, which further assists these organizations to correct the errors.


Databases are used by the organizations for updating the interrelated systems and improving the functioning of different programs and activities. Databases are used to accomplish the key tasks and functions effectively and to cope up with the technological changes occurring in the environment. In Present Scenario, databases are used increasingly by credit card organizations to provide the customized services to the users of credit cards, which also assist these organizations to meet the unmet needs of the customers. Databases range from small size, which can be used on PC's to large size, used on Mainframe Computers. The information is collected according to the structure of the database models. ...

Solution Summary

The response addresses the queries posted in 1049 words with references.

See Also This Related BrainMass Solution

Prepare a systems analysis report detailing Ace's problem and a systems solution that can be implemented using PC database management software.

Ace Auto Dealers specializes in selling new vehicles from Subaru. The company advertises in local newspapers and is also listed as an authorized dealer on the Subaru Web site and the major Web sites for auto buyers. The company benefits from good local word-of-mouth reputation and name recognition and is a leading source for Subaru vehicles in the Prince Edward Island area.

When a prospective customer enters the showroom, he or she is greeted by an Ace sales representative. The sales representative manually fills out a form with such information as the prospective customer's name, address, telephone number, date of visit, and model and make of vehicle in which he or she is interested. The representative also asks where the prospective buyer heard about Ace?whether it was from a newspaper ad, the Web, or word of mouth and this information is also noted on the form.

If the customer decides to purchase an auto, the dealer fills out a bill of sale form, listing the vehicle identification number, vehicle make and model, colour, options selected, base price, total price, and date of the sale along with the purchaser's name, address, and telephone number. This form also shows the amount of the total purchase price that was financed. Both forms are filed in manual folders?one for sales prospects and another for actual purchases.

Ace does not feel it knows enough about its customers. It cannot easily identify repeat customers at its dealership or customers who have purchased a Subaru in the past from another dealer. It cannot easily determine which prospective buyers have made auto purchases or the percentage of those who have been converted into buyers. Nor can it identify which customer touchpoints have produced the greatest number of sales leads or actual sales so it can focus its advertising and marketing more on the channels that generate the most revenue. Are purchasers coming from newspaper ads, from word of mouth, or from the Web? Additionally, the firm cannot tell whether its customers are more interested in no-frills cars or ones with luxury options. Prepare a systems analysis report detailing Ace's problem and a systems solution that can be implemented using PC database management software.

*** The program doesn't need to be designed.***

View Full Posting Details