Please answers these questions some require SQL and coding.

This covers chapters 19-23 from the textbook. Please submit as your complete answers to each problem the following:

Valid answers that are related to the textbook material and how they apply to your project or project like example. Just saying we did not need to or we did need to use a capability will not suffice as a complete description.

syntax (code needed to support your answer)

output (screenshot or other visualization method) of the executed code to receive full credit.

Scenario:

An IS department in a major public university records the lectures for 10 of its classes for video streaming to its partner universities in India and China. Each twice-weekly lecture runs for 1.25 hours and a semester is 15 weeks long. A video streaming expert estimates that one minute of digital video requires 6.5 Mbytes using MPEG-4 and Apple's QuickTime software.

Part A:

Calculate how much storage space will be required and recommend a storage device for the department.

Part B:

Describe the differences between a file manager, a disk manager, and the advantages and disadvantages of indexing. Based on the storage calculation performed in part A, in your project calculate the storage space that is required for your data housing solution, what structure and storage device is best for your application.

Scenario:

A university wants to teach a specialized data management topic to its students every semester. It will take about two weeks to cover the topic, and during this period students will need access to a small high performance computing cluster on which the necessary software is installed. The software is Linux-based.

Part A:

Investigate three cloud computing offerings and make a recommendation as to which one the university should use.

Part B:

Describe the high performance computing data processing architecture utilized in your project. Explain how the following in your solution:

data architecture chosen for a given situation (your project)

how the architecture uses a multi-tier client/ server architecture, or why it does not need to use multi-tier.

what fundamental principles your project uses to incorporate a hybrid architecture or why your project does not need it.