Reference no: EM132380509

Cloud Migration: Performance

Assignment Content

In week 1, you discussed GIG, Inc.'s benefits and concerns with moving to the cloud. Last week, you created a high-level diagram of a system using built-in AWS that provided reliability, availability, and continuity across the migrated environment.

This week, choose one of the following database scenarios:
• Transactional database (e.g., eCommerce)
• Analytic database (query very large datasets)
• Internet scale application (serves content and stores both structured or unstructured data)

Create a diagram in Microsoft/ Visio/ that applies built-in AWS that visualizes the chosen system and implementation steps.

Create a 6- to 8-slide presentation that outlines the following:
• Overview of AWS database options
• The best AWS database service for the chosen scenario
• Support the decision with evidence
• Outline the key features of the given database

Submit your diagram and presentation.

Assignment 2

For this assignment you will create SQL queries use the following database schema:

1. Patient-PatientID, Name, DOB
2. Doctor-DoctorID, Name, MedLicenseNumber, Phone
3. Medication-MedicationID, BrandName, GenericName
4. Prescription-PrescriptionID, Date, PatientID, PrescriberID, MedicationID

Specify the SQL queries to retrieve:
1. A list of all doctors.
2. The number of patients who were born before 01/01/1994.
3. The patient information along with the ID of any prescribing doctor for each patient.
4. The prescription information along with patient name, DOB, medication brand name, and prescribing doctor name sorted by most recent date.
5. The most prescribed generic medication name.