Crowdly
Add to Chrome
INTRO. TO DATABASE MGMT. SYST.
Looking for INTRO. TO DATABASE MGMT. SYST. test answers and solutions? Browse our comprehensive collection of verified answers for INTRO. TO DATABASE MGMT. SYST. at moodlenew.iitd.ac.in.
Get instant access to accurate answers and detailed explanations for your course questions. Our community-driven platform helps students succeed!
State true or false for the following statement:
, holds for both sets and bags.
Assuming set semantics, State true or false for the following statement:
The grouping operator ๐พย (gamma) can do duplicate elimination.
Consider the following university database schema:
ย
Student (SID, Name, Age, Major, GPA)
Course (CID, Title, Department, Credits)
Enrollment (SID, CID, Semester, Grade)
Professor (PID, Name, Department, Salary)
Teaches (PID, CID, Semester)
ย
Which of the following relational algebra expression(s) will retrieve the titles of all courses offered by the 'Mathematics' department. (Note: there can be more than expressions)
What is the primary key in an ER model?
Consider the following university database schema:
ย
Student (SID, Name, Age, Major, GPA)
Course (CID, Title, Department, Credits)
Enrollment (SID, CID, Semester, Grade)
Professor (PID, Name, Department, Salary)
Teaches (PID, CID, Semester)
ย
Which of the following relational algebra expression(s) will Retrieve the names of students with an 'A' grade in at least one course? (Note: there can be more than expressions)
In an ER diagram, a double rectangle is used to represent?
State true or false for the following statement:
holds for both sets and bags.
Consider the following university database schema:
ย
Student (SID, Name, Age, Major, GPA)
Course (CID, Title, Department, Credits)
Enrollment (SID, CID, Semester, Grade)
Professor (PID, Name, Department, Salary)
Teaches (PID, CID, Semester)
ย
Which of the following relational algebra expression(s) will Retrieve the names of professors who teach at least one course? (Note: there can be more than expressions)
Assuming set semantics, State true or false for the following statement:
The operator โ is a combination of (ฯ, ฮ , x).
Consider the following university database schema:
ย
Student (SID, Name, Age, Major, GPA)
Course (CID, Title, Department, Credits)
Enrollment (SID, CID, Semester, Grade)
Professor (PID, Name, Department, Salary)
Teaches (PID, CID, Semester)
ย
Which of the following relational algebra expression(s) will Find students who have taken both Course C1 and Course C2? (Note: there can be more than expressions)