Question: The database table structure below captures Student details and the membership to a Running Club. It shows a Student table and a Running club table.

The database table structure below captures Student details and the membership to a Running Club. It shows a Student table and a Running club table. A student can only be a member of one running club, but a running club can have many student members. What is the most appropriate Foreign Key and where should we place the Foreign Key in this table structure so that we can link the two tables? (30 words maximum)

Student table Student id Student_name 245 Bob Smith 265 Xi Wang 987 Anthony Marshall Running club table Club id Club_name 001 Hyde Park Harriers 002 Midday Milers 003 UQ Runners 004 Brisbane Harriers

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

QUESTION 2 The database table structure below captures Student details and the membership to a Running Club. It shows a Student table and a Running club table. A student can only be a member of one...

The database table structure below captures Student details and the membership to a Running Club. It shows a 'Student table and a 'Running club table'. A student can only be a member of one running...

Part 1: Planning D Introduction Planning for a project is an important skill, so the TT284 EMA includes an element to encourage you to think about the work you will have to complete, how long the...

The organiser of the Garden City Harriers Running Club requires you to design and implement a web-based database application to assist with the running of the club. The website will be called The...

1)Financial Reporting - The Procter & Gamble The financial statements of P&G are presented in Appendix B. The companys complete annual report, including the notes to the financial statements, can be...

First visit HYPERLINK "http://www.tdan.com/view-articles/5174/" http://www.tdan.com/view-articles/5174/ and learn what data related business rules are. Business rules are precisely written and...

a. 4. Experienced students may serve as mentors if they are at least age 21 and have at least three years of post-secondary education. Populate the Mentor column as follows: Enter a formula using...

Step 0 Before you get started, you must make one minor revisions to your program. I've revised a property of the ClassSection class ( see the UML diagram ) . Now the registrationNumber is an integer...

ACCT2060- Accounting for Organisations and Society Marking Rubric for Individual assignment Semester 1 2016 High distinction 10 Distinction 7.5 Credit 6.5 Pass 5 Below standards 2.5 Title page, and...

2. Simple harmonic oscillator is always an approximation. Real problems always have po- tential of the form V(r) ki + b" + ci + . The contribution beyond ki are 1 called anharmonic terms. (a) Show...

Excel Learning Systems Inc. was organized on May 31, 2010. Projected selling and administrative expenses for each of the first three months of operations are as follows: June $117,400 July 110,500...

Question 9 1 pts A . idrey has severe obstructive sleep apnea. The CPAP machine was unsuccessful in giving her more than 4 hours of sleep at night. Finally she was referred to a specialist. Can you...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...