Set the referential integrity properties to cascade


Use the Microsoft SQL Server Management Studio to create the table SHOW_ PICTURE_INT as an intersection table between PICTURE and SLIDE_SHOW. Create appropriate relationships between PICTURE and SHOW_PICTURE_INT and between SLIDE_SHOW and SHOW_PICTURE_INT. Set the referential integrity properties to disallow any deletion of a SLIDE_SHOW row that has any SHOW_PICTURE_INT rows related to it. Set the referential integrity properties to cascade deletions when a PICTURE is deleted. Cascade updates to PICTURE. Name.

Request for Solution File

Ask an Expert for Answer!!
Basic Computer Science: Set the referential integrity properties to cascade
Reference No:- TGS01604931

Expected delivery within 24 Hours