Which of the following will a company do to update a customer's address while using a flat file database?
Which of the following will a company do to update a customer's address while using a flat file database?
In a flat file database, data is stored in a plain text format, typically in a single table that could contain repeated information. Therefore, updating the customer's address would require updating the address for each order they placed individually since there is no concept of relational tables. Hence, the correct approach would be to update the address for each instance where the customer's address appears, which matches option A.
If they are going to update the customer's ADDRESS, wouldn't it be in the ADDRESS field on the table? Not the Customer's ORDER field on the table? Or am I just overthinking this one?
You would update a customer's address in the Address field.
B. Update the address in the customer address table. In a flat file database, information is typically organized into tables, and each table contains rows and columns. The customer's address is part of the customer data, and updating it would involve modifying the relevant record in the customer address table. Option B reflects the standard practice of updating the address information at its source in the customer address table.
Yeah, i chose B as well.
aaaaaaaaaaaaaaaaaaaaaaaaaaaaaa