Create tables for employees- managers and customers

Assignment Help Database Management System

Reference no: EM133755119

Assignment: Activity RDS & 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:

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

Reference no: EM133755119

Questions Cloud

Upholding ethical standards to their client population : These are expectations the nurse is supposed to carry out while providing safety and upholding ethical standards to their client population.

Visualization could analyse customer demographics : Visualization could analyse customer demographics to identify those most prone to default on their loans. Take screenshots of each of the visualisations

Creating sql queries relating to loan statuses : Creating SQL Queries relating to Loan Statuses and Creating SQL Queries relating to Loan Defaults/Delinquencies - Take screenshots of the query

Drug addiction is challenging but achievable goal : Examples of how to use information using Parenthetical citations to indicate sources for text Coping with drug addiction is a challenging but achievable goal.

Create tables for employees- managers and customers : IT 423 Suny Old Westbury- Create tables for Employees, Manager/Employee, Managers, and Customers. Include the appropriate attributes in the tables.

Facilitate the integration of evidence : The main responsibility of a healthcare leader in evidence-based healthcare is to guide and facilitate the integration of evidence

Server connection and simple sql queries : Manager in evaluating and approving loan applications more effectively. For instance, one visualization could analyse customer demographics

Client admitted with congestive heart failure : Client admitted with congestive heart failure who had a prescription for 80 mg IV furosemide. What should the nurse manager do first?

Registered nurses authority in florida : An example of a primary difference between a registered nurse's authority in Florida and that of a practical nurse's authority

User Account

All Pages