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

Ask an Expert

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

Write your message here..

Related Questions

Explain the exec statement in sql, Explain the Exec statement in SQL An... Explain the Exec statement in SQL Ans: Exec statement has the structure    EXEC SQL END-EXEC   Embeded SQl statements are of a form identical to non embedded SQL statem

What database management system, Company XYZ is an advertising company. It... Company XYZ is an advertising company. It has its own website but the search facilities offered are not reliable. The company is willing to invest to acquire new machines and sof

Insertion anomaly-data redundancy, Insertion Anomaly: Inability to show ce... Insertion Anomaly: Inability to show certain information-The primary key of the over relation be (enrolment number, Cno). Any new tuple to be inserted in the relation should have

What is catalog in dbms, What is catalog in DBMS? Catalog - A relationa... What is catalog in DBMS? Catalog - A relational DBMS maintains information about every table and index in which it contains. A catalog is a collection of special tables that st

Draw entity relationship diagram, Draw entity relationship diagram for the ... Draw entity relationship diagram for the following scenario. A university has many departments whereas each department belongs to that particular uni. That uni has also many bui

What are the advantages of dbms, What are the advantages of DBMS ? 1. ... What are the advantages of DBMS ? 1. Centralized Management and Control - One of the major advantages of using a database system is in which the organization could exert, thr

Remove all transitive dependencies - dependency diagram, 1. Use the Invoice... 1. Use the Invoice table structure shown below to answer the following questions: a)  Draw the dependency diagram and identify the primary key and all dependencies, including al

Write a query to find name from the relational algebra, Consider the relati... Consider the relations City (city_name, state) Hotel (name, address) City_hotel (hotel_name, city_name, owner) Answer the following queries in relational algebra (i) Find

By the relations get details of employees working in sql, Consider the rela... Consider the relations: PROJECT(proj#,proj_name,chief_architect) EMPLOYEE(emp#,emp_name) ASSIGNED(proj#,emp#) Use relational algebra to express the subsequent queries: (i) Get

3-schema architecture, Gyan Gurukul is a software company that provides sof... Gyan Gurukul is a software company that provides software related solution. Ashutosh Dubey who is the director of Gyan Gurukul want a three-level schema architecture for the Gyan G