1. More often than not, database environments in an 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?
The oldest information system used at American International Group (AIG) is the online employee registration system. This system has been in use for the last 25years. The online database of employee information is useful for providing information to the management of the company. The information obtained aids in making choices for AIG.
b. What is the age of the newest?
The newest information system at AIG is 2years.The name of this system is the Accounting Information system. The accounting information system was adopted in order to cater for the emerging accounting needs of the company (Hoskins, 2010). The accounting needs of the organization were addressed after the introduction of the accounting information system. This implies that the system has gone a long way in terms of pushing the organizational agenda.
c. Does the organization have both traditional file-based systems and modern relational database systems?
The company operates on the basis of both the traditional and modern based file systems. For example, the online registry of employees mentioned at the onset is a traditional file based system while the accounting information system is a modern based organizational file system. Both file systems have been instrumental in terms of consolidating the data and information needs of the company. For example, the online employee registry is used by the management in terms of obtaining information about employees.
d. What are the different user systems, end-user tools, end-user applications? Any data ware-houses? Any Web-based applications?
There are a number of end user systems within the Company. For example, the communication systems of the organization have been customized to fit the needs of other employees (Lattanze, 2009). It should be noted that employees in an organization have different roles which ought to be implemented in the right way. The integration of these communication systems has been instrumental in terms of bolstering the communication needs of the organization.
4. CASE tools, such as System Architect, are used for database development and support. Search on the Web and in trade journals for some of the popular CASE tools currently in use.
a. What CASE tools did you find, and who are their manufacturers?
The case tool that I found was the enterprise architect. The enterprise architect is a system tool used in the area of business models. The company that manufactured this case tool is called Sparx. The idea of this tool development was to aid in modeling business systems. The...