Please do the following sql script,13 create a view over the product, salestransaction, includes, customer, store, region tableswith columns: tdate, productid, productname, productprice, quantity, customerid, customername,storeid, storezip, regionnamecreate view 13;-- 14 Using the view created in question 13Display ProductID, ProductName, ProductPricefor products sold in zip code "60600" sorted by ProductIDselect 14;15 Using the view from question 13display CustomerName and TDate for any customer buying a product "Easy Boot"select 15;-- 16 Using the view from question 13display RegionName and total amount of sales in each region as "AmountSpent"select 16;This is the tablePRODUCTVENDORProductIDProductPriceProductNameVendorID (FK)CategoryID (FK)VendorIDVendorNameREGIONRegionIDRegionNameCATEGORYCategoryIDCategoryNameSTOREINCLUDESStoreIDStoreZipRegionID (FK)ProductID (FK)TID (FK)QuantityCUSTOMERSALES TRANSACTIONCustomerIDTIDCustomerNameTDateCustomerZipStoreID (FK)CustomerID (FK)

Dear Student, As per guidelines, I can answer only the first question. Please re-post your other…

-- 13 create a view over the product, salestransaction, includes, customer, store, region tables with columns: tdate, productid, productname, productprice, quantity, customerid, customername, storeid, storezip, regionname create view 13;

-- 13 create a view over the product, salestransaction, includes, customer, store, region tables with columns: tdate, productid, productname, productprice, quantity, customerid, customername, storeid, storezip, regionname create view 13;

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: how can I create create 5 ALTER Table Statements for the Homework Database. The Collection of…

A: We will work on the Region table ALTER table statements Before using Alter ADD command Alter…

Q: Create a view named myView_757 (last 3 digits of your student number) That view should display…

A: create table and insert all the data CREATE TABLE employees ( employee_id NUMBER GENERATED BY…

Q: how can I CREATE Two SQL CREATE VIEW Statements. One of the CREATE VIEW Statements must use two…

A: CREATE A VIEW TO ADD TWO TABLES LIKE: region, StateOfRegion Create view [viewRegionjoined] as select…

Q: use the query to create a table exactly like the first photo but it said ERROR: Load into table…

A: It is defined as a request for data results, and for action on data. You can use a query to answer a…

Q: 2. Create a table named sizeTvpe with the following attributes, data types, and constraints: a. ID,…

A: 2)CREATE TABLE sizeType ( ID INT NOT NULL AUTO INCREAMENT, size varchar(20) NOT NULL, PRIMARY…

Q: What command can be used to modify a view?

A: In a database,a view is a virtual table containing the result-set of an SQL query. A view also has…

Q: ITEM (ITEM ID, DESCRIPTION, ON HAND, CATEGORY, LOCATION, PRICE, NUM, INVOICE _ DATE, CUST PRICE))…

Q: a view named "allOrders" containing all the retail order information of whose status is 'on hold'…

A: Program Approach: 1- The main advantage of the view, it contains a subset of the information.2-…

Q: Create a query to add a column P to an existing view named view1 having columns (M,N,O) from the…

A: Create a MySQL query to add a column P to an existing view named view1 having columns (M, N, O) from…

Q: Task 1: Create a LARGE_PROPERTY table with the structure shown below. 1 LARGE_PROPERTY table…

