Consider Figure 1-12, which depicts a hypothetical threetiered database architecture. Identify potential duplications of data across all the databases listed on this figure. What problems might arise because of this duplication? Does this duplication violate the principles of the database approach outlined in this chapter? Why or why not?

Transcribed Image Text:

Accounts payable processing Cash flow analyst Customer service representative Browser Browser Browser Client tier Database of vendors, purchase orders, vendor invoices Database of No local database customer receipts and our payments to vendors Application/Web server Application/Web tier A/P, AIR, order processing, inventory control, and so forth; access and connectivity to DBMS. Dynamic Web pages; management of session Enterprise tier Transaction databases containing all organizational data or summaries of data on department servers Enterprise server with DBMS