With ABC's new affiliation with the Big West Conference, ABC will renew an old rivalry with the XY, one of ABC's rivals from both schools' Div II days. At XY 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 XY. XY deposits the proceeds from each game into its bank.

REQUIRED

a. Prepare an REA diagram with cardinalities for the revenue cycle for XYs basketball games. State any assumptions you may have to make concerning XYs 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.

PLEASE HELP!!