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

The Answer is in the image, click to view ...

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

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 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...

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...

QUESTION 2 The database table structure below captures Students that commute to the University by bike (Student Bike-Commuter table). Each student is assigned one Bike Storage Building where they can...

UTS Business Statistics 26134 Report (Group Assignment) SPRING 2017 Assessment Value: This assignment is worth 20% It is be completed in: A GROUP OF 3, 4 or 5 STUDENTS Due times and dates: Due...

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...

Figare 3 Cas Drawer Sommary Sined Restaurant and Catering Services Sally Jones, restaurant manager, supervises 10-20 full- and part-time individuals who provide breakfast, lunch, and light dinner...

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...

eu Assume MLreadint and MLwriteint are primitives with side effects for inputoutput and consider the ML expression add1 of type int: let val x = MLreadint() in MLwriteint(x+1); x end (i) Give an...

PROGRAMME HANDBOOK: JANUARY 2016 INTAKE ASSIGNMENT 2: HUMAN RESOURCES DEVELOPMENT Read the case study below and answer the questions that follow. National HRD in Finland, Russia, and South Africa...

Given the following project network, baseline, and status information, develop status reports for periods 14 and complete the project summary graph (or a similar one). Report the final SV, CV, CPI,...

27 months (2.25 years) ago, your institution entered into a threeyear crosscurrency interest rate swap with a certain virtuous Australian airline company. The swap agreement was overthecounter with...

\ table [ [ Soles revenue,$ 1 8 2 . 0 0 0 ] , [ Cort of goods sold, 1 0 9 , 0 0 0 ] , [ Gross proht, 7 3 , 0 0 0 ] , [ Operating expenses ( includes depreciation of $ 2 0 , 0 0 0 ) , 4 8 , 0 0 0 ] ,...

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...