(50 points) Consider the following relations for a database that keeps track of business trips of salespersons in a sales office 3 SALESPERSON (SSN, Name, Start Year, Dept No) TRIP (SSN, From City, To City, Departure Date, Return Date, Trip ID) EXPENSE (Trip ID, Account , Amount) Draw the relational schema diagram Specify the foreign keys for this schema, stating any assumptions you make

Question

(50 points) Consider the following relations for a database that keeps track of business trips of salespersons in a sales office 3  SALESPERSON (SSN, Name, Start Year, Dept No) TRIP (SSN, From City, To City, Departure Date, Return Date, Trip ID) EXPENSE (Trip ID, Account , Amount) Draw the relational schema diagram  Specify the foreign keys for this schema, stating any assumptions you make

Accepted Answer

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

Question

(50 points) Consider the following relations for a database that keeps track of business trips of salespersons in a sales office 3. SALESPERSON (SSN, Name,

Step by Step Solution

Step: 1

Get Instant Access to Expert-Tailored Solutions

Step: 2

Step: 3

Ace Your Homework with AI

Recommended Textbook for

Understanding Oracle APEX 5 Application Development