*****Visual Basic***** Customer Accounts Scenario Assume that you have been aske
ID: 3698458 • Letter: #
Question
*****Visual Basic*****
Customer Accounts Scenario
Assume that you have been asked to create an application that stores the following data about a customer account: Last Name, First Name, Customer number, Address, City, State, Zip Code, Telephone Number, Account Balance, and Date of Last Payment. The application should allow the user to save customer account records to the file, search the file for a customer by last name or customer number, and print a report listing all the customer records in the file.
Input validation: When entering a new record, make sure the user enters data for all customer info. Do not accept negative numbers for the account balance.
Discussion
This lesson focused on Structures. Make an argument either for or against using a Structure for storing the customer data indicated above.
1. Describe how you would store the data, giving the data type you would use for each item.
a. Explain why you chose to use a structure.
or
b. Explain why you chose not to use a structure.
Explanation / Answer
The use of structure approach is more common and pretty useful. The main benefit of using structure approach is that when you are using the stored data, you can easily bring it in, in the form of structures that make manipulations easier and code reusable and maintained. We can make sure the customer number is a primary key field and while adding a new customer, we can check for duplicates by matching each field and provide a new customer number to a new customer.
Since most of our queries also include the last name, we can do indexing of the data like all the customer having the last name starting with 'A' will get stored in one file and similarly for other letters, and if we have a lot of customers we can we can do that for two-letter combinations like 'AA', 'AB' . This is the way to retrieve customers in a faster way.
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.