All categories

3 years ago

The DDBMS Scenario

Computers and Technology

1 answer:

OlgaM077 [116]3 years ago

5 0

Answer and Explanation:

At C:

a.) This SQL sequence represents a remote request.

b.) This SQL sequence represents a remote request.

c.)This SQL sequence represents a distributed request. Note that the distributed request is required when a single request must access two DP sites. The PRODUCT table is composed of two fragments, PRO_A and PROD_B, which are located in sites A and B, respectively.

d.)This SQL sequence represents a distributed request.

Note that UPDATE CUSTOMER and the two INSERT statements only require remote request capabilities. However, the entire transaction must access more than one remote DP site, so we also need distributed transaction capability. The last UPDATE PRODUCT statement accesses two remote sites because the PRODUCT table is divided into two fragments located at two remote DP sites. Therefore, the transaction as a whole requires distributed request capability.

e.)This SQL sequence represents a distributed transaction. Note that, in this transaction, each individual request requires only remote request capabilities. However, the transaction as a whole accesses two remote sites. Therefore, distributed request capability is required.

At A:

f.)This SQL sequence represents a distributed request. Note that the request accesses two DP sites, one local and one remote. Therefore distributed capability is needed.

g.)This SQL sequence represents a remote request, because it accesses only one remote DP site.

h.)This SQL sequence represents a distributed request. In this case, the PRODUCT table is partitioned between two DP sites, A and B. Although the request accesses only one remote DP site, it accesses a table that is partitioned into two fragments: PROD-A and PROD-B. A single request can access a partitioned table only if the DBMS supports distributed requests.

At B:

i.)This SQL sequence represents a remote request.

j.)This SQL sequence represents a distributed request.

k.)This SQL sequence represents a distributed request. (See explanation for part h.)

You might be interested in

Green computing can be achieved by: a. using video conferencing, electronic meeting systems, and groupware. b. replacing meeting

Rama09 [41]

Answer: using video conferencing, electronic meeting systems, and groupware

Explanation:

Green computing simply means the use of computer in a way that's environmental friendly.

One way to achieve this is through using video conferencing, electronic meeting systems, and groupware. This allows the use of computers not to have a negative effect on the environment.

4 0

3 years ago

Bill's manager has asked him to send all staff members the directions for checking out the new projector. In 1–2 sentences, desc

Alex787 [66]

He should send an email to all of his colleagues to inform them of all of the directions. Emails are an easy and fast route to letting people know what's up.

- Mabel <3

6 0

3 years ago

Read 2 more answers

Write a method that takes a RegularPolygon as a parameter, sets its number of sides to a random integer between 10 and 20 inclus

Sergio [31]

Answer:

import java.lang.Object

import java.lang.Math

public class RegularPolygon extends java.lang.Object{

public void randomize(RegularPolygon c){

int min = 10, max1 = 20;

double min1 = 5, max1 = 12;

double range = (max - min) + 1;

double range1 = (max1 -min1) + 1

int side = (Math.random() * range) + min;

double len = (Math.random() * range1) + min1;

c.setNumSides(side);

c.setSideLength( len);

}

public static void main(String[] args) {

RegularPolygon r = new RegularPloygon();

randomize(r);

}

Explanation:

The randomize method accepts a regular polygon class as its only parameter and assigns a random number of sides and the length of these sides with the 'Math.random' function.

5 0

3 years ago

You need to write a menu driven program. The program allows a user to enter five numbers and then asks the user to select a choi

Jobisdone [24]

Answer:

In Python:

nums = []

for i in range(5):

num = int(input("Num: "))

nums.append(num)

print("1 - Smallest")

print("2 - Largest")

print("3 - Sum")

print("4 - Average")

menu = int(input("Select menu: "))

if menu == 1:

print("Smallest: ",min(nums))

elif menu == 2:

print("Largest: ",max(nums))

elif menu == 3:

isum = 0

for i in range(5):

isum+=nums[i]

print("Sum: ",isum)

elif menu == 4:

isum = 0

for i in range(5):

isum+=nums[i]

print("Average: ",isum/5)

else:

print("Invalid Menu Selected")

Explanation:

This program uses a list to get inputs for the 5 numbers

Here, the list is initialized

nums = []

This iterates from 1 to 5

for i in range(5):

This gets input for the 5 numbers

num = int(input("Num: "))

This appends each number to the list

nums.append(num)

The next 4 lines represents the menu

print("1 - Smallest")

print("2 - Largest")

print("3 - Sum")

print("4 - Average")

This prompts the user for menu

menu = int(input("Select menu: "))

If menu is 1, print the smallest

if menu == 1:

print("Smallest: ",min(nums))

If menu is 2, print the largest

elif menu == 2:

print("Largest: ",max(nums))

If menu is 3, calculate and print the sum of all inputs

elif menu == 3:

isum = 0

for i in range(5):

isum+=nums[i]

print("Sum: ",isum)

If menu is 4, calculate and print the average of all inputs

elif menu == 4:

isum = 0

for i in range(5):

isum+=nums[i]

print("Average: ",isum/5)

If menu is not 1 to 4, then print invalid menu

else:

print("Invalid Menu Selected")

3 0

3 years ago

A common problem in record systems is inaccurate classification of records as they are created and revised. a. True b. False

Mashcka [7]

Answer:

True.

Explanation:

The whole point of keeping records is to be able to check back on them at a later time. This is why records are kept in such a way/in such an order that it would be absolutely easy to locate them when required.

Inaccurate classification defeats the whole purpose of record keeping as it makes it hard (impossible at times) to locate such record that has been mistakenly classified.

7 0

4 years ago