1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
Sever21 [200]
3 years ago
7

Create a view named NHTrips. It consists of the trip ID, trip name, start location, distance, maximum group size, type, and seas

on for every trip located in New Hampshire (NH). Display the data in the view.
Computers and Technology
1 answer:
anzhelika [568]3 years ago
7 0

Answer:

CREATE VIEW NHTrips AS

SELECT TripID,

TripName,

StartLocation,

Distance,

MaxGrpSize,

Type,

Season

FROM trip

WHERE State = 'NH';

Explanation:

A view is a user’s view or application program’s view of the database created for execution during a database operation such as those for displaying results, modification of record, updating and deletion of records. It is created by defining a SELECT query and then using a CREATE VIEW command.

syntax for creating view;

The view is created as follows,

Give a view name using the CREATE VIEW command and give optional field names followed by the query using the SELECT statement

I.e

CREATE VIEW viewname

[(column name1, column name2….)] AS Select statement

When the above query is executed, a view named NHTrips will created in the database.

You might be interested in
What is the management part of a dashboard?
Stolb23 [73]

Answer:

 The management dashboard is the visual and display the KPI ( Key performance indicator) and metrics for monitoring the specific process and department.

It is basically used for checking whether the organization achieve or meet its specific goals not as per the requirement of the particular department in the organization.

The main part of the management dashboard is that it provide the visibility and alignment in the particular organization so that it meets according to the requirements of the organization. The basic requirement in the organization are:

  • Business user
  • Organization needs
  • Information technology (IT) needs

7 0
3 years ago
Question 4 Multiple Choice Worth 5 points)
Morgarella [4.7K]

The correct answer is Boolean logic.

Booleans are true or false statements.

An example of a while loop is:

while 1 < 5:

   #do something.

The Boolean statement is 1 < 5 which evaluates to true because 1 is less than 5.

I hope this helps!

3 0
3 years ago
. Which of the following are container elements?
lions [1.4K]
It’s c cba to explain
4 0
3 years ago
Read 2 more answers
What it the total resistance in a series circuit with two resistors of 100 ohms each?
snow_tiger [21]

Answer:

200Ω

Explanation:

In series circuits, you add the resistances.

3 0
2 years ago
Select all that apply.
Serhud [2]

Answer:

Page grouping

Page Setup grouping

Layout grouping

Schemes grouping

4 0
3 years ago
Other questions:
  • Brainliest to whoever can guess what year this corvette logo is from. Make your guesses
    11·1 answer
  • Helppppppppppppppppppp
    11·1 answer
  • Suppose alice, with a web-based e-mail account (such as hotmail or gmail), sends a message to bob, who accesses his mail from g
    10·1 answer
  • __ is/are the amount of blank space between lines of text in a paragraph
    7·2 answers
  • Consider a computer system, where each processor can independently perform a separate task. given that the response time on a co
    10·1 answer
  • What are options in the Advanced tab in the Share Workbook dialog box? Check all that apply.
    14·2 answers
  • Maria works for MegaCorp, a large privately owned company specializing in sales of ball bearings. MegaCorp introduces filtering
    15·1 answer
  • What does an "embedded video" mean
    7·1 answer
  • ) Printers today have many features that include improved quality, photo printing capabilities, digital camera connectivity, bui
    11·1 answer
  • Darla is going to start writing the HTML code for a web page. What would she start with?
    11·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!