Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Processing Fundamentals, Design, and Implementation

Authors: David M. Kroenke, David J. Auer

14th edition

133876705, 9781292107639, 1292107634, 978-0133876703

More Books

Students also viewed these Databases questions

Question

What are Measures in OLAP Cubes?

Answered: 1 week ago

Question

How do OLAP Databases provide for Drilling Down into data?

Answered: 1 week ago

Question

How are OLAP Cubes different from Production Relational Databases?

Answered: 1 week ago