nsert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total). Administrator employeeNumber SchoolNumber firstname lastName phoneNumber officeNumber 4 45 Albus Dumbledore 2072087222 201 60 45 Minerva McGonagall 2406994295 150 119 45 Percy Weasley 4324061884 302 138 345 Ken Jeong 5058091461 503 52 345 Jim Rash 4173119531 654 16 345 John Oliver 4255510706 321 25 93 Dennis Haskins 5056465505 987 146 93 Hayley Mills 5056443920 852 101 93 Joan Ryan 5056444527 963 172 119 Eric Taylor 4197627238 741 89 119 Tami Taylor 5056449431 159 76 119 Matt Saracen 5058813720 753 193 54 George Feeny 2136699130 456 77 54 Jonathan Turner 5056833823 789 24 54 Eli Williams 4344641774 502
SQL
SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.
Queries
A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.
Insert the following records into their corresponding tables, using the MySQL CLI. Take a screenshot of a Select * command being successfully executed on each table (6 total).
Administrator
employeeNumber |
SchoolNumber |
firstname |
lastName |
phoneNumber |
officeNumber |
4 |
45 |
Albus |
Dumbledore |
2072087222 |
201 |
60 |
45 |
Minerva |
McGonagall |
2406994295 |
150 |
119 |
45 |
Percy |
Weasley |
4324061884 |
302 |
138 |
345 |
Ken |
Jeong |
5058091461 |
503 |
52 |
345 |
Jim |
Rash |
4173119531 |
654 |
16 |
345 |
John |
Oliver |
4255510706 |
321 |
25 |
93 |
Dennis |
Haskins |
5056465505 |
987 |
146 |
93 |
Hayley |
Mills |
5056443920 |
852 |
101 |
93 |
Joan |
Ryan |
5056444527 |
963 |
172 |
119 |
Eric |
Taylor |
4197627238 |
741 |
89 |
119 |
Tami |
Taylor |
5056449431 |
159 |
76 |
119 |
Matt |
Saracen |
5058813720 |
753 |
193 |
54 |
George |
Feeny |
2136699130 |
456 |
77 |
54 |
Jonathan |
Turner |
5056833823 |
789 |
24 |
54 |
Eli |
Williams |
4344641774 |
502 |
Step by step
Solved in 3 steps