Health data fundamentals

Consider the following scenario: You are in a hospital setting that uses an enterprise EHR system with multiple interfaces to other health information platforms. What types of data would be kept in each system and what steps would be needed to allow for analytics to be performed across multiple disparate platforms?
Compare traditional paper health records to electronic records. What can one do that the other cannot? Some of the formats of electronic data include spreadsheets and databases. What are some of the trade-offs between using a spreadsheet versus a database to record, analyze, and retrieve data in a health care setting?