Question

5) Using the following image below, create a list of each of the column variables that would be created if this would be implemented in a database. Be sure to provide data types and lengths for each of these variables. No. Name CL Pos. Ht. wt. Hometown 4 Kris Myllari FR Defense 6-2 190 Kanata, Ontario 5 Kevin Kerr SO Defense 6-0 195 Bensalem, Pa 6 James Gobetz FR Defense 6-2 210 St. James, N.Y Last Team Youngstown Phantoms (USHL) Tri-City Storm (USHL) Des Moines Buccaneers (USHL) James Robinsorn JR Forward 6-2 193 Cochrane, Alberta Langley Rivermen (BCHL) 8 Chase Berger SO Forward 6-0 195 St. Louis, Mo. Tri-City Storm (USHL) 6) Using the following image below, create a list of each of the column variables that would be created if this would be implemented in a database. Be sure to provide the data types and lengths for each of these variables. Microsoft Access-[cars : Table] Ele Edit View Insert Format Records lools window Help Car ID Make Model Year Tax Colour Price F4 250.00 Green 55,495.00 Green 6,250.00 Red 2003 2002 2002 2002 2002 2002 2001 2001 2001 2001 Ford 11 Mitsubishi 12 Ford Ka Pajero Focus Espace 1 Renault 9 Renault 8 Ford 16 Peugedt 29 Nissan 26 Ford 32 Seat 900.00 Blue 55,500.00 Black 750.00 Yellow 4750.00 Black 4850.00 Silver 回 IO Mondeo 206 Primera Focus biza £10.495.00 Red E6,600.00 Blue

Answer 1

5. Tabel --- Player

PlayerNo	int
Name	varchar(50)
CI	char(2)
Pos	varchar(12)
Ht	char(3)
Wt	int
Hometown	varchar(50)
LastTeam	varchar(100)

6. Table --- cars

Car_ID	int
Make	varchar(20)
Model	varchar(20)
Year	int
Tax	boolean
Price	decimal(8,2)
Color	varchar(20)