question 6use the picture below to answer the following questionAdd a ZIP field/column to the customer table. CUSTOMER TableCUSTID | LNAME | FNAME | CITY| STATE | PHONEHARRISEDWARDS MITCH107PAULAOSSEOWI7155559035232WASHBURN WI7155556975133GARCIAMARIARADISSONWI7155558332154MILLERLEESILVERWI7155559002179CHANGALISASISBAYWI7155550087CUSTIDORDER TableORDERID|INVID|ORDERDATE | CUSTID| ORDER_PRICE|QUANTITY105711668 5/29/2001107259.991105711776 5/29/200110759.90211777 5/29/200111780 5/31/2001105823229.9559.95110591331106011775 5/31/200115459.902106111779 6/01/200117959.951INVIDINVENTORY TableINVID| ITEMID | ITEMSIZE | CCOLOR | CURR PRICE | QOH11668786SIENNA259.991611669786FOREST259.991211775KHAKIKHAKI29.9529.95894S1501177689414711777894LKHAKI29.9559.9512011778897STEAL15211711779897MTEAL59.9511780897LTEAL59.95125ITEMIDITEM TableITEMDI ITEMDESC| CATEGORY894WOMEN'S HIKING SHORTSWOMEN'S CLOTHINGWOMEN'S CLOTHINGMEN'S CLOTHING897WOMEN'S FLEECE PULLOVER786MEN'S EXPEDITION PARKA

Add a column in the table You can use the ALTER TABLE statement in SQL Server to add a column to a…

Answered: use the picture below to answer the…

Engineering

Computer Science

use the picture below to answer the following question Add a ZIP field/column to the customer table.

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

Q: CREATE TABLE PRODUCT (PRODUCT_ID INTEGER PRIMARY KEY, "NAME" TEXT NOT NULL, PRICE REAL NOT NULL);…

A: As per the given information, we need to write a SQL query that can be used to return the second…

Q: salary. Permanently remove the column “First Name” from the DataFrame. Do not use del. Permanently…

A: To insert a column in data frame,df['newColumn'] = df['oldColumn'] *operationTo permanently remove…

Q: Insert rows into Horse table Using MYSQL The Horse table has the following columns: ID -…

A: Find the required query to insert given data given as below :

