1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
olga_2 [115]
3 years ago
9

Given the relations: STUDENT (SID, StudentName, Major, AdvisorID) ADVISOR (AdvisorID, AdvisorName, Office, Phone) such that each

student is assigned to one advisor, which of the following is true? a) SID is both a primary key and a foreign key. b) Phone is a candidate key. c) AdvisorID is a foreign key. d) Major is a candidate key. e) AdvisorName is a determinant.
Business
1 answer:
Mashutka [201]3 years ago
7 0

Answer:

C. AdvisorID is a foreign key

Explanation:

A foreign key is a field in a table (of databases that are cross related with one another) that is a primary key in/of another table. It is a link between the information in two tables of databases.

AdvisorID in the case of this question is a foreign key in the ADVISOR database but is a primary field in the STUDENT database since each student is meant to have a be assigned to an Advisor which is the main purpose of the

Cheers.

You might be interested in
Which of the following is not a function of prices in a market system? Group of answer choices Prices send signals to buyers and
Sedaia [141]

Answer:

Prices ensure an equal distribution of goods and services among consumers.

Explanation:

The price mechanism helps in the efficient allocation of resources. There are a number of functions performed by the price mechanism. Prices send signals regarding resources. An increase and decrease in prices reflect surplus and deficit.  

Price balances the demand and supply of a product. Price is inversely related to demand and positively related to the supply of a product. It is determined by the interaction of demand and supply and helps in balancing supply and demand.  

For instance, an increase in demand would increase the price, this higher price will motivate the suppliers to increase quantity supplied thus balancing demand and supply.  

Price helps in coordinating economic activities and helps buyers and sellers in decision making. However, they do not help in equal distribution of goods and services among consumers.

6 0
2 years ago
Consider a second-price, sealed-bid auction with a seller who has one unit of the object which he values at s and two buyers 1,
dybincka [34]

Answer and Explanation:

Given that this is a second price bid auction whereby the second highest bid is the price that the highest bidder pays for the item up for auction sale, so that b1>b2 then b1 gets item for the price of b2.

Truthfulness of true value is the dominant strategy here which means each player should aim to be truthful with their bid regarding their true value regardless of what other bidders are bidding. Therefore truthfulness of value is the optimal strategy with the best payoff for bidders

5 0
3 years ago
A customer buys a Brokered CD for $100,000. Upon receipt of his next account statement, the customer sees that the market value
Mnenie [13.5K]

Answer: A. interest rates have risen

Explanation:

Since the customer buys a Brokered CD for $100,000 and upon eceipt of his next account statement, he sees that there has been a reduction in the market value of the CD to $99,800.

This would occur because there has been an increase in the interest rates. On the other hand, assuming there was a reduction in the interest rate, this will lead to an increase in the market value.

5 0
2 years ago
The consumer price index (CPI) can be used to measure inflation. There are potential problems with this process though that can
DIA [1.3K]

Answer:

a. Overstates Inflation.

In the case of Mary and Bob, the CPI would have already increased but in this case the price of the minivan increased as well. This will overstate inflation because it will not measure the general rise in price alone (inflation), it will also measure the rise in price as a result of the new minivan having better features.

b. Understated Inflation

Donna's case represents an understated inflation because the quantity shrank yet the price stayed the same. This means that the price is now buying less quantity than it used to which is inflation because more dollars are now required to buy the previous amount. This was not however recorded as there was no change in price.

c. Overstates Inflation

In the case of Zach, the inflation will be overstated because Zach is no longer buying bagels and is now buying muffins so continuing to use bagels as a representative good in the basket of goods used to calculate CPI would be overstating it.

d. Accurate representation of Inflation

In Chris's case, the increase in the price of the same shoe over the years has been because of a general rise in prices and not because it is a different model. It is the same shoe and its price is rising generally so this is an accurate depiction of inflation.

6 0
3 years ago
"Which of the following is correct?
ICE Princess25 [194]

Answer: Option (B) is correct.

Explanation:

The nominal GDP is equal to the real GDP in the base year, that's why GDP deflator in the base year is equal to 100.

GDP deflator is calculated as the nominal GDP divided by the real GDP multiply by 100. It is shown as:

GDP deflator = \frac{Nominal\ GDP}{Real\ GDP} \times 100

GDP deflator would be used as the conversion factor that transformed the real GDP into nominal GDP.

5 0
3 years ago
Other questions:
  • 4. Although bananas are grown in almost one hundred countries worldwide, Ecuador and Costa Rica are among the world's largest ba
    9·1 answer
  • Assuming a normal upward-sloping supply curve and a normal downward-sloping demand curve, if the government imposes a $5 excise
    6·1 answer
  • A group of elderly men, whose government disability benefits are the sole source of income, is approached to consider an experim
    5·1 answer
  • Anne has chosen how many bagels and how many units of cream cheese she would buy this month. She has $20 to spend on these two g
    9·1 answer
  • are four fundamental resources—natural resources, capital, human resources, and entrepreneurship—that both businesses and nonpro
    7·1 answer
  • During the year, Wright Company sells 500 remote-control airplanes for $120 each. The company has the following inventory purcha
    5·1 answer
  • Gideon Company uses the allowance method of accounting for uncollectible accounts. On May 3, the Gideon Company wrote off the $2
    13·1 answer
  • Expenditures for consumer goods and services $4,565
    5·1 answer
  • Which of the following scenarios is an example of monopolistic competition?
    6·2 answers
  • Calculate the GDP using the data below (all figures are shown in millions)
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!