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.
Answer:
Decision Support System (DSS)
Explanation:
- Decision Support System is an interactive information system that intends to help the people in an organization in business decision making.
- These software based systems obtain large volumes of knowledge produced from the various related information systems included in corporate business processes.
- DSS comprises of three main components that are, software system, database and user interface.
- DSS gathers, manages and assesses business data to enable better business decision making and planning.
- This aids organizations to detect and solve various semi-structured and unstructured problems and make decisions.
- It helps to make the decision making process quick and efficient.
- It helps to automate and simplify organizational processes and makes interpersonal interaction easier. DSS is flexible and adaptive to support the changes in decision making process of a user.
- DSS enables decision makers to collect a range of data from various sources like raw data, records, management, business models, administrators etc.
- DSS are used in medical diagnosis (clinical decision support systems),business management, forest management, railway systems, agricultural production etc.
DNA is like your phone line. As Northwestern University biophysicist Johnathan Widom put it in a talk recently, DNA simultaneously encodes multiple overlapping signals, just like your phone line that allows you to call home while you're surfing the net
Explanation:
A phone is made up of
#include <iostream>
#include <string>
main ()
{
using std::cout;
using std::cin;
std::string s;
do
{
cout<<"Type 2 numbers: ";
int a,b;
cin>>a>>b;
cout<<"Sum of your numbers equals to: "<<a+b;
cout<<"\nType \"Yes\" if you want to continue.";
cin>>s;
}while(s=="Yes");
return 0;
}
Answer:
B It can seem boring.
Explanation:
The repetition of visual effects results in consistency, rhythm, and movement. However, too much repetition can cause monotony and boredom. And this is not good for you certainly. You are certainly going to lose the audience. And too much harmony in design as well in a similar manner causes boredom, or it can seem boring. And hence, the correct option here is B it can seem boring.