A: TASK 01: CREATE TABLE LARGE_PROPERTY ( OFFICE_NUM DECIMAL(2) NOT NULL,…

Q: Use the appropriate MySQL command to view the structure of the user table

A: SQL (Structured Query Language) is a standard programming language that used to manage relational…

Q: Requirement 2 Write SQL DROP statements that will drop all the tables. Add these statements to the…

A: Approach Start Create a table worker Add columns in the worker table Create a table task Add…

Q: Need help with this Task 1 Create a table named REP. The table has the same structure as the…

A: As per Bartleby rules we can answer the first 3 questions at a time.So I have answered Task 1, 2 and…

Q: Task 17: List the invoice number and invoice date for each invoice that was created for James…

A: We need to provide a query that lists the invoice number and invoice date for each invoice that was…

Q: Create relationships between the tables. Create Form to enter, update, delete user data from the…

A: /* one-to-one: User has one address */ CREATE TABLE addresses ( user_id int, -- Both a primary…

Q: Create a View to show the city name of any location that has a department. Only show the city name…

A: Introduction: A SQL database, often known as a relational database, is made up of a number of highly…

Q: Task 10 Task 10: List all the tables contained within the system catalog, but only display the…

A: Task 10: SELECT * FROM (SELECT table_name FROM all_tables ORDER BY table_name ) WHERE ROWNUM <=…

Q: te and populate a table named Current_Enrollment that contains the student_id and a column whose…

A: create table Current_Enrollment(Student_ID number(8,0), Enroll course_Table_T, final grade null)…

Q: 2. Create a view named Top10PaidInvoices that returns three columns for each vendor: VendorName,…

A: A view in SQL is a virtual representation of a table based on the result-set from an SQL statement…

Q: 6. Create a list of all book titles and costs. Precede each book’s cost with asterisks so that the…

A: A function is a self-contained block of statements. A function can take one or more parameters and…

Q: Explain the factors that need to be considered for creating an index on a specific table column.

A: Indexing is a fundamental database optimization technique used to improve query performance. It…

Q: Compare between the following: Temporary table vs. View Assertion vs. Triggers

A: 1. Temporary Table vs. View:Temporary Table: As mentioned before, a temporary table is a storage…

Q: 1. Use Design view to create a new table. Add AccountType as the first field name, with data type…

A: Note: - As per our guidelines we can only answer one question at a time. Please resubmit the other…

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

Please do the following sql script,
13 create a view over the product, salestransaction, includes, customer, store, region tables
with columns: tdate, productid, productname, productprice, quantity, customerid, customername,
storeid, storezip, regionname
create view 13;
-- 14 Using the view created in question 13
Display ProductID, ProductName, ProductPrice
for products sold in zip code "60600" sorted by ProductID
select 14;
15 Using the view from question 13
display CustomerName and TDate for any customer buying a product "Easy Boot"
select 15;
-- 16 Using the view from question 13
display RegionName and total amount of sales in each region as "AmountSpent"
select 16;
This is the table
PRODUCT
VENDOR
ProductID
ProductPrice
ProductName
VendorID (FK)
CategoryID (FK)
VendorID
VendorName
REGION
RegionID
RegionName
CATEGORY
CategoryID
CategoryName
STORE
INCLUDES
StoreID
StoreZip
RegionID (FK)
ProductID (FK)
TID (FK)
Quantity
CUSTOMER
SALES TRANSACTION
CustomerID
TID
CustomerName
TDate
CustomerZip
StoreID (FK)
CustomerID (FK)

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

Step 3

VIEW

Trending now

This is a popular solution!

Step by step

Solved in 3 steps with 2 images

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

14. How many records are created when you apply a Cartesian join (Cross join) to the invoice and invoice items table? 1. The following diagram is a depiction of what type of join? a. Inner Join b. Full outer join C. Left join d. Right join 16. Select which of the following statements are true regarding inner joins. (Select all that apply) a. There is no limit to the number of table you can join with an inner join. b. Performance will most likely worsen with the more joins you make Inner joins retrieve all matching and nonmatching rows from a table d. Inner joins are one of the most popular types of joins use 17. Which of the following is true regarding Aliases? (Select all that apply.) a. Aliases are often used to make column names more readable b. SQL aliases are used to give a table, or a column in a table, a temporary name. An alias only exists for the duration of the query. 18. What is wrong with the following query? SELECT Customers.CustomerName, Orders.OrderID FROM LEFT JOIN ON…
Please give me correct solution.
Task 19: List every table that you have created thus far. Display the TABLE_SCHEMA and TABLE_NAME columns. Task 20: List every column in the ITEM table and its associated data type.
Open the Missing Addresses query in Design view. Add a new column to determine if a customer does not have an address on file. If the customer’s Address is null, it should display Missing. If not, it should display nothing. Name the column AddressPresent. Add criteria of Missing to the column you just created, so only the customers missing an address display. Move the AddressPresent field so it appears between PhoneNumber and Address. Run the query. Ensure only customers with null Address fields display. Save and close the query.
Which of the following is the valid syntax for creating a VIEW to view a subset of a table? CREATE VIEW USA_customersASSELECT *FROM customerWHERE country = 'USA'; CREATE VIEW USA_customersSELECT *FROM customerWHERE country = 'USA'; CREATE VIEW USA_customersAS customerWHERE country = 'USA'; CREATE VIEW USA_customersAS customerSELECT *WHERE country = 'USA';
For this assignment, write SQL code based on the tables provided. Create three tables Tables -1.Customer 2.Flower 3.Order Decide what fields, field lengths, and datatypes you need. Do this for each of the 3 tables. Only use VARCHAR2, NUMBER, and DATE datatypes. Assign a primary key to one field in each table Provide the code to insert the records into each of the tables in the database.
Use UStayWell Student Accommodation Database to answer the following questions A. Create a view named MAJOR_CUSTOMER. It consists of the customer ID, first name, last name,balance, credit limit, and rep ID for every customer whose credit limit is $500 or less.Write and execute the CREATE VIEW command to create the MAJOR_CUSTOMER view. B. Write and execute the CREATE VIEW command to create the ITEM_INVOICE view. C. List all the views contained within the system catalog.