Suppose there is a table named hall_room_allocation where student_id is primary key. Write a DDL code where each student can get only one hall, only…

Suppose there is a table named hall_room_allocation where student_id is primary key. Write a DDL code where each student can get only one hall, only one room and only one bed. Show the possible foreign key.

From the BUET MSC (CSE) October 2017 – Written exam, question 10 of 20.

More from this paper