Identify the relational keys in the following two tables. Branch branchNo street city postcode SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX BS99 INZ NW10 6EU BO05 22 Deer Rd...


Identify the relational keys in the following two tables.<br>Branch<br>branchNo street<br>city<br>postcode<br>SWI 4EH<br>16 Argyll St Aberdeen AB2 3SU<br>163 Main St Glasgow GI1 9QX<br>BS99 INZ<br>NW10 6EU<br>BO05<br>22 Deer Rd<br>London<br>BO07<br>B003<br>BO04<br>32 Manse Rd Bristol<br>BO02<br>56 Clover Dr London<br>Staff<br>staffNo fName IName position<br>sex DOB<br>salary branchNo<br>SL21<br>John<br>White Manager<br>M<br>1-Oct-45<br>30000<br>BO05<br>SG37<br>Ann<br>Beech<br>Assistant<br>F<br>10-Nov-60 12000<br>BO03<br>SG14<br>David<br>Ford<br>Supervisor M<br>24-Mar-58 18000<br>BO03<br>SA9<br>Mary<br>Howe<br>Assistant<br>F<br>19-Feb-70<br>9000<br>BO07<br>SG5<br>Susan<br>Brand Manager<br>F<br>3-Jun-40<br>24000<br>BO03<br>SL41<br>Julie<br>Lee<br>Assistant<br>F<br>13-Jun-65<br>9000<br>BO05<br>Tabel<br>Superkey<br>Candidate<br>Primary Key<br>Alternate<br>Foreign Key<br>Key<br>Keys<br>Branch<br>Staff<br>

Extracted text: Identify the relational keys in the following two tables. Branch branchNo street city postcode SWI 4EH 16 Argyll St Aberdeen AB2 3SU 163 Main St Glasgow GI1 9QX BS99 INZ NW10 6EU BO05 22 Deer Rd London BO07 B003 BO04 32 Manse Rd Bristol BO02 56 Clover Dr London Staff staffNo fName IName position sex DOB salary branchNo SL21 John White Manager M 1-Oct-45 30000 BO05 SG37 Ann Beech Assistant F 10-Nov-60 12000 BO03 SG14 David Ford Supervisor M 24-Mar-58 18000 BO03 SA9 Mary Howe Assistant F 19-Feb-70 9000 BO07 SG5 Susan Brand Manager F 3-Jun-40 24000 BO03 SL41 Julie Lee Assistant F 13-Jun-65 9000 BO05 Tabel Superkey Candidate Primary Key Alternate Foreign Key Key Keys Branch Staff

Jun 10, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here