#7Multiple Choice
Consider the Information Engineering diagram shown in the exhibit. Building_ID, R_ID, Room_Count and Room_Num are integer numbers, whereas Bldg_Name,
Location and Res_Name are all represented by variable-length strings with a maximum of 20 characters.
Which SQL statement best implements the RESIDENT relation shown in this diagram?