# Create the table that would result from applying a DIFFERENCE relational operator of your result from Problem 29 to your result from Problem 30.

### Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900

Chapter
Section

### Database Systems: Design, Implemen...

13th Edition
Carlos Coronel + 1 other
Publisher: Cengage Learning
ISBN: 9781337627900
Chapter 3, Problem 31P
Textbook Problem
1 views

## Create the table that would result from applying a DIFFERENCE relational operator of your result from Problem 29 to your result from Problem 30.

Program Plan Intro

Table:

A table is a logical structure that represents an entity state. It is one of the components of database.

Relational Algebra:

Relational Algebra is a theoretical procedural query language having input as instances of relations and does operations on them to yield instances of relations as output.

SELECT Operator:

The SELECT relational operator is used to select required tuples present in the relation or tuple but do not display them.

PROJECT Operator:

The PROJECT relational operator is used to project the selected tuples that satisfy a given predicate. It projects required column data from a relation.

Given Table:

Table Name: CHARTER

 CHAR_TRIP CHAR_DATE CHAR_PILOT CHAR_COPILOT AC_NUMBER CHAR_DESTINATION CHAR_DISTANCE CHAR_HOURS_FLOWN CHA_HOURS_WAIT CHAR_FUEL_GALLONS CHAR_OIL_QTS CUS_CODE 10001 05-Feb-18 104 2289L ATL 936.0 5.1 2.2 354.1 1 10011 10002 05-Feb-18 101 2778V BNA 320.0 1.6 0.0 72.6 0 10016 10003 05-Feb-18 105 109 4278Y GNV 1574.0 7.8 0.0 339.8 2 10014 10004 06-Feb-18 106 1484P STL 472.0 2.9 4.9 97.2 1 10019 10005 06-Feb-18 101 2289L ATL 1023.0 5.7 3.5 397.7 2 10011 10006 06-Feb-18 109 4278Y STL 472.0 2.6 5.2 117.1 0 10017 10007 06-Feb-18 104 105 2778V GNV 1574.0 7.9 0.0 348.4 2 10012 10008 07-Feb-18 106 1484P TYS 644.0 4.1 0.0 140.6 1 10014 10009 07-Feb-18 105 2289L GNV 1574.0 6.6 23.4 459.9 0 10017 10010 07-Feb-18 109 4278Y ATL 998.0 6.2 3.2 279.7 0 10016 10011 07-Feb-18 101 104 1484P BNA 352.0 1.9 5.3 66.4 1 10012 10012 08-Feb-18 101 2289L MOB 884.0 4.8 4.2 215.1 0 10010 10013 08-Feb-18 105 4278Y TYS 644.0 3.9 4.5 174.3 1 10011 10014 09-Feb-18 106 4278V ATL 936.0 6.1 2.1 302.6 0 10017 10015 09-Feb-18 104 101 2289L GNV 1645.0 6.7 0.0 459.5 2 10016 10016 09-Feb-18 109 105 2778V MQY 312.0 1.5 0.0 67.2 0 10011 10017 10-Feb-18 101 1484P STL 508.0 3.1 0.0 105.5 0 10014 10018 10-Feb-18 105 104 4278Y TYS 644.0 3.8 4.5 167.4 0 10017

### Explanation of Solution

CHARTER TABLE:

Given Query: To create a table that would demonstrate the result from DIFFERENCE of applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes and applying the SELECT and PROJECT relational operators to the CHARTER table to return only the CHAR_TRIP, CHAR_PILOT, and CHAR_COPILOT attributes for charters flown by both employee 105 and employee 109.

Relational algebra formula for Difference Relational Operator:

The Difference relational operator is used to display the rows or records that are present only in the first table and not present in the second table.

Use of SELECT operator:

The SELECT relational operator is used to select required tuples present in the relation or tuple but do not display them.

One needs to select the attributes “CHAR_TRIP”, “CHAR_PILOT” and “CHAR_COPILOT” from all the attributes present in the CHARTER table.

The resulting CHARTER table can be displayed using the project operator. The algebraic symbol “π” symbolises the PROJECT operator.

• The project operator projects columns that satisfy a given predicate and yields all the values for the selected attributes.
• “π” is a unary operator which accepts only table as input.
• The PROJECT operator “π” is followed by the list of attributes to be returned as subscripts and then the relation listed as parenthesis.

STEP-1: “CHAR_TRIP”, “CHAR_PILOT” and “CHAR_COPILOT” is the attribute that needs to be returned from the relation CHARTER...

### Still sussing out bartleby?

Check out a sample textbook solution.

See a sample solution

#### The Solution to Your Study Problems

Bartleby provides explanations to thousands of textbook problems written by our experts, many with advanced degrees!

Get Started

Find more solutions based on key concepts
List and define the common attributes of tasks within a WBS.

Principles of Information Security (MindTap Course List)

Briefly describe a gib.

Precision Machining Technology (MindTap Course List)

What are some of the characteristics of a virtual team?

Principles of Information Systems (MindTap Course List)

By what factor do you increase the resistance to bending (about yy axis) if you were to use W1876 beam over W83...

Engineering Fundamentals: An Introduction to Engineering (MindTap Course List)

Explain Appleâ€™s view of user interface design, especially for apps.

Systems Analysis and Design (Shelly Cashman Series) (MindTap Course List)

How does defragmentation help increase performance on your computer?

Enhanced Discovering Computers 2017 (Shelly Cashman Series) (MindTap Course List)

If your motherboard supports ECC DDR3 memory, can you substitute non-ECC DDR3 memory?

A+ Guide to Hardware (Standalone Book) (MindTap Course List)

Which Cisco command lists configured VLANs on a switch?

Network+ Guide to Networks (MindTap Course List)

What causes most electric shock in the welding industry?

Welding: Principles and Applications (MindTap Course List)