Reference no: EM13947677
1. Suppose that you are a manufacturer of product ABC, which is composed of parts A, B, and C. Each time a new product is created, it must be added to the product inventory, using the PROD_QOH in a table named PRODUCT. And each time the product ABC is created, the parts inventory, using PART_QOH in a table named PART, must be reduced by one each of parts A, B, and C.
The sample database contents are shown in Table P1 in the attachment.
Given this information, answer questions a-e.
a. How many database requests can you identify for an inventory update for both PRODUCT and PART?
b. Using SQL, write each database request you have identified in Step a.
c. Write the complete transaction(s).
d. Write the transaction log, using Table 10.1 as your template.
e. Using the transaction log you created in Step d, trace its use in database recovery.
2. This problem is based on the DDBMS scenario in figure P10.1 in the attachment. Specify the minimum type(s) of operation(s) the database must support (remote request, remote transaction, distributed transaction, or distributed request) in order to perform the following operations at sites C, A and B. Please refer to the attachment for complete question.
3. What are the different types of query optimization algorithms?
4. Describe three data fragmentation strategies. Give some examples of each.
5. What is data replication, and what are the three replication strategies?
|
Invest all of your money in the stock of one firm
: If you invest all of your money in the stock of one firm.....
|
|
What is the cost of common equity
: Summerdahl Resorts' common stock is currently trading at $36 a share. The stock is expected to pay a dividend of $2.75 a share at the end of the year (D1 = $2.75), and the dividend is expected to grow at a constant rate of 7% a year. What is the cost..
|
|
What is the projects expected rate of return
: If a security plots below the security market line, it is: A project has an assigned beta of 1.24, the risk-free rate is 3.8%, and the market rate of return is 9.2%. What is the project's expected rate of return? A project with higher than average ri..
|
|
Determine the variation of temperature with position
: Write the form of the heat equation and the boundary/ initial conditions that determine the variation of temperature with position and time, T(x, t), in the pan bottom during Stage 1. Express your result in terms of the parameters qo, D, L, h, and T..
|
|
What are the different types of query optimization algorithm
: Describe three data fragmentation strategies. Give some examples of each.
|
|
Products has an issue of outstanding bonds
: Prairie Dog Products has an issue of outstanding bonds that have a 6% annual coupon, a 7 percent yield to maturity and a nine year maturity. Are these bonds selling at a premium or a discount?
|
|
Flexible exchange rate system-managed exchange rate system
: If a change in market conditions causes a currency to become overvalued, how would it adjust to equilibrium in a flexible exchange rate system? Why do some private market participants prefer a fixed exchange rate system over a flexible exchange rate ..
|
|
Problem regarding the infinite homogeneous body
: At a given instant of time, the temperature distribution within an infinite homogeneous body is given by the function
|
|
What was the amount of bayside total fixed costs
: For 2012, Bayside Corporation sold 130,000 units of its product for $35 each. The variable cost per unit was $30, and Bayside's margin of safety was 30,000 units. What was the amount of Bayside's total fixed costs?
|