For each of the following sets of sample data complete the entity model including entity name, attribute names and the various specifications for every attribute (i.e. # * o)
 

Sample Data 1

 
STATE CAPITAL STATE BIRD STATE MOTTO CITY POPULATION
AZ Phoenix Cactus Wren Grand Canyon State Phoenix 1,220,000
AZ Phoenix Cactus Wren Grand Canyon State Tucson 490,000
AZ Phoenix Cactus Wren Grand Canyon State Mesa 380,000
AZ Phoenix Cactus Wren Grand Canyon State Scottsdale 200,000
WA Olympia Willow Goldfinch Evergreen State Spokane 180,000
WA Olympia Willow Goldfinch Evergreen State Seattle 520,000
WA Olympia Willow Goldfinch Evergreen State Tacoma 176,000
TX Austin Mockingbird  Lone Star Austin 475,000
TX Austin Mockingbird  Lone Star Houston 1,640,000
TX Austin Mockingbird  Lone Star Dallas 1,006,000

Sample Data 2

Are any of these attributes derived?
(Pos - Position, Number - Uniform number, GP - Games Played
G - Goals, A - Assists, Pts - Points)

Pos  Num Name            GP   G   A  Pts
C    97  Jeremy Roenick  80  30  46   76
RW   19  Shane Doan      76  26  37   63
LW   90  Joe Juneau      69  10  23   33
RW   28  Landon Wilson   70  18  13   31
D    27  Teppo Numminen  72   5  26   31
C    39  Travis Green    69  13  15   28
RW   22  Claude Lemieux  46  10  16   26
LW   32  Brad May        62  11  14   25
D    21  Jyrki Lumme     58   4  21   25
C    36  Juha Ylonen     69   9  14   23
C    10  Trevor Letowski 77   7  15   22
LW   18  Mika Alatalo    70   7  12   19