Database System Concepts
7th Edition
ISBN: 9780078022159
Author: Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Please write a query for dvdrental
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps
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
- Please help and break down all the steps I should take in order to succesfully complete the query. Create the following query in access: a. The company has been informed that the tax has been increased to 17.5%. Calculatehow much additional tax (i.e., the difference) the store would have collected by year.Name this query Q3 – ADDED-TAX.arrow_forwardUpdate table purchaseOrder, set column orderStateld equal to subquery a. (select column id from table orderstate where state equals "Payment sent") 3 Alter table supplierTransaction add column paymentDate as data type date, not null, default value of (CURRENT_DATE) (Note: the parenthesis MUST be included) Insert into table supplierTransaction, columns purchaseOrderId and total result set returned from query a. Select columns id and total from table purchaseOrder where column orderStateld 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" e. Join tables şupplierTransaction, purchaseOrder, supplier, product f. Order by column…arrow_forwardWrite a query to list the details of all authors born in the decade of the 1980s.arrow_forward
- Write an SQL query that will select OrderID and OrderDate from theOrders table and OrderDetailID from the OrderDetails table. The queryshould join on the Orders table using the OrderID attribute.arrow_forwardIn the BOOK_PRICING database, the Category field should be marked as obsolete. Make sure the column has been marked as unavailable.arrow_forwardCreate a View to show the city name of any location that has a department. Only show the city name once in the results. You must use a non-correlated subquery.Call this view: Department_LocationsInclude a second query to display from the View after it is created. Refer to the attached for the table.arrow_forward
- From invoices table, write a query to retrieve everything (all columns), plus, add an additional column that retrieves difference in the number of days between the invoice due date and paymentdate, and name the column “Difference”. Note that the difference in days should be calculated bysubtracting “payment_date” from “invoice_due_date”.Hint1, refer to the following sample:... Invoice Due Date Payment Date Difference... 2018-05-08 2018-05-07 1... 2018-05-10 2018-05-14 -4... 2018-05-13 2018-05-09 4Hint 2: simple subtraction or DATEDIFF function. Both works.arrow_forwardRewrite the query below to also show INDATE as [Stock Date]: SELECT PRODUCT.P_CODE, PRODUCT.P_DESCRIPT AS DESCRIPTION, PRODUCT.P_PRICE AS [Unit Price], PRODUCT.P_QOH AS QTYFROM PRODUCT; 2) Add ORDER BY INDATE DESC to the above query. 3) Rewrite the query below to show only products with a discount: SELECT PRODUCT.P_DESCRIPT, PRODUCT.P_QOH, PRODUCT.P_PRICE, [P_PRICE]*[P_Qoh] AS Expr1FROM PRODUCT;arrow_forwardQuestion #10.Write a query to retrieve invoice_number, invoice_date, and “Balance Due” from the invoices table.Balance Due can be calculated by subtracting payment and credit from the original invoicedamount. Make sure to only select rows with positive “Balance Due” and sort the results basedon Balance Due. Refer to the sample result screen below.arrow_forward
- Insert at least three rows into your EMPLOYEE_xx table. Use the next value of the sequence you created , EMPL_SEQUENCE_xx as the value for the employee ID for every row inserted. You may choose values for the other columns Test your constraint on the rate column by trying to update a row in the EMPLOYEE_xx table with the value of 6 used for the Pay Rate (you choose the row). Drop your EMPLOYEE_xx table and make sure it HAS been purged from the recyclebinarrow_forwardFrom vendors table, write a query to retrieve records as follows: On the first column, add vendorcontact first name, a space, and vendor contact last name. Name the first column “Vendor ContactFull Name”. On the second column, retrieve the total number of characters of the “Vendor ContactFull Name” column. Do NOT count the space in between first name and last name. Name thesecond column “Full Name Length”.The two columns should look like this:Vendor Contact Full Name Full Name LengthJinsoo Yeo 9Hint1: CONCAT and CHAR_LENGTH functions might be useful!Hint2: the number of characters for Francesco Alberto is 16.arrow_forwarduse the following picture to answer question below question 10 Insert below record to the Customer table. Assuming there is a Default Constraint on the City column, insert default value of Default Constraint. Insert Null values for State and Phone columns. CustID: 180 LName: Pourhadi FName: Farhadarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database System ConceptsComputer ScienceISBN:9780078022159Author:Abraham Silberschatz Professor, Henry F. Korth, S. SudarshanPublisher:McGraw-Hill EducationStarting Out with Python (4th Edition)Computer ScienceISBN:9780134444321Author:Tony GaddisPublisher:PEARSONDigital Fundamentals (11th Edition)Computer ScienceISBN:9780132737968Author:Thomas L. FloydPublisher:PEARSON
- C How to Program (8th Edition)Computer ScienceISBN:9780133976892Author:Paul J. Deitel, Harvey DeitelPublisher:PEARSONDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781337627900Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningProgrammable Logic ControllersComputer ScienceISBN:9780073373843Author:Frank D. PetruzellaPublisher:McGraw-Hill Education
Database System Concepts
Computer Science
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:McGraw-Hill Education
Starting Out with Python (4th Edition)
Computer Science
ISBN:9780134444321
Author:Tony Gaddis
Publisher:PEARSON
Digital Fundamentals (11th Edition)
Computer Science
ISBN:9780132737968
Author:Thomas L. Floyd
Publisher:PEARSON
C How to Program (8th Edition)
Computer Science
ISBN:9780133976892
Author:Paul J. Deitel, Harvey Deitel
Publisher:PEARSON
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781337627900
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Programmable Logic Controllers
Computer Science
ISBN:9780073373843
Author:Frank D. Petruzella
Publisher:McGraw-Hill Education