More often than not, database environments in in organization reflect data structures that have been developed over a period of years, sometimes haphazardly, and that often reflect a variety of architectural styles and structures. Look at the existing database environment in your organization or school or in a local company.

a. What is the age of the oldest information system used in the organization?

b. What is the age of the newest?

c. Does the organization have both traditional file based systems and modem relational database systems?

d. What are the different user systems, end-user tools, end-user applications? Any data warehouses? Any Web-based applications?

e. Draw a data architecture diagram based upon the diagram shown in Figure 14-2.

Figure : 14-2:-

Users and Programmers A legacy nie-based Information wystem (bullt In-hous Information System In-house) Users and Programmers A legacy nite-based Information system (purchased) AAAAAAA Over Wo Users and Programmers Users and Programmers Information System (but in-house) End-User Tools Information System (buil In-house) End-User Applications Users Information System (purchased) +4 End-User Work Group