M5 - Module Review

774 Words4 Pages
M5 – Module Review MGMT221 Lee Freeman Part 1: Answer the Module Review Questions listed below. These questions were chosen to demonstrate your understanding and help you assess your progress. 1. Discuss the advantages of a database management approach to the file processing approach? Give examples to illustrate your answer. A couple advantages would be that it consolidates data records and objects into databases that can be accessed by many different applications. Also, it serves as a software interface between applications and databases thereby reducing data dependence. The approach attempts to solve the other problems involved in file processing such as data redundancy, lack of data integration, and data integrity. An example would be that a University’s’ course registration system should share the same databases which support the student financial aid conditions. Shared info would include a student’s name, ID, and financial status. In that way, if a student changes his or her name or if the student’s financial condition prohibits course registration, both applications will know about it. 2. Outline the benefits and limitations of the relational database model for business applications today? Some benefits are that it’s the most popular of the 3 database structures and its structure is logical and easy to comprehend. Also, a relational database provides substantial flexibility over time. On the other hand, it can’t process large amounts of business transactions as quickly and efficiently as the hierarchical and network models. 3. How should a business store, access, and distribute data and information about its internal operations and external environment? Businesses should take a database management approach and “store” pertinent information in the form of structured databases. These databases help a business
Open Document