Q: Write an anonymous block which updates the .Physician table.(As you can not update the .Physician…

A: Solution: Please find below answer of your question - Creating a physician table using the same…

Q: QUESTION 15 use the follwoing picture to answer the question Write a select statement which should…

A: Select INVENTORY.ITEM_SIZE, INVENTORY.COLOR, INVENTORY.CURR_PRICE,ORDER.ORDER_IDInner join on

Q: Question 1: Modify the select statement in this section to display the hire_date column in the…

A: SQL which refers to the domain specific that are used for the language and in the programming and…

Q: Task 5: The marketing team wants to celebrate the success of StayWell with a party. The team wants a…

A: We need to write sql query for the given scenario.

Q: best way to do it? a. Insert -> Table ICON ()-> Draw Table

A: Given: In case you wish to have a 4X8 table with variable column width and row height. What is the…

Q: List all painting titles with price greater than 5000$. How many paintings does ‘Ross Georgette’…

A: All SQL Query in step and screenshot with output

Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…

A: The record table is inserted with values . The table looks like: The TRACKS table is inserted with…

Q: Q Which of the following code will remove all the rows from the table LOCATIONS?

A: Below Is the answer for above question with detailed explanation

Q: 16. Extract first column form "list1.txt" and redirect to "table1.txt" 17. Extract second and third…

A: In the first question, we need to extract the column and redirect the same thing in the table1.txt…

Q: Task 4: The InstantRide User Satisfaction team is a core team for InstantRide, and they focus on…

A: SQL query to return the USER_ID, and the TRAVEL_TIME column which is calculated using the TIMEDIFF…

Q: Create a Frequency table to identify the Shopping Basket size using the “FREQUENCY” function and…

A: A frequency table is a table that lists items and shows how many times those items occurred.…

Q: CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY…

A: Actually, SQL is a language to operate databases in searching and filtering the data according to…

Q: In the NONCAT table, increase the length of the DESCRIPTION column to 40 characters.

A: Answer: You have to just alter the table and give the column name and its size: Syntax: ALTER TABLE…

Q: Q1: Create the following related tables using appropriate data field specification: (Hint: Define…

A: CREATE - This command is used to create a new table in the database. ALTER- This command is used to…

Q: Task 7: The StayWell marketing team considers sending small gifts to all residents and owners. To…

A: Sure, I can help you with that. The StayWell marketing team wants to send small gifts to all…

Q: Mark as unused the Category column in the BOOK_PRICING table. Check that the column is no longer…

A: The BOOK_PRICING table is a part of a database used for managing pricing information for books. One…

Q: Open the Performance query in Design view (right-click the query in the Navigation Pane, and select…

A: In this question we have to understand the given steps for the database management system Let's…

Q: use the code below to create tabels. include screenshots CREATE TABLE PRICE ( PRICE_CODE…

A: Usually, a command-line interface or database management tool is used to create tables.The steps to…

Q: If you've split a table into two separate tables, how do you rejoin the separated tables? O You…

A: Splitting a table means dividing a table into two separate tables where as rejoin means merging the…

Q: List all players for your Display the Team code and player number in a single column separated by a…

A: By changing the content in the table creation and information inserting by can achieve the solution:…

Q: To test weather a table has been modified correctly as you do these exercises, you can write and run…

A: 1. Write an INSERT statement that adds this row to the Terms table INSERT INTO Terms(terms_id,…

Q: Mark the Category field in the BOOK_PRICING table as not being used. Check to see if the field can…

A: "Category" field in the "BOOK_PRICING" table as not being used. However, you would like to determine…

Q: Which results would show if the artist table LEFT JOINed the album table? Only rows from the…

A: Given To know about the left join result for artist left join album.

Concept explainers

SQL

SQL stands for Structured Query Language, is a form of communication that uses queries structured in a specific format to store, manage & retrieve data from a relational database.

Queries

A query is a type of computer programming language that is used to retrieve data from a database. Databases are useful in a variety of ways. They enable the retrieval of records or parts of records, as well as the performance of various calculations prior to displaying the results. A search query is one type of query that many people perform several times per day. A search query is executed every time you use a search engine to find something. When you press the Enter key, the keywords are sent to the search engine, where they are processed by an algorithm that retrieves related results from the search index. Your query's results are displayed on a search engine results page, or SER.

Question

question 6

use the picture below to answer the following question

Add a ZIP field/column to the customer table.

CUSTOMER Table
CUSTID | LNAME | FNAME | CITY
| STATE | PHONE
HARRIS
EDWARDS MITCH
107
PAULA
OSSEO
WI
7155559035
232
WASHBURN WI
7155556975
133
GARCIA
MARIA
RADISSON
WI
7155558332
154
MILLER
LEE
SILVER
WI
7155559002
179
CHANG
ALISA
SISBAY
WI
7155550087
CUSTID
ORDER Table
ORDERID|INVID|ORDERDATE | CUSTID| ORDER_PRICE|QUANTITY
1057
11668 5/29/2001
107
259.99
1
1057
11776 5/29/2001
107
59.90
2
11777 5/29/2001
11780 5/31/2001
1058
232
29.95
59.95
1
1059
133
1
1060
11775 5/31/2001
154
59.90
2
1061
11779 6/01/2001
179
59.95
1
INVID
INVENTORY Table
INVID| ITEMID | ITEMSIZE | CCOLOR | CURR PRICE | QOH
11668
786
SIENNA
259.99
16
11669
786
FOREST
259.99
12
11775
KHAKI
KHAKI
29.95
29.95
894
S
150
11776
894
147
11777
894
L
KHAKI
29.95
59.95
120
11778
897
S
TEAL
152
117
11779
897
M
TEAL
59.95
11780
897
L
TEAL
59.95
125
ITEMID
ITEM Table
ITEMDI ITEMDESC
| CATEGORY
894
WOMEN'S HIKING SHORTS
WOMEN'S CLOTHING
WOMEN'S CLOTHING
MEN'S CLOTHING
897
WOMEN'S FLEECE PULLOVER
786
MEN'S EXPEDITION PARKA

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

This is a popular solution!

SEE SOLUTION Check out a sample Q&A here

Step 1

VIEW

Step 2

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 2 steps

SEE SOLUTION Check out a sample Q&A here

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

Use the data from the class assignment, ALTER TABLE and add two more columns Phone and email. Describe the table (show its structure) and drop the country column, describe the table (show structure). Now, create a new table based on the existing table person with the help of a subquery (The new table will contain the data from “person” table) and name the table person_self. Show its output (table created and its structure). NOTE: Use the ALTER TABLE command with ADD clause Use the ALTER TABLE command with DROPCOLUMN clause Use the CREATE TABLE command with AS (SELECT SUBQUERY) clause
The InstantRide User Satisfaction team requires the average and maximum number of rides users have taken so far with InstantRide. In addition, they would like to know the total number of travels. However, they need these details with the corresponding column names Average, Maximum and Total by using the AVG, MAX and SUM functions. In order to accomplish this, you will first need to create a derived table from the TRAVELS table to pass the TRAVEL_ID count to the three mathematical functions.
Task 22: KimTay Pet Supplies is considering discounting the price of all items by 10 percent. List the item ID, description, price, and discounted price for all items. Use DISCOUNTED_PRICE as the name for the computed column.
Create lookup functions to complete the summary section. In cell I6, create a formula using the VLOOKUP function to display the number of hours worked in the selected week. Look up the week number in cell I5 in the range A17:G20, and return the value in the 2nd column. Use absolute references for cell I5 and the range A17:G20.
use the code below to create tabels. include screenshots of each completed table. CREATE TABLE PRICE ( PRICE_CODE NUMBER(2,0) PRIMARY KEY, PRICE_DESCRIPTION VARCHAR2(20) NOT NULL , PRICE_RENTFEE NUMBER(5,2) CHECK (PRICE_RENTFEE >= 0), PRICE_DAILYLATEFEE NUMBER(5,2) CHECK (PRICE_DAILYLATEFEE >= 0) ); CREATE TABLE MOVIE ( MOVIE_NUM NUMBER(8,0) PRIMARY KEY, MOVIE_TITLE VARCHAR2(75) NOT NULL, MOVIE_YEAR NUMBER(4,0) CHECK (MOVIE_YEAR > 1900), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR2(50), PRICE_CODE NUMBER(2,0) CONSTRAINT MOVIE_PRICE_CODE_FK REFERENCES PRICE ); CREATE TABLE MEMBERSHIP ( MEM_NUM NUMBER(8,0) PRIMARY KEY, MEM_FNAME VARCHAR2(30) NOT NULL, MEM_LNAME VARCHAR2(30) NOT NULL, MEM_STREET VARCHAR2(120), MEM_CITY VARCHAR2(50), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER(10,2) ); PRICE: INSERT INTO PRICE VALUES (1, 'Standard', 2, 1);…
The incomplete box plot and table show some information about some marks. Use the information in the table to complete the box plot. Use the information in the box plot to complete the table.
Please help me with the syntax to create a table in Snowflake.
CREATE TABLE ARTISTS( artist_id CHAR(30), artist_name CHAR(30), artist_pop INT(5), PRIMARY KEY (artist_id)); CREATE TABLE TRACKS( track_id CHAR(30), track_name CHAR(30), duration INTL(10), tempo REAL, PRIMARY KEY (track_id)); CREATE TABLE USERS( user_id CHAR(30), user_name CHAR(30), age INT(5), nationality CHAR(30), num_track_listened INT(10), PRIMARY KEY (user_id)); CREATE TABLE RECORD( artist_id CHAR(30), track_id CHAR(30), PRIMARY KEY (artist_id, track_id), FOREIGN KEY (artist_id) REFERENCES ARTISTS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE LISTEN( user_id CHAR(30), track_id CHAR(30), PRIMARY KEY (user_id, track_id), FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (track_id) REFERENCES TRACKS); CREATE TABLE FOLLOW( user_id CHAR(30), artist_id CHAR(30), follow_date datetime, PRIMARY KEY (user_id, artist_id) FOREIGN KEY (user_id) REFERENCES USERS, FOREIGN KEY (artist_id) REFERENCES ARTISTS); According to the six table, write a single SQL…
Which result set requires a JOIN? Showing all album titles with both artist ID and album ID Showing artist names with artist_id's Showing artist_id with album title Showing all album_id's with artist names
when you do following $("table") what it will select last table from the document all tables from the document first table from the document
Create a new query in Design View that is based on the tblCoach and tblLevel table Add the LevelName field from the tblLevel table to the query design. Add the CoachFirst, CoachLast, BGCExp, and CertificationExp fields, in that order, from the tblCoach table. Use qryCoachBGCExpirations to save query. Add criteria to the BGCExp field to select records with BGCExp dates that occur on or before 12/31/2019. Save and run the query, and then close it.
CREATE TABLE consumer ( ConsumerID INT PRIMARY KEY, FirstName VARCHAR(50), LastName VARCHAR(50), Age INT, Gender VARCHAR(10), OnlineInStore VARCHAR(20)); INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (1, 'John', 'Doe', 25, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (2, 'Jane', 'Smith', 30, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (3, 'Mike', 'Johnson', 20, 'Male', 'Online');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (4, 'Sarah', 'Williams', 35, 'Female', 'In-store');INSERT INTO consumer (ConsumerID, FirstName, LastName, Age, Gender, OnlineInStore) VALUES (5, 'Chris', 'Davis', 28, 'Male', 'Online'); CREATE TABLE InStoreRetailer ( RetailerID INT PRIMARY KEY, RetailerName VARCHAR(50), StoreLayout VARCHAR(50), CustomerService…