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.