expand icon
book Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe cover

Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

النسخة 6الرقم المعياري الدولي: 0136086209
book Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe cover

Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe

النسخة 6الرقم المعياري الدولي: 0136086209
تمرين 9
Consider the following relations for a database that keeps track of business trips of salespersons in a sales office:
SALESPERSON (SSN, Name, Start_Year, Dept_No)
TRIP (SSN, From_City, To_City, Departure_Date, Return_Date, Trip_ID)
EXPENSE (Trip_ID, Account#, Amount)
Specify the foreign keys for this schema, stating any assumptions you make.
التوضيح
موثّق
like image
like image

The schema of this question has the foll...

close menu
Database Systems 6th Edition by Ramez Elmasri, Shamkant B. Navathe
cross icon