A financial services company is developing a new online loan…

A financial services company is developing a new online loan application system. The system includes user login, application submission, credit checks, document uploads, and approval processing. The company is preparing to move the system into production and wants to ensure that the system is reliable, secure, and ready for actual users. Answer all parts below. A. Identify and describe four different categories of testing that should be performed on this system before it is placed into production. For each category, briefly explain what it tests and why it is important for this system. B. The development team is currently testing individual program modules before combining them. Identify this type of testing and explain why it must be performed before integration testing. C. After all system testing is completed, real users are asked to test the system using real data before final deployment. Identify this type of testing and explain its role in approving the system for production. D. Identify the difference between system documentation and user documentation, and explain why both are required for the long-term success of this system.

A hospital is developing a new patient management system tha…

A hospital is developing a new patient management system that will store millions of patient records, appointment data, billing transactions, and historical medical visits. The system must support daily transaction processing as well as management reports that analyze large volumes of data. Answer all parts below. A. Identify which type of database is most appropriate for this system and justify your answer based on how the data will be stored and used. B. Explain the difference between a logical ERD and a physical ERD, and describe why the physical ERD is required before implementation. C. The database has been fully normalized for storage efficiency, but report performance is very slow. Identify two techniques that can be used to optimize access speed. Briefly explain how each technique improves performance. D. Explain the purpose of indexing, and identify two specific situations in which an index should be created.