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
Post a Comment