6.2 Consider the following relation that stores informationabout students living in dormitories at a college:
College (lastName, stuId, homeAdd, homePhone, dormRom,roomateName, dormAdd, status, mealPlan, roomCharge,mealPlanCharge)
Assume:
• Each student is assigned to one dormitory room and may haveseveral roommates
• Names of students are not unique
• The college has several dorms, dormRoom contains a code forthe dorm and the number of the particular room assigned to thestudent. For example, A221 means Adams Hall, room 221. Dorm namesare unique
• The dormAdd is the address of the dorm building. Each buildinghas its own unique address. For example, Adams Hall may be 123 MainStreet, Anytown, NY 10001.
•
OR
OR