Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Answer Plz Which integrity constraint is violated for each of the following design errors? (Table 1) EMP_NAME NAME AGE D.No Foreign key 1 11 2
Answer Plz
Which integrity constraint is violated for each of the following design errors? (Table 1) EMP_NAME NAME AGE D.No Foreign key 1 11 2 Harry 3 John 27 18 ID 1000 1001 Devil 13 NAME Tom Johnson Leonardo Kate Morgan 1002 SEMENSTER AGE 17 24 5 21 3rd 19 g A 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 1003 1004 Relationships (Table 2) D Location D.No Not allowed. Because AGE is an integer attribute Primary key 11 Mumba Dein Noida (A) (B) 13 (C) (D) EMPLOYEE SEMENSTER AGE 1st 17 EMP ID 123 142 164 EMP NAME Jack Harry John Jackson SALARY 30000 60000 20000 27000 ID 1000 1001 1002 1003 1002 NAME Tom Johnson Leonardo Kate Morgan 24 21 ger 22 Not allowed as primary key cant contain a NULL value Not allowed. Because all row must be unique A [Choose ] > B [Choose ] > [Choose ]Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started