Use the Microsoft SQL Server Management Studio to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics shown

Question:

Use the Microsoft SQL Server Management Studio to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics shown in Figure 10A-84.SLIDE_SHOW_PICTURE_INT is an intersection table between PICTURE and SLIDE_SHOW, so create appropriate relationships between PICTURE and SLIDE_SHOW_PICTURE_INT and between SLIDE_SHOW and SLIDE_SHOW_PICTURE_INT. Set the referential integrity properties to disallow any deletion of a SLIDE_SHOW row that has any SLIDE_SHOW_PICTURE_INT rows related to it. Set the referential integrity properties to cascade deletions when a PICTURE is deleted. Do not cascade updates to PICTURE.PictureID.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: