Answered step by step
Verified Expert Solution
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 RDSMySQL 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
AUTOINCREMENT 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, jdoe@google.com, Test Drive, NewCity, NewState, NewCountry,
Managers default, Jill Manager, jmanager@snhu.edu, Manage Street, NewCity, NewState, NewCountry,
Employees default, John Emp, jemp@snhu.edu, Employ Square, NewCity, NewState, NewCountry,
Jill Employ, jemploy@snhu.edu, Employ Square, NewCity, NewState, NewCountry,
Last, make sure to assign Jill Employ and John Emp to have Jill Manager as their manager in the ManagerEmployee table. To do this, you will
have to obtain the employeeid and managerid for each from a SELECT query.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started