WEEK 3 ASSIGNMENT This assignment contains two parts. You must complete Part I before moving on to Part II.Part I:Using the table you previously worked on, complete the following exercise:Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns.Select a row from your student table where the last name equals "Parker". Select a row from your student table where the ZIP code is less than "68134".Select the student first and last name from the student table order by the state column. Part II:Complete the following exercise:Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.Using your student table select all students with ZIP codes between “23164” and “98164”.Using your student table select all students where states are in Florida and New York.Using your student table select all students where the last name starts with an “S” and is at least three characters in length.

Note: Since your question contain multiple question having multiple sub -part . but we can answer…

Answered: This assignment contains two parts. You…

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

See similar textbooks

Related questions

Question

100%

WEEK 3 ASSIGNMENT

This assignment contains two parts. You must complete Part I before moving on to Part II.

Part I:

Using the table you previously worked on, complete the following exercise:

Insert a row into your student table where the last name is "Parker", first name is "Sam" and the ZIP code is "68134". You can determine the values for the remaining columns.
Select a row from your student table where the last name equals "Parker".
Select a row from your student table where the ZIP code is less than "68134".
Select the student first and last name from the student table order by the state column.

Part II:

Complete the following exercise:

Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.
Using your student table select all students with ZIP codes between “23164” and “98164”.
Using your student table select all students where states are in Florida and New York.
Using your student table select all students where the last name starts with an “S” and is at least three characters in length.

Expert Solution

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

Follow-up Questions

Read through expert solutions to related follow-up questions below.

Follow-up Question

Part II:

Complete the following exercise:

Using your student table select all students that have a last name of “Parker” and have a first name that starts with “S”. Order your results by state.
Using your student table select all students with ZIP codes between “23164” and “98164”.
Using your student table select all students where states are in Florida and New York.
Using your student table select all students where the last name starts with an “S” and is at least three characters in length.

Solution

by Bartleby Expert

SEE SOLUTION

Knowledge Booster

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