Solved Problems on Relational Algebra
Consider the database scheme shown above. Write down relational algebra expressions for the
a) Retrieve the names of employees in department 5 who work more than 10 hours per week
on the 'ProductX' p
ER to Relational Mapping
For the many-to- many relation between Airport and Airplane_Type, create a new table
Airport_Airplane_Landing wirelationsth the keys of both Airport and Airplane_Type relations
1. Consider the database scheme shown above.
a. What are the referential integrity constraints that should hold on the schema?
PREREQUISITE.(CourseNumber) -> COURSE.(CourseNumber)
PREREQUISITE.(PrerequisiteNumber) -> COURSE.(CourseNumber)