READ EVERYTHING BEFORE ANSWERING PLEASE. QUESTION: Describe and explain how the following database application technique

[answerhappygod]

READ EVERYTHING BEFORE ANSWERING PLEASE.
QUESTION:
Describe and explain how the following database application
techniques may be employed to enhance and extend the performance of
your database:
Indexes •
Triggers •
Stored Procedures Ideally, you should attempt to implement (and
evidence via screenshots) these coding techniques but if that is
not possible, then at least explain what they do and what benefits
they bring PLUS supplying the SQL code you would have executed.
code given:
/ Java program for implementation

// of Lagrange's Interpolation

import java.util.*;

class GFG

{

// To represent a data point

// corresponding to x and y = f(x)

static class Data

{

int x, y;

public Data(int x, int y)

{

super();

this.x = x;

this.y = y;

}

};

// function to interpolate the given

// data points using Lagrange's formula

// xi corresponds to the new data point

// whose value is to be obtained n

// represents the number of known data points

static double interpolate(Data f[], int xi, int n)

{

double result = 0; // Initialize result

for (int i = 0; i < n; i++)

{

// Compute individual terms of above formula

double term = f.y;

for (int j = 0; j < n; j++)

{

if (j != i)

term = term*(xi - f[j].x) / (f.x - f[j].x);

}

// Add current term to result

result += term;

}

return result;

}

// Driver code

public static void main(String[] args)

{

// creating an array of 4 known data points

Data f[] = {new Data(0, 2), new Data(1, 3),

new Data(2, 12), new Data(5, 147)};

// Using the interpolate function to obtain

// a data point corresponding to x=3

System.out.print("Value of f(3) is : " +

(int)interpolate(f, 3, 4));

}

}
THE CODE SHOULD BE SQL.
SCENARIO Dazzle has over 40 years of experience in the
residential and commercial field of the electrical distribution
sector. They specialize in recessed lighting, dimming, lamps,
ballasts, and much more from quality manufacturers such as: Juno
Lighting, Iris™, Lutron, Philips, Advance, GE, Pass & Seymour
Legrand, Lithonia Lighting, as well as many others. The company is
passionate about making your experience as a customer satisfying.
They are not a retail company and they do not sell direct to the
public. However, they are not only wholesalers but also ready to
assist you with product information, product selection, and all
your order needs. The company is authorized distributors of all the
above products and they keep many in their local inventory. The
company headquarters are in Manchester, United Kingdom. This is
where the Chief Executive and the Board are based, along with
central support functions like HR, IT, Legal etc. The CEO and Board
thus constitute the senior management and are responsible for all
strategic decision-making. The company is global, large and complex
and, as such, is structured along its product lines, with each
product category being headed by a Product Director. Each Product
Director is responsible for all aspects of that division and thus
makes all tactical-level decision. They are based around the world.
Each Product Director reports directly to the Senior Management
back in London. There are eight Product Directors, heading up the
following product divisions: • Dimming (several different dimming
options to achieve the exact light level) • Commercial Lighting
(for restaurants, housing and commercial buildings) • Light Bulbs
(LED, decorative, energy saving, spotlight and fluorescent tubes) •
Wiring Devices (wiring devices portfolio extends to door entry,
building automation and domestic circuit protection systems) •
Ballasts (the ballast regulates the current to the lamps and
provides sufficient voltage to start the lamps.) • Circuit Breakers
(Low-voltage, Magnetic, Thermal magnetic and Magnetichydraulic
circuit breakers.) • Landscape Lighting (private gardens and public
landscapes) • Floor Heat (for use under most floor finishes
including carpet, wood, laminate, vinyl, tile and stone.) Within
each product division there are many different factories and
specialized manufacturing/testing facilities – some in urban
settings, others in rural areas for field testing. Each site
factory is under the control of a Site Manager who is responsible
for all local operational decision-making. Each Site Manager
reports directly to the relevant Product Director. The date
(DDMMYYYY), country of origin (UK, China, Singapore, etc.) and site
number (01, 02 etc.) of each product made is recorded for quality
control and auditing purposes and encoded into a fixed format
Product Code. The serial number of each item and product name is
also recorded.