Question: 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

 Select ALL that are CORRECT. Given a relational model and the

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!