Make a list of the field names and field types

Assignment Help Basic Computer Science

Reference no: EM13824621

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: EM13824621

Questions Cloud

Availability of the organization information assets : Organizational end users are generally in the background when it comes to protecting the IT infrastructure. As the chief security officer (CSO), develop a security awareness training communication plan for these users. Your plan must be in nontechnic..

Prepare a fixed overhead variance analysis : Prepare a cost variance analysis for each variable cost component for Met Towels in January 2005. Prepare a fixed overhead variance analysis for Met Towels in January 2005

Secure encrypted communications : Transmitting personal and business data and information over secure communication channels is critical. In some cases it is required, especially when personally identifiable information is being transmitted. Credit card numbers, Social Security Numbe..

The program by three-dimensional array : Write a small program that will read in 52 cards from a file, shuffle the cards, print the unshuffled deck to the screen, and print the shuffled deck into new file. The unshuffled deck of cards should be represented in the program by three-dimensiona..

Make a list of the field names and field types : 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?

What is your plan for bringing about transformational change : What is your plan for bringing about the transformational change you envision? Why do you believe this approach will be successful?

Prepare a performance report for humphrey catalog project : Prepare a performance report for the Humphrey Catalog project. Offer a plausible explanation for SA's performance on the Humphrey project

Target cost and cost reduction to achieve target cost : Target Cost And Cost Reduction To Achieve Target Cost

Logical development of appropriate data types : Demonstrate professional presentation skills by the development of a professional business presentation to the client outlining the development process for this Database Management System project.

User Account

All Pages