Question
Answer the following questions with the mysql statement, and the answer based on the mysql statement (if applicable). Print screen the mysql prompt window for
Answer the following questions with the mysql statement, and the answer based on the mysql statement (if applicable). Print screen the mysql prompt window for each question and paste the mysql prompt window in the word document corresponding to the question. When using a PC click on (Ctrl + Alt + Prt Sc) and paste in the word document. For a MAC click on (command + shift + 4) and highlight the mysql prompt window with the mouse. The picture is saved to your desktop. Drag the picture file to the word document. Therefore each question will have its own mysql prompt as an answer. Each question is worth 1 point, unless otherwise noted.
1.Create a table named inquiry with the following fields: id (primary key), first, last, address, city, state, zip, phone, email, major, semester, and year. Create the fields with the appropriate data types and number of characters. (2 points)
2.Display the tables data structure.
3.Add the following records to the inquiry table. (2 points)
a.1 Jane Smith 1300 Madison Street Niagara Falls, NY 14108 716-285-1000 jsmith@email.com Math, Fall, 2017
b.2 Bob Newman 735 Center Street Buffalo, NY 14201 716-828-1234 bnewman@email.com Political Science, Fall, 2017
c.3 Cindy Stevens 1800 Villanova Road Blasdell, NY 14219 716-824-8225 cstevens@email.com Math, Spring, 2018
d.4 Stephanie Algert 978 14th Street Buffalo, NY 14201 716-888-7635 salgert@aol.com Hospitality, Spring, 2018
e.5 Oliver Spencer 212 Woodlawn Ave Buffalo, NY 14201 716-824-4455 aspencer@hotmail.com Biology, Fall, 2018
f.6 Susan Sping 80 Krugar Lane Buffalo, NY 14201 716-642-4354 susping@hotmail.com Biology, Spring 2018
4.List all records in the inquiry table ordered by name.
5.List only records in the inquiry table with the major math.
6.List only records in the inquiry table with the major math, and entering in Spring 2018.
7.List only name, major, year, and semester fields in the inquiry table with the city Buffalo.
8.List only name, major, year, and semester fields in the inquiry table with the city Buffalo and order the records by name.
9.Delete the record with the name Oliver Spencer.
10.List only records with the major biology.
11.Update the record with the name Cindy Stevens to have the major Biology.
12.List all records in the inquiry table with the major biology.
13.List the name and major fields in the inquiry table entering in Fall 2017, ordered by major, then name.
14.Create a new table called students with the fields id (primary number), and name.
15.Display the tables in the current database.
16.Remove the table named students.
17.Display the tables in the current database.
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