Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored 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

Recommended Textbook for

Oracle Database 10g Insider Solutions

Authors: Arun R. Kumar, John Kanagaraj, Richard Stroupe

1st Edition

0672327910, 978-0672327919

More Books

Students also viewed these Databases questions

Question

2. Define the grand narrative.

Answered: 1 week ago

Question

What are the advantages and disadvantages of leasing ?

Answered: 1 week ago

Question

Name is needed for identifying organisms ?

Answered: 1 week ago