BuyFindarrow_forward

Database Systems: Design, Implemen...

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

Solutions

Chapter
Section
BuyFindarrow_forward

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

Chapter 3 Solutions

Database Systems: Design, Implementation, & Management
Show all chapter solutions
add
Ch. 3 - Create the basic ERD for the database shown in...Ch. 3 - Create the relational diagram for the database...Ch. 3 - Use Figure Q3.13 to answer Questions 1317. FIGURE...Ch. 3 - Create the table that results from applying a...Ch. 3 - Write the relational algebra formula to apply an...Ch. 3 - Create the table that results from applying an...Ch. 3 - Using the tables in Figure Q3.13, create the table...Ch. 3 - Suppose you have the ERD shown in Figure Q3.18....Ch. 3 - What are homonyms and synonyms, and why should...Ch. 3 - How would you implement a l:M relationship in a...Ch. 3 - Identify and describe the components of the table...Ch. 3 - Identify the primary keys. FIGURE Q3.22 THE...Ch. 3 - Identify the foreign keys. FIGURE Q3.22 THE...Ch. 3 - Create the ERM. FIGURE Q3.22 THE CH03_THEATER...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Suppose you wanted quick lookup capability to get...Ch. 3 - What would be the conceptual view of the INDEX...Ch. 3 - For each table, identify the primary key and the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Create the ERD to show the relationship between...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Describe the type(s) of relationship(s) between...Ch. 3 - Create the ERD to show the relationships among...Ch. 3 - Create the relational diagram to show the...Ch. 3 - For each table in the database, identify the...Ch. 3 - Create the ERD to show the relationship between...Ch. 3 - Create the relational diagram to show the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Create the ERD to show the relationships among...Ch. 3 - Create the relational diagram to show the...Ch. 3 - For each table, identify the primary key and the...Ch. 3 - Do the tables exhibit entity integrity? Answer yes...Ch. 3 - Do the tables exhibit referential integrity?...Ch. 3 - Identify the TRUCK tables candidate key(s). FIGURE...Ch. 3 - For each table, identify a superkey and a...Ch. 3 - Create the ERD for this database. FIGURE P3.17 THE...Ch. 3 - Create the relational diagram for this database....Ch. 3 - For each table, identify each of the following...Ch. 3 - Create the ERD. (Hint: Look at the table contents....Ch. 3 - Create the relational diagram. FIGURE P3.24 THE...Ch. 3 - Modify the ERD you created in Problem 25 to...Ch. 3 - Create the relational diagram for the design you...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying...Ch. 3 - Create the table that would result from applying a...

Additional Engineering Textbook Solutions

Find more solutions based on key concepts
Show solutions add
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)