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
Engineering, 04.07.2019 16:10
An electrical motor raises a 50kg load at a construct velencity .calculate the power of the motor, if it takes 40sec to raise the load through a height of 24m(take g =9.8n/g)
Answers: 2
Engineering, 04.07.2019 18:10
Acompressor receives the shaft work to decrease the pressure of the fluid. a)- true b)- false
Answers: 3
Engineering, 04.07.2019 18:10
Draw the engineering stress-strain curve for (a) bcc; (b) fcc metals and mark important points.
Answers: 1
Engineering, 04.07.2019 18:20
Have a greater impact on maintenance productivity than any other support group. (clo5) a)-the top management b)-inventory and purchasing c)-sub-contracting d)-cmms
Answers: 2
Movies( title, year, length, genre, studioName, producerC#) StarsIn(movieTitle, movie Year, starName...
Health, 21.09.2021 20:50
Mathematics, 21.09.2021 21:00
Mathematics, 21.09.2021 21:00
English, 21.09.2021 21:00
Chemistry, 21.09.2021 21:00
History, 21.09.2021 21:00
English, 21.09.2021 21:00
Mathematics, 21.09.2021 21:00
Social Studies, 21.09.2021 21:00
History, 21.09.2021 21:00
Mathematics, 21.09.2021 21:00
Mathematics, 21.09.2021 21:00
Computers and Technology, 21.09.2021 21:00
English, 21.09.2021 21:00