Lab5

docx

School

Boston University *

*We aren’t endorsed by this school

Course

669

Subject

Economics

Date

Jan 9, 2024

Type

docx

Pages

7

Uploaded by MajorMuleMaster1001

Report
1.
2. Firstly, write a subquery that selects the currency ratio, it is found by joining the store_location and Currency. Then, search for Digital Thermometer’s product_name and price in usd. Finally, multiply the price by the currency ratio to calculate the price in the local currency.
3.products less than 26 Euros Products more than 299 Euros
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
join the Product with the Currency table where the currency name is 'Euro' to get the current ratio. After that, calculate the price in Euros. Finally, using a WHERE clause that specifies the price 4. The first subquery calculates the total number of unique store locations, then counts how many different stores sell each product. 5.
6.
7. 8. Let's consider two transactions, Transaction1 and Transaction2, which are both updating the price of the same product in the Product table. T1 reads the price of a Glucometer, intending to apply a 10% discount. T2 reads the price of a Glucometer, intending to raise the price by 5$. Name US Dollar Price Glucometer $50 Bag Valve Mask $25 Digital Thermometer $250
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Transaction 1 Read the value from row 1. Multiply that value times 0.9. Write back the result. Commit. Transaction 2 Read the value from row 1. Add that value by 5. Write back the result Commit. 9. Example Deadlock Schedule Step Explanation Transaction 1: Read row 1 Transaction 1 now has a shared lock on row 1. Transaction 1 : Multiply that value times 0.9.. Transaction 2: Read row 1(attempt) Transaction 2 must wait at this step, because it is unable to obtain an exclusive lock on row 1, since Transaction 1 already has a shared lock on row 1. Transaction 1: Write back the result. Transaction 2: Read row 1 Transaction 2 now has a shared lock on row 1. Transaction 2: Add that value by 5 Transaction 2: Write back the result. A deadlock occurs when two or more transactions hold locks that the other transactions are trying to acquire and none of them can proceed. The database system would typically detect this situation and resolve the deadlock by aborting one of the transactions and rolling back its changes, allowing the other transaction to proceed.

Related Documents

Warmup #26.docx
mid2 practice(1).pdf
EC_371_HW_4_updated.pdf
EC_371_HW_3_updated.pdf
STAT 511 HW 4.pdf
Extra Credit Week 4.docx
HED unit 7 as.docx
ECON180SPRING2023Project1.pdf
Midterm Review Problems.docx
Unit 4 Touchstone .xlsb.xlsx
second midterm practice_update.pdf
MacroEcon_L03_Problems.pdf
Recommended textbooks for you
Text book image
MACROECONOMICS
Economics
ISBN:9781337794985
Author:Baumol
Publisher:CENGAGE L
Text book image
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co
Text book image
MACROECONOMICS FOR TODAY
Economics
ISBN:9781337613057
Author:Tucker
Publisher:CENGAGE L
Text book image
Economics For Today
Economics
ISBN:9781337613040
Author:Tucker
Publisher:Cengage Learning
Text book image
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Principles of Economics 2e
Economics
ISBN:9781947172364
Author:Steven A. Greenlaw; David Shapiro
Publisher:OpenStax
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
MACROECONOMICS
Economics
ISBN:9781337794985
Author:Baumol
Publisher:CENGAGE L
Text book image
Economics Today and Tomorrow, Student Edition
Economics
ISBN:9780078747663
Author:McGraw-Hill
Publisher:Glencoe/McGraw-Hill School Pub Co
Text book image
MACROECONOMICS FOR TODAY
Economics
ISBN:9781337613057
Author:Tucker
Publisher:CENGAGE L
Text book image
Economics For Today
Economics
ISBN:9781337613040
Author:Tucker
Publisher:Cengage Learning
Text book image
Survey Of Economics
Economics
ISBN:9781337111522
Author:Tucker, Irvin B.
Publisher:Cengage,
Text book image
Principles of Economics 2e
Economics
ISBN:9781947172364
Author:Steven A. Greenlaw; David Shapiro
Publisher:OpenStax
SEE MORE TEXTBOOKS