Question 1. Your CEO calls you into her office to discuss the recent drop in sales. She would like your recommendation regarding how IT might be used to generate an increase in sales. Identify and discuss IT applications and technology that you might recommend to a small company to help it survive and succeed in challenging economic times.

Question 2. Your CEO calls you into his office and informs you that the management reports he receives are inaccurate and the reports that support cross-functional organization needs must be manually prepared. The CEO would like you to provide an explanation of possible causes for the lack of cross-functional data and the possible causes for the information deficiencies. He would like you to provide a recommendation to resolve these issues.

Question 3. A medium-sized school district is experiencing large growth and is operating with a clearly obsolete information system. Most schools have developed their own systems to manage school records. Each school wants to maintain control over its data. The central office maintains a networked relational database system which is available through the Central Office Local Area Network. The central office maintains records on 950,000 students. The schools send the Central Office paper, excel spreadsheets, database extractions, and Word documents that contain the data to be entered into the central office database. These records are mailed to the Central Office staff and are re-keyed into the mainframe. The school district would also like to provide students and parents with access to school announcements, homework assignments, grades, and emergency alerts. IS631 Midterm Examination 2 of 2 ?The School Superintendent doesnt understand or have time to sort out the modern technologies. Develop and describe your recommendation on how the school district might become a networked enterprise that utilizes modern technology. Identify if you are recommending a centralized or decentralized system and justify your selection. Include key considerations, key components, and a diagram of your recommendation.

Question 4. Assume we have the following application that models patients, the medication they take, and the physician. In the design, we want to capture the following:

We have a set of patients, each patient has an ID (unique identifier), name, DOB, and address.

Each physician has many patients, and each patient belongs to one physician. Each physician has a number (unique identifier), name, DOB, and specialty.

A Physician can prescribe a set of medications to each patient. Design an ER diagram to capture the above requirements. State any assumptions you have that affect your design. Make sure cardinalities and primary keys are clear. Please use ERDPlus.com to create the ERD and import it to images that you can embed in an MS Word Document and submit to the BB Dropbox.

Question 5. Short Answer. (a) Explain why network protocols are necessary for network operation.

( b) Data analytics can help companies achieve major business outcomes. List four areas where IT can make a major difference and explain how and why. Give examples.