Create A Word Document Copy Of The Six Questions

Create A Word Document Copy Each Of The Six Questions From The End

Create a Word document. · Copy each of the six questions from the end of the activity into your document and write your response to each question below it. · Show in your responses that you understand the subject matter. In-Depth Activity The aim of this in-depth activity is for you to think about the appropriateness of different kinds of conceptual models that have been designed for similar physical and digital information artifacts. Compare the following: · A paperback book and an eBook · A paper-based map and a smartphone map app 1. What are the main concepts and metaphors that have been used for each? (Think about the way time is conceptualized for each of them.) 2. How do they differ? 3. What aspects of the paper-based artifact have informed the digital app? 4. What is the new functionality? 5. Are any aspects of the conceptual model confusing? 6. What are the pros and cons? Papa_Exp19_Access_Ch09_Cap_Trading_Cards.accdb Brand ID Brand mSysRowId B001 Topps HLkoQCAuNSIzA8cm24Jlb7wie9ES8YO5kYdA8UMC4rY=-~NwjQHnLnONVj3kGwIgzgMA== B002 Other HLkoQCAuNSIzA8cm24Jlb7wie9ES8YO5kYdA8UMC4rY=-~NwjQHnLnONVj3kGwIgzgMA== B003 Fleer HLkoQCAuNSIzA8cm24Jlb7wie9ES8YO5kYdA8UMC4rY=-~NwjQHnLnONVj3kGwIgzgMA== B004 Donruss HLkoQCAuNSIzA8cm24Jlb7wie9ES8YO5kYdA8UMC4rY=-~NwjQHnLnONVj3kGwIgzgMA== B005 Bowman HLkoQCAuNSIzA8cm24Jlb7wie9ES8YO5kYdA8UMC4rY=-~NwjQHnLnONVj3kGwIgzgMA== CardNo Year Brand ID PlayerName Team NumInStock Rarity ID C B001 Jerald Clark SDP 3 3 C B002 David Justice ATL 3 2 C B002 Kent Hrbek MIN 1 2 C B001 Chad Curtis CAL 1 1 C B001 Henry Cotto SEA 1 2 C B003 Mark Lemke ATL 1 3 C B004 Mike Sharperson LAD 1 3 C B002 Joe Orsulak BAL 1 3 C B005 Luis Gonzalez HOU 1 1 C B005 Casey Candaele HOU 2 1 C B001 Kelly Gruber TOR 1 1 C B004 Ozzie Smith STL 3 3 C B005 Dante Bichette MIL 3 2 C B005 John Vander Wal MON 3 1 C B003 Herm Winningham BOS 2 1 C B003 Mark McGwire OAK 3 1 C B001 Dave Martinez CIN 1 1 C B003 Gary Varsho PIT 2 3 C B003 Kevin Seitzer MIL 3 3 C B003 Shane Mack MIN 1 1 C B003 Marquis Grissom MON 2 1 C B003 Terry Pendleton ATL 2 1 C B001 Scott Livingstone DET 2 1 C B004 Dave Martinez CIN 2 3 C B004 Craig Biggio HOU 2 1 C B001 Glenn Davis BAL 3 3 C B002 Jerald Clark SDP 2 2 C B004 Randy Velarde NYY 1 1 C B003 Rafael Belliard ATL 2 2 C B003 Terry Steinbach OAK 3 3 C B002 Tim Wallach MON 3 2 C B005 Henry Cotto SEA 2 2 C B002 Willie McGee SFG 2 3 C B001 Jeff Bagwell HOU 2 2 C B003 Darrin Jackson SDP 2 1 C B005 Tim Raines CHW 2 3 C B005 Dave Valle SEA 3 2 C B004 Chris James SFG 2 1 C B002 Paul O'Neill CIN 2 3 C B004 Ron Karkovice CHW 2 2 C B004 Eddie Murray NYM 3 2 C B005 Travis Fryman DET 1 2 C B004 Travis Fryman DET 3 2 C B002 Mitch Webster LAD 1 2 C B004 Scott Cooper BOS 3 1 C B004 Bobby Bonilla NYM 1 1 C B002 Harold Reynolds SEA 1 3 C B005 Danny Tartabull NYY 3 2 C B002 Robin Yount MIL 2 1 C B005 George Bell CHW 1 2 C B003 Carney Lansford OAK 2 2 C B003 John Olerud TOR 1 1 C B003 Luis Polonia CAL 1 2 C B002 Jeff Huson TEX 3 3 C B002 Scott Livingstone DET 3 2 C B002 Luis Sojo CAL 1 3 C B001 Frank Thomas CHW 3 1 C B003 Jeff Huson TEX 1 1 C B005 Omar Vizquel SEA 2 1 C B003 Rickey Henderson OAK 3 2 C B002 Mark McGwire OAK 2 1 C B005 Kirt Manwaring SFG 1 2 C B005 George Bell CHW 1 3 C B005 Greg Gagne MIN 3 1 C B001 Chili Davis MIN 2 1 C B002 Leo Gomez BAL 3 3 C B003 Will Clark SFG 1 2 C B003 Lou Whitaker DET 1 2 C B004 Jim Eisenreich KCR 3 2 C B001 Eric Anthony HOU 1 1 C B003 Danny Tartabull NYY 3 1 C B002 Dante Bichette MIL 2 3 C B005 Dave Hollins PHI 1 3 C B001 Luis Sojo CAL 2 1 C B003 Pat Kelly NYY 1 1 C B004 Luis Polonia CAL 1 3 C B001 Lou Whitaker DET 3 3 C B005 Gene Larkin MIN 1 1 C B005 Steve Finley HOU 3 2 C B001 Kurt Stillwell SDP 3 3 C B003 Reggie Sanders CIN 2 2 C B001 Roberto Kelly NYY 3 3 C B004 Tino Martinez SEA 1 1 C B001 Harold Reynolds SEA 1 1 C B004 Tony Fernandez SDP 2 1 C B002 Dwight Smith CHC 2 1 C B003 Mike Bordick OAK 2 2 C B002 Mike Macfarlane KCR 2 2 C B001 Jerry Browne OAK 2 3 C B003 Luis Gonzalez HOU 2 3 C B004 B.J. Surhoff MIL 1 1 C B002 Andre Dawson CHC 1 1 C B003 Ron Karkovice CHW 2 1 C B003 Mike Scioscia LAD 1 3 C B002 Danny Tartabull NYY 2 2 C B001 Felix Jose STL 2 1 C B001 Frank Thomas CHW 2 2 C B002 Jim Eisenreich KCR 3 3 C B003 Mike Scioscia LAD 3 1 C B005 Devon White TOR 3 1 C B001 Jeff King PIT 1 3 C B002 Jerald Clark SDP 2 2 C B004 Marquis Grissom MON 1 1 C B005 Kelly Gruber TOR 1 3 C B002 Matt Williams SFG 3 1 C B004 Kent Hrbek MIN 2 1 C B005 Dave Hansen LAD 2 1 C B005 Robby Thompson SFG 1 3 C B003 Luis Gonzalez HOU 3 3 C B005 Wade Boggs BOS 2 3 C B004 Ozzie Smith STL 2 2 C B004 Scott Leius MIN 1 3 C B005 Jeff Bagwell HOU 3 1 C B005 Lance Blankenship OAK 2 2 C B005 George Brett KCR 3 3 C B002 Robby Thompson SFG 1 3 C B004 Mariano Duncan PHI 2 1 C B004 Cecil Fielder DET 2 2 C B001 Tom Brunansky BOS 3 2 C B002 Carney Lansford OAK 2 1 C B003 Cory Snyder SFG 3 2 C B003 Eric Anthony HOU 1 1 C B005 Moises Alou MON 3 2 C B004 Scott Livingstone DET 2 3 C B004 Jeff Bagwell HOU 2 1 C B003 B.J. Surhoff MIL 3 3 C B003 Tony Phillips DET 3 1 C B003 David Justice ATL 2 2 C B004 Bob Zupcic BOS 3 1 C B001 Gary Varsho PIT 1 3 C B001 Mitch Webster LAD 2 2 C B002 Devon White TOR 2 2 C B005 Marquis Grissom MON 1 1 C B001 Brian McRae KCR 2 3 C B001 Tom Pagnozzi STL 3 1 C B004 Harold Baines OAK 2 2 C B004 Kevin Seitzer MIL 3 2 C B001 Pete Incaviglia HOU 2 2 C B001 Dan Gladden DET 3 3 C B002 Hal Morris CIN 2 1 C B005 Andre Dawson CHC 2 3 C B003 George Brett KCR 3 2 C B001 Wally Joyner KCR 2 1 C B004 Mike Scioscia LAD 1 1 C B002 Steve Finley HOU 1 1 C B005 Gary Sheffield SDP 3 3 C B004 Willie Wilson OAK 1 1 C B003 Randy Velarde NYY 2 3 C B003 Felix Jose STL 3 2 C B002 Tony Pena BOS 3 1 C B005 Mike Macfarlane KCR 3 1 C B003 Gary Disarcina CAL 1 3 C B003 Luis Sojo CAL 1 2 C B004 Harold Reynolds SEA 3 2 C B001 Eddie Murray NYM 1 2 C B001 Herm Winningham BOS 1 3 C B002 Eddie Murray NYM 1 3 C B001 Paul Sorrento CLE 3 3 C B003 Dave Hollins PHI 2 3 C B003 Omar Vizquel SEA 3 3 C B005 Mike Felder SFG 1 1 C B005 Jerry Browne OAK 2 3 C B003 Paul Molitor MIL 3 1 C B003 Larry Walker MON 3 2 C B005 Kurt Stillwell SDP 3 3 C B001 Matt Williams SFG 3 2 C B001 Walt Weiss OAK 1 1 C B004 Charlie Hayes NYY 1 1 C B002 Dwight Smith CHC 2 1 C B003 Mark Lemke ATL 1 1 C B002 Robin Ventura CHW 3 1 C B001 Kurt Stillwell SDP 3 1 C B004 Mickey Morandini PHI 3 2 C B003 Robby Thompson SFG 2 3 C B005 Pete O'Brien SEA 3 2 C B002 Greg Vaughn MIL 1 1 C B001 Ken Caminiti HOU 1 3 C B004 Pete Incaviglia HOU 1 2 C B005 Mickey Tettleton DET 2 2 C B001 John Vander Wal MON 3 3 C B005 Bernard Gilkey STL 2 2 C B005 Leo Gomez BAL 1 1 C B002 Bernard Gilkey STL 3 2 C B001 Mark Lemke ATL 2 3 C B002 Chuck Knoblauch MIN 2 1 C B002 Henry Cotto SEA 2 1 C B005 Mo Vaughn BOS 3 2 C B003 Scott Cooper BOS 1 2 C B002 Ivan Rodriguez TEX 1 1 C B004 Shane Mack MIN 2 2 C B001 Mike Bordick OAK 2 2 C B003 Harold Baines OAK 3 3 C B001 Rafael Belliard ATL 3 1 C B004 Paul Sorrento CLE 3 1 C B004 Ryne Sandberg CHC 1 1 C B001 Roberto Kelly NYY 2 2 C B002 Randy Velarde NYY 2 1 C B004 Ron Gant ATL 1 3 C B001 Mike Devereaux BAL 3 2 C B003 Robin Ventura CHW 2 2 ID mSysRowId 1 C2aI+wgZiVYqKtZ/+Ce8k7kCYdKqZ8p8BDYwK5gbyb0=-~+EkS0HVJgyil1XBFkrypbQ== Rarity ID Rarity Desc mSysRowId 1 Common 2 Rare 3 Very Rare SELECT DISTINCTROW FROM Cards; SELECT Cards.PlayerName, Cards.CardNo, Cards.Year, Brands.Brand, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] ORDER BY Cards.PlayerName; SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Bowman")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Donruss")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Fleer")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Topps")); SELECT Cards.CardNo, Cards.Year, Cards.[Brand ID], Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Bowman")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID] WHERE (((Brands.Brand)="Donruss")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID]) WHERE (((Brands.Brand)="Fleer")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID]) WHERE (((Brands.Brand)="Topps")); SELECT Cards.CardNo, Cards.Year, Brands.Brand, Cards.PlayerName, Cards.Team, Cards.NumInStock, Rarity.[Rarity Desc] FROM (Cards INNER JOIN Rarity ON Cards.[Rarity ID] = Rarity.[Rarity ID]) INNER JOIN Brands ON Cards.[Brand ID] = Brands.[Brand ID]) WHERE (((Cards.PlayerName) Like "" & [Enter Name] & "*")); EX19_AC_CH09_GRADER_CAP_HW_Instructions.docx Grader - Instructions Access 2019 Project Exp19_Access_Ch09_Cap - Trading Cards 1.0 Project Description: You and your partner Stann Dupp have a small business selling baseball cards online through eBay. As the more computer-savvy partner; you created an Access database with records of the cards you have in stock. As it turns out, Stann was attempting to manage the card inventory and ended up modifying crucial aspects of the database that impact the general operation of the database. You will reverse those changes and create other safeguards to protect from this happening again in the future. The database tables may already be normalized; however, you will examine the tables to verify. Steps to Perform: Step Instructions Points Possible 1 Start Access. Open the downloaded Access database named Exp19_Access_Ch09_Cap_Trading_Cards.accdb . Grader has automatically added your last name to the beginning of the filename. Save the file to the location where you are storing your files. You will first establish relationships between the Cards, Brands, and Rarity tables based on the common fields that they share. Open the Relationships window. Add the Cards , Brands , and Rarity tables to the layout. After creating a relationship between two tables, you will enforce referential integrity, which ensures that the relationship will remain intact if/when data is updated in either table. Furthermore, you will ensure that all changes to the primary key in your Cards table will be reflected in the foreign keys that exist in the Rarity table by selecting the Cascade Update Related Fields option. Create a relationship between the Cards and Rarity tables tables, ensuring you check the Enforce Referential Integrity and Cascade Update Related Fields options for the relationship. After also establishing the relationship between the Cards and Brands tables, in the same