Consider the following relations for a database that keeps, Ask an Expert

Engineering

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 the above schema, stating any assumptions you make. Then specify the following queries in relational algebra:

a. Give the details (all attributes of TRIP relation) for trips that exceeded $2000 in expenses.

b. Print the SSN of salesman who took trips to ‘Honolulu'.

c. Print the total trip expenses incurred by the salesman with SSN = ‘234-56-7890'

View complete question

Computer Engineering, Engineering

Category:- Computer Engineering
Reference No.:- M91626475

Have any Question?Write your Review or question?

Related Questions in Computer Engineering

Regards to cin what programming situations would the use of

Regards to C++ In what programming situations would the use of an array be beneficial? What situations would not warrant the use of an array? Provide an example showing why. Research the concept of C++ vectors. Describe ...

The power of the market - 1990watch and discuss the video

The Power of the Market - 1990 Watch and discuss the video - The Power of the Market http://www.freetochoose.tv/program.php?id=ftc1990_1&series=ftc90 Links to an external site. By discuss I mean: Overall, what did you ...

Study the information given below and answer the

Study the information given below, and answer the questions. For a long time, the Royal Victoria Hospital (RVH) worked with an information system that consisted of a mix of paper-based files and small independent databas ...

One of the issues in early virtualization use was slow

One of the issues in early virtualization use was slow performance due to translation of system commands. Which piece of computer hardware was revised to run hypervisors natively? Also There are three "families" of opera ...

Task allocation and deallocation of mono-dimensional and

Task Allocation and deallocation of mono-dimensional and bi-dimensional arrays represented by pointers a. Declare and implement a function CreateArray(...) that returns a pointer to an array of n integers. b. Declare and ...

Simple scenariobull at the beginning of each semester

Simple Scenario • At the beginning of each semester, students get a course catalogue containing a list of course offerings for the semester. Information about each course, such as professor, department, and prerequisites ...

Suppose you are given the following consumption and income

Suppose you are given the following consumption and income data: Consumption 100 190 280 370 460 550 Income 0 100 200 300 400 500 Obtain an equation for the consumption function. Use your fu ...

Please elaborate your understanding about how rfid and nfc

Please elaborate your understanding about how RFID and NFC work. What are the current security considerations and challenges?

Question rns versus gsd representation we are contemplating

Question : RNS versus GSD representation We are contemplating the use of 16-bit representations for fast integer arithmetic. One option, radix-8 GSD representation with the digit set [-5,4], can accommodate four-digit nu ...

Explain the risk of having hacking tools installed on your

Explain the risk of having hacking tools installed on your computer and why you should contact local law enforcement agencies before installing those tools.

4,153,160 Questions Asked
13,132 Experts
2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Recent Questions

Ask Computer Engineering Expert