Raise money for the event

Assignment Help Basic Computer Science

Reference no: EM13825409

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.

Reference no: EM13825409

Questions Cloud

Bridget pledged shares of publicly traded stock : Five years ago Bridget decided to purchase a limited partnership interest in a fast-food restaurant conveniently located near the campus of Southeast State University. Bridget pledged shares of publicly traded stock. The restaurant did a good busines..

Defines general cryptography concepts : Write a 1-page summary that defines general cryptography concepts and how they can be applied to your future IT career.

Discuss how tirgaran ltd should account for these costs : Discuss how Tirgaran Ltd should account for these costs. Provide journal entries with an explanation of why these are the appropriate entries

Raise money for the event : 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 an..

File sharing program : Explain what your process was and how the experiment went. Were you successful? What did you learn from the experience ?Experiment choice #1: File Sharing Program Download a current version a file sharing program such as BitTorrent and use it to dow..

Law of death penalty in the united states : The US Supreme Court has often dealt with the question of whether the death penalty is cruel and unusual punishments, sometimes seeming to hold that it is cruel and unusual punishment and sometimes seeming to hold that particular ways of administe..

Print out the average score accurate to two decimal places : print out the average score accurate to two decimal places.

What type of noncash scheme is baker most likely : Baker is an auditor for ABC Company. As part of a proactive fraud audit (using CAATs), Baker runs the following tests: (1) a review of the sales register for dormant customer accounts that posted a sale within the last two months; Taken together, wha..

User Account

All Pages