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, 22.06.2019 00:00

Which statement is true of both presidential and parliamentary systems of government? a. the executive branch operates independently from the legislative branch. b. the members of the legislative branch are directly elected by the people. c. the head of government is chosen by members of his or her political party. d. the head of government is directly elected by the people

Answers: 1

Answer

Business, 22.06.2019 04:50

Neveready flashlights inc. needs $317,000 to take a cash discount of 3/15, net 70. a banker will loan the money for 55 days at an interest cost of $13,200. a. what is the effective rate on the bank loan? (use a 360-day year. do not round intermediate calculations. input your answer as a percent rounded to 2 decimal places.) b. how much would it cost (in percentage terms) if the firm did not take the cash discount but paid the bill in 70 days instead of 15 days? (use a 360-day year. do not round intermediate calculations. input your answer as a percent rounded to 2 decimal places.) c. should the firm borrow the money to take the discount? no yes d. if the banker requires a 20 percent compensating balance, how much must the firm borrow to end up with the $317,000? e-1. what would be the effective interest rate in part d if the interest charge for 55 days were $7,200?

Answers: 3

Answer

Business, 22.06.2019 09:30

Which are the best examples of costs that should be considered when creating a project budget?

Answers: 2

Answer

Business, 22.06.2019 10:00

mary's baskets company expects to manufacture and sell 30,000 baskets in 2019 for $5 each. there are 4,000 baskets in beginning finished goods inventory with target ending inventory of 4,000 baskets. the company keeps no work-in-process inventory. what amount of sales revenue will be reported on the 2019 budgeted income statement?

Answers: 2

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