Identify the correct statement.Logical level Abstraction: describes how schema is stored in a data baseIf R and S are two relation then R ∩ S can be represented as.(R ∪ S) - [(R - S) ∪ (S - R)]Consider the following relationsstudent ( id, name, address, gpa, sizeHS )campus ( location, enrollment, rank )apply ( id, location, date, major, decision )Identify the correct query to find name and address of all students with GPA > 3.7 and sizeHS < 1000.∏name, address ( σ GPA > 3.7 ^ sizeHS < 1000 ( student ) )Identify the number of tuples in the relation R1 ⋈ R2.7

Identify the correct statement.



Logical level Abstraction: describes how schema is stored in a data base

If R and S are two relation then R ∩ S can be represented as.


(R ∪ S) - [(R - S) ∪ (S - R)]

Consider the following relations

student ( id, name, address, gpa, sizeHS )
campus ( location, enrollment, rank )
apply ( id, location, date, major, decision )

Identify the correct query to find name and address of all students with GPA > 3.7 and sizeHS < 1000.



∏name, address ( σ GPA > 3.7 ^ sizeHS < 1000 ( student ) )

Identify the number of tuples in the relation R1 ⋈ R2.


7

Comments