Can you please help me figure out a Primary Key and Foreign Key for each table a
ID: 3666308 • Letter: C
Question
Can you please help me figure out a Primary Key and Foreign Key for each table and the functional dependance of each table.
BRANCH BRANCH NUM BRANCH NAME BRANCH LOCATION NUM EMPLOYEES I Henry Downtow 16 Rivervlew Heney u The Hill 1289 Bedford 3 Henry Brentwood Brenwood Mall 15 Henry Eastshore Mall PUBLISHER PUELISHER CODE PUBLISHER NAMI CITY Sauk Ciry W New York Boalder CCo A3I BP BY CT FA FS Arkhani House Areade Publishing Bisic Books Herkley Publishing Back Bay Books Courou Technology Fawcett Books Farrar Strauk and Girocw Youk HarperColins PubliskersNow York Now York loston Ne: York New York Los Angeles New Yark JT LIk MP PE PL eremy P. Tarcher Lh Books MePherson and Co Penguin UTSA Plusme Patnam Publishing Group New York Random House Schoken Books Seribner Simion nd Sebuster Scholastio Trade Tinton Press Tor Books Thanes and ludsee Touchstone Books Vintage Bools W.W. Norton New York New Yorl New York SB Nen York New York New York Newtowa CT New York New Yorlk Westport CT New York New York ST T.S TB TH vBExplanation / Answer
1. BRANCH Table:
Primary Key : BRANCH_NUM, this is Foreign Key for Table INVENTORY
2. PUBLISHER Table
Primary Key: PUBLISHER_CODE, this is Foreign Key for BOOK Table
3. AUTHOR Table:
Primary Key: AUTHOR_NUM, this is Foreign Key for WROTE Table
4. BOOK Table:
Primary Key: BOOK_CODE, this is Foreign Key for INVENTORY and WROTE Table