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.
What to Submit
Set up RDS/MySQL instance: Submit a screenshot of the final system running (this will be taken during setup of the RDS/MySQL instance). Also you will be required to submit a screenshot of your MySQL Workbench connected to your newly created database. Your name must be included in the RDS system to verify that you created it.
Answer Preview-RDS and Manipulating Data-IT-423
