Task 1IndexingImplement SQL script solution1.sql that performs the actions listed below.1. First, the script finds query processing plans for each one of the queries listedbelow. Use EXPLAIN PLAN statement and a script showplan.sql to display thequery processing plansFind all distinct pair of values of receipt-date (L_RECEIPTDATE) anddiscount (L_DISCOUNT) in the relational table LINEITEM.а.b.Find the total number of rows in the relational table ORDERS where thetotal price (O_TOTALPRICE) is greater than the average total price(O_TOTALPRICE).Find the total number of ORDERS submitted by each customer, list thevalues of an attribute O_CUSTKEY together with the total number of orderssubmitted. Do not ignore customers who submitted no orders.Find the total number of discount (L_DISCOUNT) in the relational tableC.d.LINEITEM.е.Find the total number of distinct values in a column O_ORDERPRIORITY ina relational table ORDERS.2. Next, the script creates the smallest number of indexes such that processing ofeach one of the queries listed above benefits from the existence of at least oneindex. 3. Next, script lists the query processing plans for each one of the queries listed ina step. Use EXPLAIN PLAN statement and a script showplan.sql to display thequery processing plans.4. Finally, the script drops all indexes created in a step (2).Note, the report from processing of the script must have NO syntax errors!

Answered: 2. Next, the script creates the…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Similar questions

Explain the five different file structures (Pile, Sequential file, Indexed Sequential file, Indexed file, and hashed file). And analyze the components, attributes, structure, and operations or implementation guidelines of each file organization.
1. Design a database with the help of DBMS to keep track of information for an art museum. Assume that the following requirements were collected: The museum has a collection of art objects. Each art object has a unique identification, an artist (if known), a year (when it was created, if known), a title, an epoch (Renaissance, Modern, Ancient, etc.), and a description. The arts objects are classified in the museum in several ways as discussed below: Arts objects are categorized based on their type. The main types are: painting and sculpture, plus another type they called “other” to accommodate objects that do not fall into one of the two main types. A painting has a paint type (oil, watercolor, etc.), material on which it is draw on (paper, canvas, wood, etc.), and style (modern, abstract, impressionism, etc.). A sculpture has a material from which it was created (wood, stone, iron, etc.), height, weight, and style. An art object in the other category has a type (print, photo,…
Establish a database containing several predefined functions.
def furthest_apart_in_state(directorypath, state):"""given the directory where to find entity and region information and a state,return a tuple of the two entity IDs in that state that are furthest apart.If there is only one entity in the state, return None.If there are no entities in the state, return None.:param directorypath::param state::return: tuple of two entity IDs"""passFILE LOOKS LIKE THIS: ID,City,State,Latitude,LongitudeA45419E,Plattsburgh,NY,44.704021,-73.471148A19312D,Aiken,SC,33.554433,-81.69588A90172S,Tuscaloosa,AL,33.170238,-87.616169A19394D,Alexandria,VA,38.819853,-77.059645A27218D,Pittsburgh,PA,40.47441,-79.950968A68626D,Meadville,PA,41.611599,-80.114891A17494D,Allentown,PA,40.602658,-75.469236A86034S,Tonawanda,NY,42.99704,-78.878659A45142D,Asheville,NC,35.602711,-82.567281A38298S,Atlanta,GA,33.844371,-84.47405A14497Y,Roswell,GA,34.055198,-84.370475A25954D,Austin,TX,30.326374,-97.771258B46374X,Fairhope,AL,30.480713,-87.861306B52199S,Cedar…
We would like to develop a database that captures the following requirements. A University student can enrol in a course and at least in one major. In fact, a student can enrol in many majors within that course. During the semesters, a student can enrol in units. We want to capture in which year and in which semester a student enrolled in each unit. We have two semesters: Semester 1 and Semester 2. A unit has a code, a title and the number of credit points. We would like also to record the student’s GPA. A course has a code and a name. A major has a code and a name. Also, a major belongs to a course. A unit can be part of either a course or a major. A unit can also be shared across different courses and different majors. Important to note: Provide your design in a textual form, i.e. Entity(Attribute1, Attribute2, Attribute3, …). Make sure that the primary keys of each entity are underlined (Attribute1 in the example above) and foreign keys are indictated in bold (Attribute3 in…
Task 1: The InstantRide Management team founded a new team for car maintenance. The new team is responsible for the small maintenance operations for the cars in the InstantRide system. The main idea is to take actions faster and minimize the time spent for the maintenance. Therefore, the Car Maintenance team wants to store MAINTENACE_TYPE_ID (char(5)) and a MAINTENANCE_TYPE_DESCRIPTION (varchar(30)) in the database. Using MAINTENANCE_TYPE_ID as the PRIMARY KEY, create a new table, MAINTENANCE_TYPES, and send the table description with the column names and types to the Car Maintenance team.

Recommended textbooks for you

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Computer Networking: A Top-Down Approach (7th Edi…

Computer Engineering

ISBN:

9780133594140

Author:

James Kurose, Keith Ross

Publisher:

PEARSON

Computer Organization and Design MIPS Edition, Fi…

Computer Engineering

ISBN:

9780124077263

Author:

David A. Patterson, John L. Hennessy

Publisher:

Elsevier Science

Network+ Guide to Networks (MindTap Course List)

Computer Engineering

ISBN:

9781337569330

Author:

Jill West, Tamara Dean, Jean Andrews

Publisher:

Cengage Learning

Concepts of Database Management

Computer Engineering

ISBN:

9781337093422

Author:

Joy L. Starks, Philip J. Pratt, Mary Z. Last

Publisher:

Cengage Learning

Prelude to Programming

Computer Engineering

ISBN:

9780133750423

Author:

VENIT, Stewart

Publisher:

Pearson Education

Sc Business Data Communications and Networking, T…

Computer Engineering

ISBN:

9781119368830

Author:

FITZGERALD

Publisher:

WILEY

SEE MORE TEXTBOOKS

2. Next, the script creates the smallest number of indexes such that processing of each one of the queries listed above benefits from the existence of at least one index.