Business, 13.01.2020 20:31 quay39

Write the following as triggers. in each case, disallow or undo the modification if it does not satisfy the stated constraint. the 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.

Answers: 1

Show answers

Another question on Business

Business, 21.06.2019 12:30

Trinity trucking signs a contract with olsen oil to purchase all of the fuel for its fleet of trucks for the next year from olsen at a price of $3.00 per gallon. at the time trinity and olsen sign the contract, the market price for gasoline was $3.25 per gallon, and trinity had an expert report predicting that the price would rise to at least $4.25 per gallon in the upcoming six months. instead, the price dropped to $2.00 per gallon. may trinity rescind the contract with olsen due to its mistaken belief about the future of the price of gasoline?

Answers: 2

Answer

Business, 22.06.2019 11:50

What is marketing’s contribution to the new product development team? a. technical expertise needed to translate designs into an actual product/service. b. deep customer insight that leads to product ideas. c. ability to assess financial viability d. feedback on design as well as how customers will actually use the product e. technical expertise needed to translate concepts into product/service designs.

Answers: 2

Answer

Business, 22.06.2019 13:30

On january 2, well co. purchased 10% of rea, inc.’s outstanding common shares for $400,000, which equaled the carrying amount and the fair value of the interest purchased in rea’s net assets. well did not elect the fair value option. because well is the largest single shareholder in rea, and well’s officers are a majority on rea’s board of directors, well exercises significant influence over rea. rea reported net income of $500,000 for the year and paid dividends of $150,000. in its december 31 balance sheet, what amount should well report as investment in rea?

Answers: 3

Answer

Business, 22.06.2019 21:00

Which of the following statements is correct? stockholders should generally be happier than bondholders to have managers invest in risky projects with high potential returns as opposed to safe projects with lower expected returns. potential conflicts between stockholders and bondholders are increased if a firm's bonds are convertible into its common stock. takeovers are most likely to be attempted if the target firm’s stock price is above its intrinsic value. one advantage of operating a business as a corporation is that stockholders can deduct their pro rata share of the taxes the firm pays, thereby eliminating the double taxation investors would face in a partnership.

Answers: 1

Answer

You know the right answer?

Write the following as triggers. in each case, disallow or undo the modification if it does not sati...

Questions