THIS ARE THE OPTION FOR A,B,C,D

1. Entity Integrity Constraint
2. Data Constraint
3. Domain Integrity Constraint
4. Naming Constraint
5. Key Integrity Constraint
6. Referential Integrity Constraint

    

Transcribed Image Text:

Which integrity constraint is violated for each of the following design errors? (Table 1) EMP NAME NAME AGE D No Foreign key Jack 20 11 2 Harry 40 24 ID 1000 NAME Tom SEMENSTER AGE 3 John 27 18 1 17 4 Devil 38 13 1001 Johnson 2nd 24 1002 Leonardo 5 21 1003 Kate 3rd 19 1004 Morgan 8m A Not allowed. Because AGE is an integer attribute EMPLOYEE EMP ID EMP NAME SALARY 123 Jack 30000 142 Harry 60000 164 John Jackson 20000 27000 A (A) (B) (C) (D) Not allowed as D No 18 is not defined as a Primary key of table 2 and in table 1, D No is a foreign key defined Relationships (Table 2) Primary Key -D.No D Location #32 11 24 Mumbai Delhi 13 Noida ID NAME SEMENSTER AGE 1000 Tom 1st 17 1001 Johnson 2nd 24 1002 Leonardo 5th 21 1003 Kate 3rd 19 1002 Morgan 8th 22 Not allowed as primary key can't contain a NULL value Not allowed. Because all row must be unique [Choose ] B [Choose ] C [Choose ] D [Choose ] Which integrity constraint is violated for each of the following design errors? (Table 1) EMP NAME NAME AGE D No Foreign key Jack 20 11 2 Harry 40 24 ID 1000 NAME Tom SEMENSTER AGE 3 John 27 18 1 17 4 Devil 38 13 1001 Johnson 2nd 24 1002 Leonardo 5 21 1003 Kate 3rd 19 1004 Morgan 8m A Not allowed. Because AGE is an integer attribute EMPLOYEE EMP ID EMP NAME SALARY 123 Jack 30000 142 Harry 60000 164 John Jackson 20000 27000 A (A) (B) (C) (D) Not allowed as D No 18 is not defined as a Primary key of table 2 and in table 1, D No is a foreign key defined Relationships (Table 2) Primary Key -D.No D Location #32 11 24 Mumbai Delhi 13 Noida ID NAME SEMENSTER AGE 1000 Tom 1st 17 1001 Johnson 2nd 24 1002 Leonardo 5th 21 1003 Kate 3rd 19 1002 Morgan 8th 22 Not allowed as primary key can't contain a NULL value Not allowed. Because all row must be unique [Choose ] B [Choose ] C [Choose ] D [Choose ]