Question: Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics, as shown in Figure 10B-97. SLIDE_SHOW_PICTURE_INT is an intersection table
Write an SQL CREATE TABLE statement to create the table SLIDE_SHOW_PICTURE_INT using the column characteristics, as shown in Figure 10B-97. 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 in the intersection table when a PICTURE is deleted.
Step by Step Solution
3.41 Rating (173 Votes )
There are 3 Steps involved in it
CREATE TABLE SLIDESHOWPICTUREINT ShowID Int Int IntPK P... View full answer
Get step-by-step solutions from verified subject matter experts
Document Format (2 attachments)
1808_60b8c121590bf_729860.pdf
180 KBs PDF File
1808_60b8c121590bf_729860.docx
120 KBs Word File
