The following incomplete list of business rules describes the relationships between some of the different types of
Question:
The following incomplete list of business rules describes the relationships between some of the different types of sports fans:
Baseball Fans can be Tigers fans, Yankee Fans, both, or neither.
All Baseball Fans are People, but not all People are Baseball Fans.
Some Tigers fans are also Pistons Fans.
Pistons Fans are People, but not all people are Pistons Fans.
Both Tigers fans and Pistons Fans are Sports Fans.
Sports Fans are People, but not all People are Sports Fans.
1. Create a complete list of business rules that are consistent with the incomplete list given above. This list should make provision for all entities and relationships given in the above list, and there are many solutions that do so.
2. Develop an extended entity-relationship diagram (EERD) describing these types of sports fans and the relationships between them. The diagram should include the primary key of each table in order to demonstrate the correct implementation of specialization-generalization, but should not include any other attributes. You should use legal database identifiers such as Tigers)Fan or Sports_Fan in your EERD.
Income Tax Fundamentals 2013
ISBN: 9781285586618
31st Edition
Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill