5) Using the following image below, create a list of each of the column variable

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

Explanation / Answer

5. Tabel --- Player

6. Table --- cars

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

Related Questions

Navigate

• Browse (All)
• Browse 5
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.