Database System

Given a campus enviroment

A BUILDING can contain many ROOMs, but each ROOM is found in a single BUILDING.

BUILDING (BLDG_CODE, BLDG_NAME, BLDG_LOCATION)

ROOM (BLDG_CODE, ROOM_NUM, ROOM_TYPE)

List existence-dependent entity________________________

List existence-independent entity________________________

Using LucidChart to draw ERD using Chen Model and Crowss Foot Model