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

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
icon
Concept explainers
Question

 

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

 

Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Knowledge Booster
Query Syntax
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education