Question
The following tables form part of a database held in a relational DBMS for University campuses: - Building (buildingNo , area) ClassRoom (roomNo , buildingNo
The following tables form part of a database held in a relational DBMS for University campuses: - Building (buildingNo , area) ClassRoom (roomNo , buildingNo , capacity) Reserving ( buildingNo , courseNo , timeFrom , day, roomNo) Course (courseNo , courseName) Generate the tuple relational calculus, and domain relational calculus expressions for the following queries: 1. List all buildings. 2. List all class rooms in building 14Kh with capacity >30 students 3. List all course names, buildingNo currently taught at the Khaldiya Campus. 4. List the course details for courses taught in 14KH on Monday at 8:00 a.m.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started