62 Consider Following Relation Stores Information Students Living Dormitories College Coll Q37073346

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

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.