IT 423 Module Three Activity RDS and Manipulating Data  

Overview

While a non-relational database (NoSQL database) contains semi-structured and unstructured data, a relational database (that exclusively uses SQL for queries) contains structured data, and includes clear relationships between the components of the data. It includes relationships between the entities and attributes. In a relational database, tables are used to store the information.

AWS offers a relational database service that is hosted in the cloud: Amazon Relational Database Service (Amazon RDS). Since this database service is in the cloud, database instances are easy to scale and operate. In this activity, you will gain hands-on experience creating an RDS/MySQL instance. You will need to access the AWS Console through your AWS Academy student account.

Prompt

Imagine that you work for a small to medium-sized company and your manager wants to set up a relational cloud database system to analyze existing company data. To do this, follow this tutorial. After you set up the new RDS/MySQL instance, your manager requires MySQL Workbench to be configured and tested so that the database admins can begin to import the existing company data.

As you follow the tutorial, you should be completing the following:

• MySQL: Connect your database to MySQL Workbench.
• Tables: Create tables for Employees, Manager/Employee, Managers, and Customers.
• Keys and Attributes: Include the appropriate attributes in the tables.
• Data: Include the accurate test data identified in the tutorial.
• Data Manipulation: Assign employees Jill Employ and John Emp to their manager, Jill Manager.