Fixed invalid foreign key constraint and incorrect index creation bug in basketball schema
Updated drop table script to CASCADE on table deletion
NOTE: I chose not to consolidate the gridironrushes and gridironkicks entities into one entity even though they look very similar. Merging them would have resulted in writing slow queries where we distinguish between rushes and kicks based on the possible values in the result attribute. Additionally, rushes and kicks represent sufficiently different entities even though their schemas look similar.
NOTE: I chose not to consolidate the gridironrushes and gridironkicks entities into one entity even though they look very similar. Merging them would have resulted in writing slow queries where we distinguish between rushes and kicks based on the possible values in the
result
attribute. Additionally, rushes and kicks represent sufficiently different entities even though their schemas look similar.