Answer the following questions with the mysql statement, and the answer based on
ID: 3825495 • Letter: A
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 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.
Explanation / Answer
<html>
<body>
<form action="servlet/Register" method="post">
Name:<input type="text" name="userName"/><br/><br/>
Password:<input type="password" name="userPass"/><br/><br/>
Email Id:<input type="text" name="userEmail"/><br/><br/>
Country:
<select name="userCountry">
<option>India</option>
<option>Pakistan</option>
<option>other</option>
</select>
<br/><br/>
<input type="submit" value="register"/>
</form>
</body>
</html>
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.