Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

06. Examine the Following Tables and Auswer the Question bas COURSE Course_name Introduction to Computing Programming 11 Data Structures Statistics Database Credits CCI 201 CCCS

image text in transcribed
06. Examine the Following Tables and Auswer the Question bas COURSE Course_name Introduction to Computing Programming 11 Data Structures Statistics Database Credits CCI 201 CCCS 203 CCCS 204 STAT 110 CCCS 215 themet 11 3 3 3 3 3 SECTION STAT PREREQUISTE Sestion ID Course_num 85 STAT 110 92 COT 201 102 CCCS 204 112 STAT 110 CCIT 201 CCCS 215 Semester Year Instructor Fall 15 Spring 17 Mohmmad Fall 17 Spring 18 Almal Fall 18 Mohmmad Soring 19 Alami CCCS 204 CCCS 204 OCCS 215 CEI 201 OCCS 201 CECS 204 119 135 A) For each of the following DML operations, specify whether the operation will be accepted or rejected. In the case of rejection, explain why by specifying which constraint from below is violated? A. Domain Constraint (Assume the domain of a column is limited to the values present in that column) B. Primary key Constraint C. Entity Integrity Constraint D. Referential (Foreign Key) Constraint DML Operation Accepted Rejected 1. INSERT into Course Values ('Technical Writing'. 'CCT 201,3, IT'); Explanation: 2. INSERT Into Prerequisite values ('COCS 382', 'CCCS 381'); Explanation: 3. UPDATE SECTION set Semester = 'Winter' where Section_ID = 92; Explanation: 4. INSERT into Course Values l'Advanced DB, "CCCS 501', 3, 'CS"); Explanation: Page 17

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Databases questions