Questions
Consider the “index calculation” problem we have studied in the class (see lecture note), where we...

Consider the “index calculation” problem we have studied in the class (see lecture note), where we have a relation of 8,000,000 tuples. Again, make the following assumptions:

  • the size of disk block (also called disk page): it is usually 4K or 8K bytes, to make our calculation easier, we will use 4000 bytes as a block size
  • the size of the search key value: say we index the relation by using an attribute that is part of the primary key, and it is 40 byte string
  • the size of physical page addresses: this is needed since every node in the tree will store search key values as well as references to disk pages, i.e., the address of the disk page being referenced. For ease of calculation, we use a 10-byte page address
  • each swap takes about 10 milliseconds
  1. For this relation, calculate how long it will take to find a particular record if we use dense index, as

described by databaseSystems-71-indexing, page 2? [16 points]

  1. Consider again the situation in question 1, with the same dense index, but add one extra level of sparse index, as described by databaseSystems-71-indexing, page 5 – 6. Now, how long it will take to find one particular record? [16 points]

In: Computer Science

What should be legal guidelines for any new nanny agency business relating to arbitration and lawsuits...

What should be legal guidelines for any new nanny agency business relating to arbitration and lawsuits if the nannies would be independent contractors? This is for safety of nannies.

In: Operations Management

find 10 quotes of psychological events that take place in chapters 17-24 in scarlet letter

find 10 quotes of psychological events that take place in chapters 17-24 in scarlet letter

In: Psychology

hare an ethical and/or legal experience you have encountered in work, or may expect to encounter...

hare an ethical and/or legal experience you have encountered in work, or may expect to encounter in your work.

If you were the person in charge, how would you have responded to the situation and why?

In: Operations Management

Westpac City-Bay Fun Run is an annual fund-raising event that started in Adelaide in November of...

Westpac City-Bay Fun Run is an annual fund-raising event that started in Adelaide in November of 1973. The main purpose of the event is to raise funds to support the athletic community of South Australia and to support local athletes and clubs while also engaging in a fun and friendly competition. From its humble origins, the event grew each year and last year the run raised over 350,000 AUD. It is a popular event, supported by many local firms and individuals alike and entry fees range from 25 dollars to 60. Despite the event being organized for September 2020, the organizers are already thinking about 2021 and how to make the event even bigger.There are three main types of marketing research that were discussed in the week 4 lecture (exploratory, descriptive, and causal). Imagine that you have joined the board of directors for the City-Bay Fun Run as a Market Research Advisor. Explain to the Board the three types of research they could do before the 2021 run and give examples of how and where primary and secondary data could be collected and used to improve the event. Explain the relevance of primary and secondary data to the Board. (400 words essay)

In: Operations Management

Diego Company manufactures one product that is sold for $81 per unit in two geographic regions—the...

Diego Company manufactures one product that is sold for $81 per unit in two geographic regions—the East and West regions. The following information pertains to the company’s first year of operations in which it produced 52,000 units and sold 47,000 units.

Variable costs per unit:
Manufacturing:
Direct materials $ 20
Direct labor $ 20
Variable manufacturing overhead $ 4
Variable selling and administrative $ 6
Fixed costs per year:
Fixed manufacturing overhead $ 936,000
Fixed selling and administrative expense $ 552,000

The company sold 35,000 units in the East region and 12,000 units in the West region. It determined that $260,000 of its fixed selling and administrative expense is traceable to the West region, $210,000 is traceable to the East region, and the remaining $82,000 is a common fixed expense. The company will continue to incur the total amount of its fixed manufacturing overhead costs as long as it continues to produce any amount of its only product.

a.  What is the unit product cost under variable costing?

b. What is the unit product cost under absorption costing?

c. What is the company’s total contribution margin under variable costing?

d. What is the company’s net operating income (loss) under variable costing?

In: Accounting

Write CORRECT c code to execute the following command >grep csc411 file.txt | sed s/411/414/g.

Write CORRECT c code to execute the following command

>grep csc411 file.txt | sed s/411/414/g.

