Question

Part I: Creating ER Diagrams

PLEASE COMPLETE EVERY QUESTION

Question 1 (25 points): Consider the following scenario.

• A Pokémon character has a unique number; a name; stamina, attack and defense values; a date introduced; and one or more moves.

• A move has a name, is either quick or special, and has an accuracy and power points.

• A Pokémon type has a type name, a description and a type count (the number of characters with that type).

• A Pokémon type can be weak, medium or strong against zero or more other types.

• Each Pokémon character has a primary type and possibly a secondary type.

• A creature is an instance of a Pokémon character. It has a unique sequence number within all creatures for that character, combat power (CP), and possibly a nickname.
• A player has a unique account name, an email and experience points.

• A location is identified by its latitude and longitude. It also has a description.

• A player can capture a creature at a location on a particular date. The player may give up the creature at a later date.

• A player can own zero or more creatures. Not every creature must be owned by a player, but is never owned by two or more players.

• There are different types of Pokéballs, each with a unique name, a generation number and a price.

• A player can carry up to six Pokéballs.

Draw an ER diagram that represents this scenario. You can use conventional notation (rectangles, diamonds, ovals) or UML notation. (If you use UML notation, be sure you are showing an ER diagram and not a schema diagram. If you are showing foreign keys, you have the wrong type of diagram.) Be sure to mark the key attributes and include minimum and maximum cardinality constraints on relationships. You don’t need to give the types of attributes.

For Questions 2-5 you should modify your ER diagram from Question 1 to handle the following changes in the scenario. Do each scenario as a separate change from the original diagram. You only need to show the parts of the diagram that change.

Question 2 (10 points): A character can evolve into another character.

Question 3 (10 points): There are PokéStops each with a location and a description. A PokéStop can provide zero or more types of PokéBalls.

Question 4 (10 points): A player has an avatar with hair, skin and eye colors.

Question 5 (10 points): Each player can designate one of his or her owned creatures as a “Buddy Pokémon”.

Answer 1

enc A cccuntSkot ame Dab 8 Na play ouns Seg-M acte Locak ack HAS cO Has Name enen- Type NO Name me

Na me ener. i on TYpe NO Move ame Accu leand Chanacte has t 1 to Many telatinsh. p 2) plye and also to a 2 banacte) ond More has t to Man chan acto and Typ hoy I to lan