Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Select ALL that are CORRECT. Given a relational model and the domains of attributes, you are asked to review an SQL script that creates a

image text in transcribed

Select ALL that are CORRECT. Given a relational model and the domains of attributes, you are asked to review an SQL script that creates a database for this model that has to guarantee data integrity. A (al integer, a2:string, a3. string Bibi:integer, string, al:integer) The domain of al: any integers. The domain of a2: any strings with the length of 0 to 40 The domain of a3: any strings with the length of 2. The domain of b1: any integers. The domain of b2 any strings with the length of Oto 20. Your colleague submitted his script and claimed that it would create a database that supports the four main relational constraints: domain constraint, key constraint, entity integrity constraint and referential integrity constraint. 1. CREATE TABLE A ( 2 al INTEGER 3 a2 VARCHAR(40), 4. a3 VARCHAR(2), 5 PRIMARY KEY (al) 6 ); 7 8. CREATE TABLE B ( 9 b1 INTEGER, 10 b2 VARCHAR(20), 11 a1 INTEGER, 12 PRIMARY KEY (51) 13 Review the script above and select ALL that correctly describe relational constraint violations. The primary key for B is not correctly implemented. O A's attribute al conflicts with attribute a1 in B. Two relations cannot have the same attribute names. The domain of a 2 in A is not correctly implemented. The foreign key for B is not implemented. The domain of a3 in A is not correctly implemented

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

Genetic Databases

Authors: Martin J. Bishop

1st Edition

0121016250, 978-0121016258

More Books

Students also viewed these Databases questions

Question

1. Explain the 2nd world war. 2. Who is the father of history?

Answered: 1 week ago