Approval System

On-campus living

• Residential Areas
  • Dorms (N → res hall)
    • rooms
      • z-room, corner, triple, double

A college has a school email associated with it. For example, @umass.edu for UMass. Colleges can share the same name, but not in the same city. i.e) UMass Amherst and UMass Boston. These also have pseudonyms (University of Massachusetts Amherst vs UMass Amherst).

A college/ university has one ore more residential halls which have one or more dorms. On a given campus, there are different residential areas that have have different dorm buildings which have different types of rooms. For example, at UMass, Kennedy building in Southwest has z-rooms, corner rooms, regular rooms all of which can be considered as single, double, triple, etc. for the amount of people sharing a room.

• different colleges can have the same res_hall name
• dorms and res_halls is 1xN relationship (res_hall-to-dorms)

These on-campus premises can also be:

• apartments
• houses
  • buildings
• frat-house
• nxn relationship with dorms
  • num people in it
    • z room can be a 1, 2 or 3 people

Residential Areas also have dining halls. For example, at UMass, Southwest has two dining halls called Hampshire and Berk.

yellow highlight is alternative key

College (college_name, city, country, nickname, school_email)

• not sure if school emails can be alternative keys

Residential_Halls(college, res_hall_name)

Dorms(Residential_Halls, dorm_name)

Dorm_Type(Dorms, type, num_people)

• type: house, apartment, z room, etc.
• num_people: is a triple too tight for me?

Off-campus living