Define ssn of salesman by using database of business trips, Database Management System

Consider the subsequent relations for a database which 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(TripID, Account#, Amount)
Specify the subsequent queries in relational algebra:
(i) Give the details (all attributes of TRIP) for trips which exceeded $2000 in expenses.
(ii) Print the SSN of salesman who took trips to ‘Honolulu'
(iii) Print the trip expenses incurred through the salesman with SSN= ‘234-56-7890'.Note in which the salesman might have gone on more than one trip. List them individually

Ans: (i) πTRIP.* (σ amount > 2000 (TRIP EXPENSE))
(ii) π SSN (σ to_city = ‘Honolulu' (TRIP))
(iii) πEXPENSE.tripid, amount (σ SSN = ‘234-56-7890' (TRIP EXPENSE))

Posted Date: 5/10/2013 4:02:45 AM | Location : United States







Related Discussions:- Define ssn of salesman by using database of business trips, Assignment Help, Ask Question on Define ssn of salesman by using database of business trips, Get Answer, Expert's Help, Define ssn of salesman by using database of business trips Discussions

Write discussion on Define ssn of salesman by using database of business trips
Your posts are moderated
Related Questions
Distributed Control and Data sharing: The geographical distribution of an organization can be showed in the distribution of the data; if a number of different sites are linked to e

growing phase and shrinking phase are disjoint, why ?

What are called journaling file systems? File systems that support log disks are known as journaling file systems.

Create Student DB and perform delete operation? STUDENT (name, student#, class, major) COURSE (course name, course#, credit hours, department) SECTION (section identifier, co

Functional Dependency Consider a relation R that has 2 attributes A and B. The attribute B of the relation is functionally dependent on the attribute A if and only if for every

The database will enable college administrators the ability to track students initial major. This will help college officials decide how best to prepare students for their goals an

Q. Describe how an ER schema can be represented by relation schemas and constraints arising from ER design can be mapped to constraints on a relation schema.     The entity rela


The State of Newyork certifies firefighters throughout state keep track all of them, as well as the state’s of fire departments. Each fire department has unique department number

Define Deadlock avoidance These protocols as well ensure that the system will never enter a deadlock state although the way it is done is different from deadlock prevention. I