Homework Sourseyour company is sponsoring a 10K run to raise funds for a br
your company is sponsoring a 10K run to raise funds for a breast cancer foundation. You have been asked to design a database to store information related to the marathon.
One of the tables you will create is the RUNNER table. This table will be used to keep track of data for all the runners who have entered to run in the 10K race.
1. Make a list of the fields names and field types you plan to include in the table. What fields are you going to in this table ? What are their field types ? Would it make sense to reduce any of the fields sizes ? Do you need to add captions ?
2. Which field will be the primary key ? 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 ?
your company is sponsoring a 10K run to raise funds for a breast cancer foundation. You have been asked to design a database to store information related to the marathon.
One of the tables you will create is the RUNNER table. This table will be used to keep track of data for all the runners who have entered to run in the 10K race.
1. Make a list of the fields names and field types you plan to include in the table. What fields are you going to in this table ? What are their field types ? Would it make sense to reduce any of the fields sizes ? Do you need to add captions ?
2. Which field will be the primary key ? 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 ?
your company is sponsoring a 10K run to raise funds for a breast cancer foundation. You have been asked to design a database to store information related to the marathon.
One of the tables you will create is the RUNNER table. This table will be used to keep track of data for all the runners who have entered to run in the 10K race.
1. Make a list of the fields names and field types you plan to include in the table. What fields are you going to in this table ? What are their field types ? Would it make sense to reduce any of the fields sizes ? Do you need to add captions ?
2. Which field will be the primary key ? 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 ?
Solution
I think the above would help you.Here the primary key is well written
