Question

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.

Microsoft Access

Answer 1

OK...Here is the design of Runner and Sponsor table....

1)

Runner_ID	Runner_name
INT	VARCHAR

Runner_ID	Sponsor_ID	LOGO	LOGO_on_tshirt	Contract_term	Total_Amoun	Start_date	Expiry_Date
INT	INT	BLOB	BLOB	INT	INT	Date	Date

------------------------------------------------------------------------------------------------------------------------------------

2) We use Rnunner_id as primary key in Runner table.

Sponsor_id as primary key in Sponsor table ans Runner_id act as foreign key.

-----------------------------------------------------------------------------------------

3)

Runner has more than one sponsor ships. Any how only one sponsor is act as main one which prints logo in large size..And remaining small sponsors also included for Runner. So one to many relationship holds. So we are using runner_id as foreign key in sponsor table.