In: Computer Science

What is value and how is it determined and measured? In your opinion, does business generally...

What is value and how is it determined and measured? In your opinion, does business generally determine and measure value appropriately? In a free market, what happens when value is not properly assessed by a business and its leaders? Give a historical example and your thoughts about how and why a disconnect occurred. Cite any sources used to support your answer.

In: Operations Management

●With so much work being done by work teams; in what ways can self-disclosure improve team...

●With so much work being done by work teams; in what ways can self-disclosure improve team performance?

●How does trust impact organizations? How can untrustworthy members impact an entire organization? How can organizations ensure members will be trustworthy?

except the answer of

Helps others know our work style, habits, preferences, strengths, etc. Disclosure leads to trust. Trust may be the largest single factor separating effective from ineffective work teams. By demonstrating your willingness to give information, others are likely to reciprocate. When this information contains performance feedback, team members are able to improve their performance individually and collectively. Recent examples of corporate scandals or bankruptcies help to illustrate how trust impacts organizational members and all primary and secondary stakeholders. Discuss means for organizations to regain trust with stakeholders and the general public.

In: Operations Management

Identify the types of digital marketing. Give examples of each.

Identify the types of digital marketing. Give examples of each.

In: Operations Management

management: You discovered your personal conflict management style as a class activity. Name your style and...

management:

You discovered your personal conflict management style as a class activity. Name your style and describe one characteristic of the style that best reflects you and explain what degree of assertiveness and/or cooperativeness is associated with that style .

In: Operations Management

There is a 95.05% chance the project below can be completed in X days or less....

There is a 95.05% chance the project below can be completed in X days or less. What is X? In the space provided below type in the values for each activity’s expected time, variance, list of critical activities, Project duration and value of X. Draw the network diagram

1. Expected value for each activity: BLANK-1

2. Variance for each activity: BLANK-2

3. Critical activities: BLANK-3

4. Project duration: BLANK-4

5. X = BLANK-5

ACTIVITY PREDECESSORS OPTIMISTIC (DAYS) Most likely(days) pessimistic (days)
A NONE 1 4 7
B NONE 2 2 2
C A 2 5 8
D A 3 4 5
E B,C 4 6 8
F B,C 0 0 6
G D,E 3 6

9

In: Operations Management

suppose that you heard a famous author say, " Computer games are primarily for telling stories"....

suppose that you heard a famous author say, " Computer games are primarily for telling stories". Whether you agree or disagree with him, and explain why?

Solution plz?

In: Computer Science

“The start of many mental health conditions most often occurs in adolescence. Half of individuals living...

“The start of many mental health conditions most often occurs in adolescence. Half of individuals living with mental illness experience onset by the age of 14. This number jumps to 75% by the age of 24. One in five youth live with a mental health condition, but less than half of these individuals receive needed services. Undiagnosed, untreated or inadequately treated mental health conditions can affect a student’s ability to learn, grow and develop. Schools provide a unique opportunity to identify and treat mental health conditions by serving students where they already are” (National Alliance On Mental Illness, 2017).

Please post a brief (1-2 paragraph) response to this quote. Do you believe that schools could or should play a significant role in supporting the mental health of students? Why or why not? Additionally, be sure to address the benefits to addressing the mental health needs of children in schools? And what are the challenges?

In: Psychology

Based on the following data and using a 365-day year: 12/31/Year 1 accounts receivable $ 100,000...

Based on the following data and using a 365-day year:

12/31/Year 1 accounts receivable $ 100,000
12/31/Year 2 accounts receivable 70,000
For the year ended 12/31/Year 1, net sales 1,050,000
For the year ended 12/31/Year 2, net sales 1,200,000

a. Compute the accounts receivable turnover. Round your answer to two decimal places.

b. Compute the number of days' sales in receivables for year 2. Round your answer to two decimal places.
days

c. The industry average turnover is 20 times during the year, and the number of days' sales in receivables averages 25. How does this situation compare to the industry average?

Is it slightly better or slightly worse than the average?

In: Accounting