DATA MANAGEMENT

dajibatutu1
FinalProject2.accdb
Home>Business & Finance homework help>Management homework help>DATA MANAGEMENT
PLAYER_ID AB R H HR RBI BB SO AVG OBP
CA1 282 45 68 13 35 28 101 0.241 0.326
CA2 7 1 1 0 0 1 1 0.143 0.25
IF2 626 74 164 2 47 31 60 0.262 0.297
IF3 229 28 52 10 36 16 56 0.227 0.285
IF4 217 24 52 6 34 29 41 0.24 0.329
IF5 174 22 35 6 18 9 38 0.201 0.246
IF6 168 26 35 6 15 15 50 0.208 0.277
IF9 530 70 147 29 98 48 152 0.277 0.34
OF1 130 17 32 4 26 8 32 0.246 0.295
OF2 236 27 60 2 19 20 91 0.254 0.317
OF3 117 23 39 8 18 27 41 0.333 0.466
OF4 318 47 67 17 41 39 107 0.211 0.296
OF5 208 33 52 8 33 20 55 0.25 0.332
PI01 3 0 0 0 0 0 3 0.0 0.0
PI11 0 0 0 0 0 0 0 0.0 0.0
PI12 0 0 0 0 0 0 0 0.0 0.0
PI13 1 0 0 0 0 0 1 0.0 0.0
PI14 537 103 138 46 100 96 189 0.257 0.372
PI15 0 0 0 0 0 0 0 0.0 0.0
PI16 0 0 0 0 0 0 0 0.0 0.0
PI17 0 0 0 0 0 0 0 0.0 0.0
PI18 4 1 1 0 0 0 2 0.25 0.25
PI19 1 0 0 0 0 0 1 0.0 0.0
PI02 0 0 0 0 0 0 0 0.0 0.0
PI21 0 0 0 0 0 0 0 0.0 0.0
PI22 0 0 0 0 0 0 0 0.0 0.0
PI23 0 0 0 0 0 0 0 0.0 0.0
PI03 0 0 0 0 0 0 0 0.0 0.0
PI04 1 0 0 0 0 1 1 0.0 0.5
PI06 0 0 0 0 0 0 0 0.0 0.0
PI07 0 0 0 0 0 0 0 0.0 0.0
PI08 0 0 0 0 0 0 0 0.0 0.0
R23 60 3 10 0 6 2 17 0.167 0.194
CA_PLAYER_ID JERSEY_NO NAME AGE TEAM_NAME
CA1 33 Max Stassi 30 Los Angeles Angels
CA2 23 Matt Thaiss 26 Los Angeles Angels
COACH_ID NAME ROLE
01  Joe Maddon Manager
10 Bruce Hines  First Base
11 John Mallee Assistant Hitting
12 Ali Modami Staff Assistant
13 Ray Montgomery Bench
14 Phil Nevin  Third Base
15 Jeremy Reed  Hitting
16 Paul Sorrento Hitting instructor
17 Matt Wise Pitching
02 Mike Ashman  Batting Practice Pitcher
03 Jason Brown  Bullpen Catcher
04 Tim Buss  Quality Assurance
05 Dom Chiti Bullpen
06 Manny Del Campo  Bullpen Catcher
07 Mike Gallego  Defense
08 Benji Gil  Coaching Assistant
09 Bill Haselman  Catching
IF_PLAYER_ID JERSEY_NO NAME AGE TEAM_NAME
IF1 25 Brendon Davis 25 Los Angeles Angels
IF2 22 David Fletcher 27 Los Angeles Angels
IF3 9 Jack Mayfield 31 Los Angeles Angels
IF4 6 Anthony Rendon 31 Los Angeles Angels
IF5 2 Luis Rengifo 25 Los Angeles Angels
IF6 18 José Rojas 28 Los Angeles Angels
IF7 71 Andrew Velazquez 27 Los Angeles Angels
IF8 14 Tyler Wade 27 Los Angeles Angels
IF9 20 Jared Walsh 28 Los Angeles Angels
TEAM_NAME BOSS_NAME HOME_LOC
Los Angeles Angels Arturo Arte Moreno Anaheim. CA
OF_PLAYER_ID JERSEY_NO NAME AGE TEAM_NAME
OF1 7 Jo Adell 22 Los Angeles Angels
OF2 16 Brandon Marsh 24 Los Angeles Angels
OF3 27 Mike Trout 30 Los Angeles Angels
OF4 10 Justin Upton 34 Los Angeles Angels
OF5 3 Taylor Ward 28 Los Angeles Angels
PLAYER_ID W L ERA G H ER HR BB SO WHIP
PI01 2 4 4.61 56.2 70 29 8 19 35 1.57
PI12 5 5 3.84 75.0 71 32 11 26 90 1.29
PI14 9 2 3.18 130.1 98 46 15 44 156 1.09
PI15 1 0 4.82 9.1 12 5 1 2 4 1.5
PI17 2 1 3.64 29.2 28 12 0 15 29 1.45
PI18 3 6 3.62 87.0 69 35 11 36 94 1.21
PI19 8 8 3.75 98.1 85 41 11 36 85 1.23
PI02 5 4 5.6 62.2 65 39 14 28 62 1.48
PI22 1 0 4.94 27.1 23 15 5 11 38 1.24
PI23 3 0 1.77 20.1 16 4 0 5 20 1.03
PI03 0 1 20.25 1.1 6 3 0 0 0 4.5
PI04 1 3 7.4 20.2 26 17 5 11 19 1.79
PI05 1 0 4.15 13.0 11 6 1 7 9 1.38
PI06 2 2 4.3 14.2 15 7 0 4 18 1.3
PI07 7 5 2.57 70.0 53 20 11 12 103 0.93
PI_PLAYER_ID JERSEY_NO NAME AGE TEAM_NAME
PI01 51 Jaime Barría 25 Los Angeles Angels
PI10 62 Aaron Loup 34 Los Angeles Angels
PI11 68 José Marte 25 Los Angeles Angels
PI12 21 Mike Mayers 30 Los Angeles Angels
PI13 58 Packy Naughton 25 Los Angeles Angels
PI14 17 Shohei Ohtani 27 Los Angeles Angels
PI15 82 Oliver Ortega 25 Los Angeles Angels
PI16 65 José Quijada 26 Los Angeles Angels
PI17 73 Chris Rodriguez 23 Los Angeles Angels
PI18 43 Patrick Sandoval 25 Los Angeles Angels
PI19 54 José Suárez 24 Los Angeles Angels
PI02 47 Griffin Canning 25 Los Angeles Angels
PI20 34 Noah Syndergaard 29 Los Angeles Angels
PI21 63 Kyle Tyler 25 Los Angeles Angels
PI22 60 Andrew Wantz 26 Los Angeles Angels
PI23 61 Austin Warren 26 Los Angeles Angels
PI03 56 Cooper Criswell 25 Los Angeles Angels
PI04 48 Reid Detmers 22 Los Angeles Angels
PI05 74 Jhonathan Díaz 25 Los Angeles Angels
PI06 46 Jimmy Herget 28 Los Angeles Angels
PI07 32 Raisel Iglesias 32 Los Angeles Angels
PI08 66 Janson Junk 26 Los Angeles Angels
PI09 12 Michael Lorenzen 30 Los Angeles Angels
ROOKIE_ID ROOKIE_NAME AGE POSITION TEAM_NAME
R07 David Calabrese 19 CF Los Angeles Angels
R08 D’Shawn Knowles 20 CF Los Angeles Angels
R09 Jeremiah Jackson 21 3B Los Angeles Angels
R10 William Holmes 21 SP Los Angeles Angels
R11 Denzer Guzman 17 2B Los Angeles Angels
R12 Davis Daniel 24 SIRP Los Angeles Angels
R13 Alejandro Hidalgo 18 SP Los Angeles Angels
R14 Hector Yan 22 MIRP Los Angeles Angels
R15 Orlando Martinez 23 LF Los Angeles Angels
R01 Jordyn Adams 22 CF Los Angeles Angels
R16 Livan Soto 21 SS Los Angeles Angels
R17 Werner Blakely 19 3B Los Angeles Angels
R18 Aaron Hernandez 25 SIRP Los Angeles Angels
R19 Sadrac Franco 21 SIRP Los Angeles Angels
R20 Jose Salvador 22 SIRP Los Angeles Angels
R21 Connor Higgins 25 SIRP Los Angeles Angels
R22 Gabriel Tapia 19 SP Los Angeles Angels
R23 Kean Wong 26 2B Los Angeles Angels
R24 Gerardo Reyes 28 SIRP Los Angeles Angels
R25 Trent Deveaux 21 CF Los Angeles Angels
R26 Robinson Pina 23 SIRP Los Angeles Angels
R27 Jose Bonilla 19 3B Los Angeles Angels
R02 Arol Vera 19 SS Los Angeles Angels
R03 Adrian Placencia 18 2B Los Angeles Angels
R04 Kyren Paris 20 2B Los Angeles Angels
R05 Alexander Ramirez 19 RF Los Angeles Angels
R06 Jack Kochanowicz 21 SP Los Angeles Angels
TRADE_CODE NAME AGE CNTRCT_YEAR TRADE_COST TRADE_DATE
CREATE TABLE [BAT PERFORMANCE]( PLAYER_ID CHAR(40) NOT NULL UNIQUE, AB INT, R INT, H INT, HR INT, RBI INT, BB INT, SO INT, AVG FLOAT, OBP FLOAT, PRIMARY KEY (PLAYER_ID));