Change to use the database frozenfood Alter table customerOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table customerOrder, set column total equal to column quantity multiplied by subquery a. (select column price from table product where column productId in table customerOrder equals column id in table product) Update table customerOrder, set column orderStateld equal to subquery a. (select column id from table orderstate where state equals “Payment received") Alter table customerPayment add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)

Change to use the database frozenfood Alter table customerOrder add column total as data type decimal size 7,2, not null, default value of 0.0 Update table customerOrder, set column total equal to column quantity multiplied by subquery a. (select column price from table product where column productId in table customerOrder equals column id in table product) Update table customerOrder, set column orderStateld equal to subquery a. (select column id from table orderstate where state equals “Payment received") Alter table customerPayment add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)

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: PLZ help with the following use oracle or oracle sql live problem is in image the database CREATE…

A: The complete answer is given below.

Q: Task 4: Create a view named PROPERTY_OWNERS. It consists of the property ID, office number, square…

A: Answer is given below .

Q: CREATE SEQUENCE ORD_SEQ Increment by 10 Start with 120 Maxvalue 9999 Nocycle; CREATE TABLE…

A: Nearby answer is : 1 and 3 for, 1 : An error will occur because you cannot use SYSDATE in the…

Q: n SQL When you use ALTER TABLE to add a column, the new column: Select one: a. Will not be created…

A: ANSWER : B Becomes the last column in the table

Q: Select one of the following: (only one please) Display painters’ details who exhibit their…

A: It is defined as the collection of information that is organized so that it can be easily accessed,…

Q: 9. Find the total amount of tax paid by resident of NJ Hint: The tax cost stored in tax_amount…

A: Inner join is used to join two tables. Tax_amount column is given , to find sum value of a column.…

Q: Orders Table: OrderID,CustomerID, Order Date, TotalAmount Customers Table: CustomerID, CustomerName.…

A: In this question we have to create a query to retrieve the customer name and order date for each…

Q: List every table that contains a column named OWNER_NUM. The output table should display one column…

A: The first ever freely programmable computer came into play in 1936, however after that International…

Q: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

A: Write a SQL statement to create a foreign key in table Invoice_Detail that refers to the…

Q: DROP TABLE IF EXISTS Worker; CREATE TABLE Worker ( WORKER_ID INTEGER NOT NULL PRIMARY KEY…

A: Answer in step 2

Q: Refer to the CREATE TABLE statement: CREATE TABLE Country ( ); Name VARCHAR (50), Population INT,…

A: The question is asking to complete an SQL INSERT INTO statement to add a new row into the 'Country'…

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

Change to use the database frozenfood
Alter table customerOrder add column total as data type decimal size 7,2, not null,
default value of 0.0
Update table customerOrder, set column total equal to column quantity multiplied by
subquery
a. (select column price from table product where column productId in table
customerOrder equals column id in table product)
Update table customerOrder, set column orderStatelId equal to subquery
a. (select column id from table orderstate where state equals “Payment received")
Alter table customerPayment add column paymentDate as data type date, not null,
default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)
Insert into table customerPayment, columns customerOrderId and total result set
returned from query
a. Select columns id and total from table customerOrder where column
orderStateld is equal to subquery
i. (select column id from table orderState where column state is equal to
"Payment received")
Write Test Case 1 as a SQL join query to do the following
a. Select using concatenation of columns firstName and lastName from table
customer as Customer
b. Select customerOrderld from table customerPavment as "Customer Order"
c. Select description from table product as Product
d. Select total from table customerOrder as “Product Total"
e. Join tables customerPayment, customerOrder, customer, product
f. Order by column lastName from table customer
Alter table purchaseOrder add column total as data type decimal size 7,2, not null,
default value of 0.0
Update table purchaseOrder, set column total equal to column quantity multiplied by
subquery
a. (select column price from table product where column productld in table
purchaseOrder equals column id in table product)
Insert into table orderstate one row so that column state is equal to 'Payment sent'

Determine the total balance owed to each supplier by
a. Select column supplierld and SUM(total) from table purchaseOrder and
group by column supplierId
b. Make note of the supplierId for each supplier whose sum total is greater than
$1000
i. supplierld:
ii. supplierId:
iii. supplierId;
Update table purchaseOrder, set column orderStateId equal to subquery
a. (select column id from table orderstate where state equals "Payment sent")
3
Alter table supplierTransaction add column pavmentDate as data type date, not null,
default value of (CURRENT_DATE) (Note: the parenthesis MUST be included)
Insert into table supplierTransaction, columns purchaseOrderld and total result set
returned from query
a. Select columns id and total from table purchaseOrder where column
orderStateId is equal to subquery
i. (select column id from table orderState where column state is equal to
"Payment sent")
Write Test Case 2 as a SQL join query to do the following
a. Select supplierName from table supplier as Supplier
b. Select purchaseOrderld from table supplierTransaction as "Purchase Order"
c. Select description from table product as Product
d. Select total from table purchaseOrder as "Product Total"

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

The SQL command CREATE TABLE EMPLOYEE_BACKUP AS SELECT * FROM EMPLOYEE creates a new table named EMPLOYEE_BACKUP with the same fields and data as the EMPLOYEE table. 1) True 2) False
SQL LANGUAGE PLEASE JUST ANSWER WITHOUT EXPLANATION
question 11 please use the picture below to answer the following question Write a SQL statement to change the value of the column Invoice_Date (new_invoice table) to today's date for Customer ID 10.
The following fields are presented in the table: Member Last Name, MemberFirstName, Street, City, State, ZipCode and MemberFee. The table contains 75,000 documents. How would you build indexes for the table and why would you create these indexes?
2. Write a SQL statement to insert a new user with userId ‘XXXXX’ into the users table and populate at least 5 other columns including column userName. Note: userName column is varchar(20) and its value must be unique in the table users. DO NOT insert into the “created” column but pay attention to it’s value after the insert Paste the SQL below.
Create a table named company with these columns: Company_id varchar(255) Company_name varchar(255) default ‘x’ Hq_phone_number varchar(255) Primary key of company_id (please use constraint format) Unique key of Hq_phone_number (please use constraint format)
The SQL command CREATE TABLE EMPLOYEE_BACKUP AS SELECT * FROM EMPLOYEE creates a new table named EMPLOYEE_BACKUP with the same fields and data as the EMPLOYEE table. Question 33 options: 1) True 2) False
PLZ help with the following using ORACLE command sql Use subqueries CREATE TABLE MEMBERSHIP ( MEM_NUM CHAR(3) CONSTRAINT MEMBER_MEM_NUM_PK PRIMARY KEY, MEM_FNAME VARCHAR(30) NOT NULL, MEM_LNAME VARCHAR(30) NOT NULL, MEM_STREET VARCHAR(15), MEM_CITY VARCHAR(10), MEM_STATE CHAR(2), MEM_ZIP CHAR(5), MEM_BALANCE NUMBER (2)); CREATE TABLE RENTAL ( RENT_NUM CHAR(4) CONSTRAINT RENTAL_RENT_NUM_PK PRIMARY KEY, RENT_DATE DATE, MEM_NUM CHAR(3), CONSTRAINT RENTAL_MEM_NUM_FK FOREIGN KEY (MEM_NUM) REFERENCES MEMBERSHIP); CREATE TABLE PRICE (PRICE_CODE CHAR(1) CONSTRAINT PRICE_PRICE_CODE_PK PRIMARY KEY, PRICE_DESC VARCHAR(20), PRICE_RENTFEE NUMBER (3,1), PRICE_DAILYATFEE NUMBER(3,1)); CREATE TABLE MOVIE (MOVIE_NUM CHAR(4) CONSTRAINT MOVIE_MOVIE_NUM_PK PRIMARY KEY, MOVIE_NAME VARCHAR(30) NOT NULL, MOVIE_YEAR CHAR(4), MOVIE_COST NUMBER(5,2), MOVIE_GENRE VARCHAR(15), PRICE_CODE CHAR(1), CONSTRAINT MOVIE_PRICE_CODE_FK FOREIGN KEY (PRICE_CODE) REFERENCES PRICE); CREATE TABLE VIDEO…
Use SQL and TAL Distributors database to complete the following questions:List the number and name of each sales rep. Concatenate the FIRST_NAME and LAST_NAME columns into a single value, with a space separating the first and last name.
which type of joins is not supported by SQL Inner joins Right Joins Full Joins left joins
help please Create a table named BRANCH. The table has the following structureBRANCH_NUM decimal(2,0) NOT NULL default '0'BRANCH_NAME char(50) default NULLBRANCH_LOCATION char(50) default NULLNUM_EMPLOYEES decimal(2,0) deault NULL PRIMARY KEY (`BRANCH_NUM`) (Please type answer no write by hand)
question 5 please use the picture below to answer the following question Assuming all other tables are already created, write a SQL statement to create the following tables and the given constraint(s).