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
exis [7]
3 years ago
12

Write the following as triggers. In each case, disallow or undo the modification if it does not satisfy the stated constraint. T

he problems are based on our running movie example:
Movies(title, year, length, genre, studioName, producerC#)
StarsIn(moveTitle, moveYear, starName)
MovieStar(name, address, gender, birthdate)
MovieExec(name, address, cert#, netWorth)
Studio(name, address, presC#)

You may assume that the desired condition holds before any change to the database is attempted. Also, prefer to modify the database, even if it means inserting tuples with NULL or default values, rather than rejecting the attempted modification.

a. Assure that at all times, any star appearing in StarsIn also appears in MovieStar.
b. Assure that at all times every movie executive appears as either a studio president, a producer of a movie, or both.
c. Assure that every movie has at least one male and one female star.

Business
1 answer:
Kruka [31]3 years ago
4 0

Answer:

Please see attachment

Explanation:

Please see attachment

You might be interested in
Pure monopoly refers to Multiple Choice any market in which the demand curve for the firm is downsloping. a standardized product
skelet666 [1.2K]

Answer:

a single firm producing a product for which there are no close substitutes.

Explanation:

A pure monopoly is a single supplier having a market or industry i.e. defined. The firm should be considered as an industry also in this there is no competitor or any subsitution existed. It can be arise at the time when the market share of the one firm is more than 90%

So as per the given situation, the above represent the answer

5 0
2 years ago
On november 1, 2018, the bagel factory signed a $100,000, 6%, six-month note payable with the amount borrowed plus accrued inter
Salsk061 [2.6K]

Answer:

A) debit interest expense, $1000

Explanation:

to determine the accrued interest expense = $100,000 x 6% x 2/12 = $1,000

the journal entry should be:

December 31, 2018, accrued interest expense on note payable:

Dr Interest expense 1,000

    Cr Accrued interest payable 1,000

Accrual accounting establishes that expenses must be recognize during the period that they occur regardless of when they are paid. So we must recognize 2 months worth of interest.

6 0
3 years ago
Suppose Cook Plus manufactures cast iron skillets. One model is a​ 10-inch skillet that sells for $ 24. Cook Plus projects sales
ioda

Answer:

Production= 750 units

Explanation:

Giving the following information:

Cook Plus projects sales of 675 ​10-inch skillets per month.

Cook Plus has 60 ​10-inch skillets in inventory at the beginning of July but wants to have an ending inventory equal to 20​% of the next​ month's sales.

TO calculate the production required, we need to use the following formula.

Production= sales + desired ending inventory - beginning inventory

Production= 675 + (0.2*675) - 60

Production= 750 units

4 0
3 years ago
When consumers are characterized as preservers, makers, takers, changers, seekers, or escapers, this is because these reflect th
Nimfa-mama [501]

When consumers are characterized as preservers, makers, takers, changers, seekers, or escapers, this is because these reflect their "view of society."

<h3>What is economic sociology?</h3>

Economic sociology is the study of the manufacturing, distribution, transfer, and consumption of products and services using sociological concepts and methods.

Some key features regarding the economic sociology are-

  • Economic sociology is especially concerned with the connections between economic activity and the rest of society, as well as changes in the organizations that contextualize as well as condition economic activity.
  • Although traditional economic analysis begins with the atomistic individual, economic sociology typically starts with groups or entire societies, which it opinions as existing independently of it and partially comprising the individual.
  • When economic sociologists focus on individuals, it is usually to investigate how their mutual interests, beliefs, as well as motivations to act are formed through their interactions.

To know more about the economic sociology, here

brainly.com/question/27896828

#SPJ4

4 0
1 year ago
You invest all the money you earned during your summer sales job (a total of $45,000) into the stock of a company that produces
erica [24]

Answer:

The annual rate of return of the invesment will be -14,97%

Explanation:

The initial investment is 45.000 and after 5 years the value of the investment is only 20.000. Here we can see a destruction of value (20.000 < 45.000). In finance, the time takes an essential part in calculation, so through the interest rate we calculated how bad was the investment in annual terms. The formula is as follows: Final investment value=(Initial investment*(1+interest rate)^(total years)) in our case would be: 20.000=(45.000*(1+interest rate)^(5)) From this formula we got -14,97%

8 0
3 years ago
Other questions:
  • In 2019, Jose paid the following amounts for his son to attend Big State University: Tuition $15,000 Room and board 10,500 Books
    15·1 answer
  • How does lack of a good transportation system cause labour inefficiency (economics)
    9·1 answer
  • What percent of all businesses in the United States are corporations, and they account for 80% of the total business dollars gen
    15·1 answer
  • Why do people tend to eat more at all-you-can-eat buffet restaurants than at restaurants where each item is purchased separately
    10·1 answer
  • Between _________, it is estimated that Spanish America produced 150,000 tons of silver (including gold converted into silver we
    6·1 answer
  • What is pure competition?
    14·2 answers
  • The labor demand curve shows how many workers the firm is willing to hire Group of answer choices at any given wage. into high-s
    5·1 answer
  • . If Carissa Dalton has a $130,000 home insured for $100,000, based on the 80 percent coinsurance provision, how much would the
    11·1 answer
  • In the water and rocks analogy for JIT:
    13·1 answer
  • Name three types of financial payment methods for labour services.
    15·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!