Every runner is required to solicit sponsors to help raise money for the event.
ID: 667223 • Letter: E
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 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 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
Explanation / Answer
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.
Runner_ID
Runner_name
INT
VARCHAR
Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.