Microsoft Access

Every runner is required to solicit sponsors to help raise money for the event. There are two types of sponsors - corporate and personal.Design a second table that will store data about the sponsors for each runner.

1.Make a list of the field names and field types you plan to include in the table. What fields are you going to put in this table? What are their field types? Would it make sense to reduce any of the field sizes? Do you need to add captions?

2.Make sure you choose a field to act as the primary key. Remember the primary key field must uniquely identify each record (runner) in the table.

3.In addition, this table will be the "many" in a "one to many" relationship with the Runner table. Therefore, you will also need to include a common field in this table so that you can join the two tables in a one (runner) to man (sponsors) relationship. One way to achieve this is to repeat the primary key from the "one" table in the "many" table.