Engineering, 22.02.2020 00:39 gracie0818

Movies( title, year, length, genre, studioName, producerC#) StarsIn(movieTitle, movie Year, starName) MovieStar(name, address, gender, birthdate) MovieExec(name, address, cert#, net Worth) Studio name, address, presC#) Declare the following referential integrity constraints for the Movie database a) The producer of a movie must be someone mentioned in MovieExec. Modification to MovieExec that violate this constraint are rejected? b) Repeat (a), but violations result in the producers in Movie being set to NULL c) Repeat (a), but violations result in the deletion or update of the offending Movie tuple. d) A movie that appears in Starln must also appear in Movie. Handle violations by rejecting the modifications? ANSWER) b) CREATE TABLE Movies title year length genre studioName CHAR (30) producerC# INT REFERENCES MovieExec (cert#) ON DELETE SET NULL ON UPDATE SET NULL PRIMARY KEY (Eitle, year) CHAR (100) INT. INT CHAR (10), Page 1 Need A and C d) CREATE TABLE Starsin movieTitle CHAR (100) REFERENCES Mowie(title) movieYe INT starName CHAR (30) PRIMARY KEY (movieTItle, movieYear, starName

Answers: 3

Show answers

Another question on Engineering

Engineering, 04.07.2019 18:10

An air conditioning system consist of a 5 cm diameter pipe, operating at a pressure of 200 kpa. the air initially enters the pipe at 15°c with a velocity of 20 m/s and relative humidity of 80%. if the heat supply throughout the process is 960 w, determine the relative humidity and the temperature at the outlet

Answers: 3

Answer

Engineering, 04.07.2019 18:20

Select any two (2) areas of applications of chain-drive. (clo4) a)-permanent lubrication necessary b)-hydraulic forklift truck operation c)-rigging and heavy moving materials d)-relatively high maintenance costs e)-costlier than belt drives

Answers: 2

Answer

Engineering, 04.07.2019 18:20

A3-mm-thick panel of aluminum alloy (k 177 w/m-k, c 875 j/kg-k and ? = 2770 kg/m) is finished on both sides with an epoxy coating that must be cured at or above t,-150°c for at least 5 min. the production line for the curing operation involves two steps: (1) heating in a large oven with air at ts,0-175°c and a convection coefficient of h, 40 w/m2. k, and (2) cooling in a large chamber with air at 25°c and a con- vection coefficient of he 10 w/m2.k. the heating portion of the process is conducted over a time interval te which exceeds the ime required to reach 150°c by 5 min (h = r + 300 s). the coating has an emissivity of ? = 0.8, and the temperatures of the oven and chamber walls are 175 and 25°c, respectively. if the panel is placed in the oven at an initial temperature of 25°c and removed from the chamber at a safe-to-touch tempera ture of 37°c, what is the total elapsed time for the two-step curing operation?

Answers: 3

Answer

Engineering, 04.07.2019 18:20

Modern high speed trains do not have perpendicular expansion gaps where rails are joined end-to-end any more they are mostly welded together but what might happen if there was a spell of particularly hot weather that causes inspection of the tracks?

Answers: 1

Answer

You know the right answer?

Movies( title, year, length, genre, studioName, producerC#) StarsIn(movieTitle, movie Year, starName...

Questions