With CSUB's new affiliation with the Big West Conference, CSUB will renew an old rivalry with the UC Riverside Highlanders, one of CSUB's rivals from both schools' Div II days. At UC Riverside students are allowed to purchase two basketball tickets for each home game. Each ticket contains the date of the game, and the seat information, such as section, row, and individual seat number. Students pay for each game individually; that is, student sporting event passes are not used at UC Riverside. UC Riverside deposits the proceeds from each game into its bank.

REQUIRED

a. Prepare an REA diagram with cardinalities for the revenue cycle for UCRs basketball games. State any assumptions you may have to make concerning UCRs business policies and practices.

b. Implement your model in a set of relational tables you set up. Be sure to specify primary keys, foreign keys, and identify at least one other attribute that should be included in each table.