Name: Final Exam Summer 2025
CWID: CS525: Advanced Database Organization
IllinoisTech.edu
Part II:
Attempt all questions [70 pts].
Database Context:
1. Use the following database schema (R_S_U_DB) to answer the questions below
Estimate the result sizes (in bytes) for the queries below. [Hint: use the attribute sizes
provided in the metadata above].
Note: Points will be awarded for stating the correct formulas.
Q1 = π(B, D) σ(R.D = “Blue”) (R) [5 pts]
5
, Name: Final Exam Summer 2025
CWID: CS525: Advanced Database Organization
IllinoisTech.edu
Q2 = σ¬ (E = “female”) (S) [5 pts]
Q3 = σ(S.F < 5) (R ⨝ S) [5 pts]
6
CWID: CS525: Advanced Database Organization
IllinoisTech.edu
Part II:
Attempt all questions [70 pts].
Database Context:
1. Use the following database schema (R_S_U_DB) to answer the questions below
Estimate the result sizes (in bytes) for the queries below. [Hint: use the attribute sizes
provided in the metadata above].
Note: Points will be awarded for stating the correct formulas.
Q1 = π(B, D) σ(R.D = “Blue”) (R) [5 pts]
5
, Name: Final Exam Summer 2025
CWID: CS525: Advanced Database Organization
IllinoisTech.edu
Q2 = σ¬ (E = “female”) (S) [5 pts]
Q3 = σ(S.F < 5) (R ⨝ S) [5 pts]
6
