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

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 Running club table Student_id Student_name Club id Club_name 245 Bob Smith 001 Hyde Park Harriers 265 Xi Wang 002 Midday Milers 987 Anthony Marshall 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...

What is the difference between a null hypothesis, H0, and an alternative hypothesis, H1?

Assume the market is equally populated by two kinds of firms: ones with profitable and ones with unprofitable internal forecasts. Assume that all firms are equity financed, and that all profitable...

1 9 A certificate of deposit usually has: 1 point 0 0 . 4 9 . 0 8 Multiple Choice a penalty for early withdrawsl. a variable rate of return. no minimum deposit amount. a high safety risk for savers....

What is an example of constructive feedback? provide reference