Jump to level $1$

Our state's Department of Education maintains a database of colleges in the state. Each college has a name, a code, and the count of students currently enrolled. Each college may have more than one campus. Each campus has a name that is unique within the college and has an address. More than one campus of a college may be located in the same city. Cities are identified by name. A city may contain campuses of more than one college.

The entities are College, Campus, and City.

What are the attributes of each entity?

College

Campus City

CityName

CollegeCode

Address

StudentCount

CampusName

CollegeName

Have