Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Once you are done creating the entities, make the adjustments shown below. When you are done, include a screenshot of the database tables with your

Once you are done creating the entities, make the adjustments shown below. When you are done, include a screenshot of the database tables
with your submitted work. This should include a screenshot of your running RDS/MySQL instance (with your last name included in the name) and
a screenshot of the running MySQL Workbench connection showing the new database, tables, and data. Make sure that you are using
AUTO_INCREMENT for the ID fields and using DEFAULT for the value in the records so that you establish the correct ID field for each entity. Also,
be sure that the field sizes that you define are large enough to accommodate the data that will be inserted into them.
Customers default, John Doe, j.doe@google.com, 123 Test Drive, NewCity, NewState, NewCountry, 12345
Managers default, Jill Manager, j.manager@snhu.edu, 234 Manage Street, NewCity, NewState, NewCountry, 12345
Employees default, John Emp, j.emp@snhu.edu, 444 Employ Square, NewCity, NewState, NewCountry, 12345
Jill Employ, j.employ@snhu.edu, 293 Employ Square, NewCity, NewState, NewCountry, 12345
Last, make sure to assign Jill Employ and John Emp to have Jill Manager as their manager in the Manager_Employee table. To do this, you will
have to obtain the employee_id and manager_id for each from a SELECT query.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Data Mining Concepts And Techniques

Authors: Jiawei Han, Micheline Kamber, Jian Pei

3rd Edition

0123814790, 9780123814791

More Books

Students also viewed these Databases questions

Question

In an Excel Pivot Table, how is a Fact/Measure Column repeated?

Answered: 1 week ago