Posts

Introduction to Database Management System As the name suggests, the database management system consists of two parts. They are: 1. Database and 2. Management System

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