Your nephew, who is a junior in high school, has been asked to work on a database for NBA teams. The following are the requirements he has been given: All teams play in the Eastern Conference or the Western Conference. Teams in each conference are named for cities or states. Some teams have moved from one conference to another.
He asks for help in defining entities and attributes. Which of the following would you advise? Select all that apply:
- NBA as supertype with Conference as subtype
- Conference as subtype under Team as supertype
- Team as subtype under Conference as supertype
- City and State as subtypes under Team as supertype
- TeamMoved as attribute of Conference subtype
- CityName as attribute of Team supertype