Answer:
updating the computer and having an anti virus on your computer
1. Describe data and process modeling concepts and tools.
Answer:
data is the raw fact about its process
Explanation:
input = process= output
data is the raw fact which gonna keeps in files and folders. as we know that data is a information keep in our device that we use .
Answer:
Data and process modelling involves three main tools: data flow diagrams, a data dictionary, and process descriptions. Describe data and process tools. Diagrams showing how data is processed, transformed, and stored in an information system. It does not show program logic or processing steps.
Write a program that reads in the size of the side of a square and then prints a hollow square of that size out of asterisks and
blanks. Your program should work for squares of all side sizes between 1 and 20. For example, if your program reads a size of 5, it
should print
Answer:
Explanation:
#include <iostream>
using std::cout;
using std::endl;
using std::cin;
int main()
{
int side, rowPosition, size;
cout << "Enter the square side: ";
cin >> side;
size = side;
while ( side > 0 ) {
rowPosition = size;
while ( rowPosition > 0 ) {
if ( size == side || side == 1 || rowPosition == 1 ||
rowPosition == size )
cout << '*';
else
cout << ' ';
--rowPosition;
}
cout << '\n';
--side;
}
cout << endl;
return 0;
}
Sophia is putting together a training manual for her new batch of employees.Which of the following features can she use to add a document title at the top of each page?
A) Heading style
B) Page margin
C) References
D) Header and Footer
Answer:
A heading style to add a document title
The feature can she use to add a document title at the top of each page is - Heading style. Therefore option A is the correct resposne.
What are Header and Footer?A footer is a text that is positioned at the bottom of a page, whereas a header is text that is positioned at the top of a page. Usually, details about the document, such as the title, chapter heading, page numbers, and creation date, are inserted in these spaces.
A piece of the document that appears in the top margin is called the header, while a section that appears in the bottom margin is called the footer. Longer papers may be kept structured and made simpler to read by including more information in the headers and footers, such as page numbers, dates, author names, and footnotes. Each page of the paper will have the header or footer text you input.
To read more about Header and Footer, refer to - https://brainly.com/question/20998839
#SPJ2
When implementing a 1:1 relationship, where should you place the foreign key if one side is mandatory and one side is optional? Should the foreign key be mandatory or optional?
Answer:
When implementing a 1:1 relationship, the foreign key should be placed on the optional side if one side is mandatory and one side is optional.
When this is implemented, the foreign key should be made mandatory.
Explanation:
A foreign key (FK) is a primary key (PK) in relational databases. It is used to establish a relationship with a table that has the same attribute with another table in the database. A mandatory relationship exists when the foreign key depends on the parent (primary key) and cannot exist without the parent. A one-to-one relationship exists when one row in a data table may be linked with only one row in another data table.
For each of the following memory accesses indicate if it will be a cache hit or miss when carried out in sequence as listed. Also, give the value of a read if it can be inferred from the information in the cache.
Operation Address Hit? Read value (or unknown)
Read 0x834
Write 0x 836
Read 0xFFD
Answer:
Explanation:
Operation Address Hit? Read Value
Read 0x834 No Unknown
Write 0x836 Yes (not applicable)
Read 0xFFD Yes CO
LAB: Count multiples (EO)
Complete a program that creates an object of the Count class, takes three integers as input: low, high, and x, and then calls the countMultiples() method. The countMultiples() method then returns the number of multiples of x between low and high inclusively.
Ex: If the input is:
1 10 2
countMutiples() returns and the program output is:
5
Hint: Use the % operator to determine if a number is a multiple of x. Use a for loop to test each number between low and high.
Note: Your program must define the method:
public int countMultiples(int low, int high, int x)
Count.java
1 import java.util.Scanner;
2
3 public class Count {
4
5 public int countMultiples(int low, int high, int x) {
6 /* Type your code here. */
7
8 }
9
10 public static void main(String[] args) {
11 Scanner scnr = new Scanner(System.in);
12 /* Type your code here. */
13 }
14)
15
Following are the Java Program to the given question:
import java.util.Scanner; //import package for user-input
public class Count //defining a class Count
{
public static int countMultiples(int low,int high,int x)//defining a method countMultiples that takes three integer parameters
{
int c=0,i; //defining integer variables that hold value
for(i=low;i<=high;i++)//defining loop that iterates value between low and high
{
if(i%x==0)//defining if block that uses % operator to check value
{
c+=1; //incrementing c value
}
}
return c; //return c value
}
public static void main(String[] args)//main method
{
int l,h,x;//defining integer variable
Scanner scnr=new Scanner(System.in); //creating scanner class object
l=scnr.nextInt(); //input value
h=scnr.nextInt();//input value
x=scnr.nextInt();//input value
System.out.println(countMultiples(l,h,x)); //calling method and print its value
}
}
Output:
Please find the attached file.
Program Explanation:
Import package.Defining a class "Count", and inside the class two method "countMultiples and main method" is declared.In the "countMultiples" method three integer parameter that are "low, high, and x".Inside this method a for loop is declared that uses the parameter value and use conditional statement with the % operator and check and return its values.Inside the main method three integer variable is declared that uses the scanner class to input the value and pass to the method and print its calculated value.Learn more:
brainly.com/question/16106262
Database multiple-choice question don't bs pls
Which of the following is not a common factor for database management system selection?
a. Cost
b. Features and tools
c. Software requirements
d. Hardware requirements
e. All of the above
f. None of the above
(D and F are wrong)
Answer:
f. None of the above
Explanation:
Considering the available options, the right answer is option F "None of the above."
Common factors for database management system selection are the following:
1. Cost: various DBMS vendors have different pricing, hence, interested buyers will consider the price before selections
2. Features and Tools: different types of DBMS have varied features and tools in carrying out the work.
3. Software requirements: there are various software requirements in various DBMS, such as encryption support, scalability, application-level data recovery, etc.
4. Hardware requirement: various DBMS vendors have different hardware requirements to consider, such as sizeable RAM, CPU value, etc.
Hence, in this case, the correct answer is option F.
Write a program named edit_data.py that asks a person their age. Accept an int. Use a custom exception to return a message if the number entered is an int that is less than 1 or greater than 115. Create an exception that catches an error if a non int is entered.
An error that occurs while a program is being run is an exception. Non-programmers see exceptions as examples that do not follow a general rule.
What is the programming?
In computer science, the term "exception" also has the following connotation: It signifies that the issue is an uncommon occurrence; it is the "exception to the rule." Some programming languages use the mechanism known as exception handling to deal with problems automatically. Exception handling is built into several programming languages, including C++, Objective-C, PHP, Java, Ruby, Python, and many others.
In order to manage errors, programs often save the state of execution at the time the problem occurred and interrupt their usual operation to run an exception handler, which is a particular function or section of code. Depending on the type of error that had occurred, the error handler can "correct" the issue and the application can then continue using the previously saved data.
Thus, An error that occurs while a program is being run is an exception.
For more information about programming, click here:
https://brainly.com/question/11023419
#SPJ5
Which operating system desktop or mobile is the best
Answer:
bing or alien ware is the best.
Answer:
Your choice, but personally, desktop is better.
Explanation:
Desktop devices have portrait orientations so content can stretch across a screen and often multiple messages or images can live comfortably in such a wide space. Mobile devices are usually used in portrait orientation (and the smaller screens mean that even in landscape mode, horizontal space is limited).
Show the result of inserting 10, 12, 1, 14, 6, 5, 8, 15, 3, 9, 7, 4, 11, 13, and 2, one at a time, into an initially empty binary heap. b. Show the result of using the linear-time algorithm to build a binary heap using the same input.
Show the result of performing three deleteMin operations in the heap of the previous exercise.
Answer:
Explanation:
A)
10 10 10 1 1
/ / \ --> / \ / \
12 12 1 12 10 12 10
/
14
1 1 1 1
/ \ / \ / \ / \
12 10 --> 6 10 6 10 --> 6 5
/ \ / \ / \ / / \ /
14 6 14 12 14 12 5 14 12 10
1 1 1 1
/ \ / \ / \ / \
6 5 6 5 6 5 --> 3 5
/ \ / \ / \ / \ / \ / \ / \ / \
14 12 10 8 14 12 10 8 14 12 10 8 6 12 10 8
/ / \ / \
15 15 3 15 14
After inserting all 1
/ \
3 2
/ \ / \
6 7 5 4
/ \ / \ / \ / \
15 14 12 9 10 11 13 8
b)
First level build : 10
/ \
12 1
/ \ / \
14 6 5 8
/ \ / \ / \ / \
15 3 9 7 4 11 13 2
Heap bottom level: 10
/ \
12 1
/ \ / \
3 6 4 2
/ \ / \ / \ / \
15 14 9 7 5 11 13 8
Heap next level up: 10
/ \
3 1
/ \ / \
12 6 4 2
/ \ / \ / \ / \
15 14 9 7 5 11 13 8
Final heap: 1
/ \
3 2
/ \ / \
12 6 4 8
/ \ / \ / \ / \
15 14 9 7 5 11 13 10
c)
Duing the first time,
First, assume the last element, the 8, is at the root and bubble down.
Then, assume the last element, the 13, is at the root and bubble down.
Then, assume the last element, the 11, is at the root and bubble down.
Final heap:
4
/ \
6 5
/ \ / \
13 7 10 8
/ \ / \ /
15 14 12 9 11
In the next iteration,
First, assume the last element, the 10, is at the root and bubble down.
Then, assume the last element, the 13, is at the root and bubble down.
Then, asssume the last element, the 11, is at the root and bubble down.
So, after performing all operations, the heap looks like below:
4
/ \
6 5
/ \ / \
12 7 10 8
/ \ / \ /
15 14 9 13 11
RecursionexerciseCOP 3502; Summer2021We have gone through many examples in the class and those examples are available in the slides and uploaded codes. Try to test those codes and modify as you wish for getting more clarification.In additiontry the following:---------------------------------------------------------------------------------------------------------------------------------------1.What would be the output of the following recursive function if we call rec2(5)
Answer:
The output is:
1 2 3 4 5
Explanation:
Given
See attachment for code segment
Required
The output of rec2(5)
From the attached code segment, we have the following:
The base case: if (x==0){ return;}
The above implies that, the recursion ends when the value of x gets reduced to 0
The recursion:
rec2(x-1); ---- This continually reduces x by 1 and passes the value to the function
printf("%d ", x); This prints the passed value of x
Hence, the output of rec2(5) is: 1 2 3 4 5
The message signal m(t) = 10cos(1000t) frequency modulates the carrier c(t) = 10cos(2fct). The modulation index is 10.
1) Write an expression for the modulated signal u(t).
2) What is the power of the modulated signal.
3) Find the bandwidth of the modulated signal.
Answer:
1) 10cos ( 2πfct + 10sin 2πfmt )
2) 50 watts
3) 1000 Hz
Explanation:
m(t) = 10cos(1000πt)
c(t) = 10cos(2πfct )
modulation index ( = 10
1) expression for modulated signal ( u(t) )
u(t) = Ac(cos 2πfct ) + A (cos 2πfct m(t) ) Am cos2πf mt
= 10cos 2πfct + 100 cos 2πfct cos2π500t
= 10cos ( 2πfct + 10sin 2πfmt )
2) power of modulated signal
power of modulated signal μ^2 / 2 ]
= 10^2/2 ]
= 50 watts
3) Bandwidth
B = 2fm = 2 * 500 = 1000 Hz
Write a recursive function that returns 1 if an array of size n is in sorted order and 0 otherwise. Note: If array a stores 3, 6, 7, 7, 12, then isSorted(a, 5) should return 1 . If array b stores 3, 4, 9, 8, then isSorted(b, 4) should return 0.
Answer:
The function in C++ is as follows:
int isSorted(int ar[], int n){
if ([tex]n == 1[/tex] || [tex]n == 0[/tex]){
return 1;}
if ([tex]ar[n - 1][/tex] < [tex]ar[n - 2][/tex]){
return 0;}
return isSorted(ar, n - 1);}
Explanation:
This defines the function
int isSorted(int ar[], int n){
This represents the base case; n = 1 or 0 will return 1 (i.e. the array is sorted)
if ([tex]n == 1[/tex] || [tex]n == 0[/tex]){
return 1;}
This checks if the current element is less than the previous array element; If yes, the array is not sorted
if ([tex]ar[n - 1][/tex] < [tex]ar[n - 2][/tex]){
return 0;}
This calls the function, recursively
return isSorted(ar, n - 1);
}
/*
Given a 2D board containing 'X' and 'O', capture all regions surrounded by 'X'.
A region is captured by flipping all 'O's into 'X's in that surrounded region .
For example,
X X X X
X O O X
X X O X
X O X X
After running your function, the board should be:
X X X X
X X X X
X X X X
X O X X
*/
public class Solution {
// This algorithm cannot solve the large test set
public void solve(char[][] board) {
// Start typing your Java solution below
// DO NOT write main() function
int rows = board.length;
if(rows == 0) return;
int cols = board[0].length;
for(int i = 0; i < cols; i++) {
// check first row's O
if(board[0][i] == 'O') {
// change it to other symbol
board[0][i] = '#';
dfs(board, 0, i);
}
// check the last row
if(board[rows - 1][i] == 'O') {
board[rows - 1][i] = '#';
dfs(board, rows - 1, i);
}
}
for(int i = 0; i < rows; i++) {
// check first col
if(board[i][0] == 'O') {
board[i][0] = '#';
dfs(board, i, 0);
}
// check last col
if(board[i][cols - 1] == 'O') {
board[i][cols - 1] = '#';
dfs(board, i, cols - 1);
}
}
// change O to X
changeTo(board, 'O', 'X');
// change # to O
changeTo(board, '#', 'O');
return;
}
public void dfs(char[][] board, int row, int col) {
// check up
if(row > 0) {
if(board[row - 1][col] == 'O') {
board[row - 1][col] = '#';
dfs(board, row - 1, col);
}
}
// check left
if(col > 0) {
if(board[row][col - 1] == 'O') {
board[row][col - 1] = '#';
dfs(board, row, col - 1);
}
}
// check right
if(row < board.length - 1) {
if(board[row + 1][col] == 'O') {
board[row+1][col] = '#';
dfs(board, row+1, col);
}
}
// check down
if(col < board[0].length - 1) {
if(board[row][col+1] == 'O'){
board[row][col+1] = '#';
dfs(board, row, col+1);
}
}
return;
}
public void changeTo(char[][] board, char from, char to) {
for(int i = 0; i < board.length; i++) {
for(int j = 0; j < board[0].length; j++) {
if(board[i][j] == from) {
board[i][j] = to;
}
}
}
return;
}
}
Suppose during a TCP connection between A and B, B acting as a TCP receiver, sometimes discards segments received out of sequence, but sometimes buffers them. Would the data sent by A still be delivered reliably and in-sequence at B? Explain why.
Answer:
Yes
Explanation:
We known that TCP is the connection [tex]\text{oriented}[/tex] protocol. So the TCP expects for the target host to acknowledge or to check that the [tex]\text{communication}[/tex] session has been established or not.
Also the End stations that is running reliable protocols will be working together in order to verify transmission of data so as to ensure the accuracy and the integrity of the data. Hence it is reliable and so the data can be sent A will still be delivered reliably and it is in-sequence at B.
..............is a piece of hardware used to provide data and instructions to a computer used for interaction and control. *
Output device.
Processing.
input device.
All of above.
Answer:
output
Explanation:
it can be seen and touched
Please help urgently
Use Python.
Complete reverse() method that returns a new character array containing all contents in the parameter reversed.
Ex: If the input array is:
['a', 'b', 'c']
then the returned array will be:
['c', 'b', 'a']
import java.util.*;
public class LabProgram {
// This method reverses contents of input argument arr.
public static char[] reverse(char[] arr) {
/* Type your code here. */
}
public static void main(String[] args) {
char [] ch = {'a','b','c'};
System.out.println(reverse(ch)); // Should print cba
}
}
Answer:
Explanation:
The code in the question is written in Java but If you want it in Python then it would be much simpler. The code below is writen in Python and uses list slicing to reverse the array that is passed as an argument to the function. The test case from the question was used and the output can be seen in the attached image below.
def reverse(arr):
reversed_arr = arr[::-1]
return reversed_arr
For the following 4-bit operation, assuming these register are ONLY 4-bits in size, which status flags are on after performing the following operation? Assume 2's complement representation. 1010+0110
a) с
b) Z
c) N
Answer:
All flags are On ( c, z , N )
Explanation:
Given data:
4-bit operation
Assuming 2's complement representation
Determine status flags that are on after performing 1010+0110
1 1
1 0 1 0
0 1 1 0
1 0 0 0 0
we will carry bit = 1 over
hence C = 1
given that: carry in = carry out there will be zero ( 0 ) overflow
hence V = 0
also Z = 1
But the most significant bit is N = 1
Use NAND operator to write; P or Q, and P -Q make an everyday implication sentence using only NAND
Answer:
Hence the answer is given as follows,
Explanation:
By using the NAND operator:-
P or Q and P -Q make an everyday implication sentence using the only NAND is given as,
How can an Outlook user search for contacts? Check all that apply.
the Search bar located above the list of contacts
the Search People bar on the Find command group
the Search People located on the People navigation icon
CTL + E to activate the search contacts box
advanced Find under the Search tab
the options menu in the backstage view
Answer: the Search bar located above the list of contacts.
the Search People bar on the Find command group.
the Search People located on the People navigation icon.
CTL + E to activate the search contacts box.
advanced Find under the Search tab.
Explanation:
An Outlook user can search for contacts through the following ways:
• the Search bar located above the list of contacts.
• the Search People bar on the Find command group.
• the Search People located on the People navigation icon.
• CTL + E to activate the search contacts box.
• advanced Find under the Search tab.
Therefore, the correct options are A, B, C, D and E.
Write a Java code statement for each of following:
a) To declare TWO (2) decimal numbers, and ONE (1) whole number.
Answer:
double decimal1, decimal2;
int whole;
Explanation:
Required
Declare 2 decimals and 1 int.
The syntax to declare a variable is:
data-type variable-name;
To declare decimal, we simply make use of double or float data types.
So, we have:
double decimal1, decimal2; ----> for the decimal variables
And
int whole; ---- for the whole number
Can anyone decipher these? There a bit random. Maybe binary but if there are other ways please include them.
Answer:
Explanation:
so this is what "format" is about, it's saying what do the ones and zeros represent. b/c the bits can represent lots of different things , like letters with ascii code , and that's got several types. some are 8 bits, some are 16 bits, the questions you've shown are in groups of 5 which is really not a "thing" in binary, it's always by twos, without some type of "frame work" around the bits, we won't know what they represent, if that is helping? the important part is what is the "frame work" that these bits are in.
all of your questions seem to have some "art" thing going on, they make some kinda of binary artwork, for what they are saying, that's not what's important. Other than if they form palindromes, maybe that's what the questions are really about, how these do from palindromes, that is, they read the same backwards as forwards... I know.. why would anyone read backwards.. but a computer can do that pretty quickly, sooo sometimes to check, it will read forwards and backwards.. but when there is a palindrome, the computer is "confused"
this is also a big big part of "typing" not like on a keyboard but when you program, and you say that your variables are of a certain type, like a char, or a string, or a double, you are specifying how many bits will be used to represent your data. so then when you put the ones and zeros into the memory , ( think RAM) then it's stored in groups of what ever size you've determined. hmmmm does this help?
Which of the following terms describes an attacker walking or driving through business areas and neighborhoods to identify unprotected wireless networks from the street using a laptop or a handheld computer?
A. Wi-Fi stealing.
B. Wi-Fi trolling.
C. Wi-Fi jacking.
D. Wi-Fi hacking.
Answer:
C. Wi-Fi jacking
Explanation:
Answer: yessir b
Explanation:
Choose all that Apply: Which of the following steps should be performed by the CIS for creating a part dispatch for systemboard through Tech Direct?
a) Enter the customer's contact and email address into the primary contact fields when requesting a systemboard through TechDirect
b) Logging fusion ticket to request DPK via DDL
c) Access the customer's DDL account to retrieve DPK and activate the os for the customer
d) Verify the customer email address
Answer:
The steps that should be performed by the CIS for creating a part dispatch for system board through TechDirect are:
a) Enter the customer's contact and email address into the primary contact fields when requesting a system board through TechDirect
b) Logging fusion ticket to request DPK via DDL
c) Access the customer's DDL account to retrieve DPK and activate the os for the customer
d) Verify the customer email address
Explanation:
The four steps given above must be performed in the CIS if you want to create a part dispatch for the system board through TechDirect. TechDirect is a support system that enables one to manage all Dell technologies from a single location. After creating the part dispatch, the customer's contact and email address are entered into the primary contact fields to enable the verification of the customer's email address through the TechDirect.
1. Write the CSS for an id with the following characteristics: fixed position, light grey background color, bold font weight, and 10 pixels of padding
Answer:
#element
{
position: fixed;
background-color: RGBA(211, 211, 211, 1);
font-weight: bold;
padding: 10px;
}
how much is this worth in dollars
Answer:
This is worth 50 dollars.
Explanation:
١ - one
٢ - two
٣ - three
٤ - four
٥ - five
٦ - six
٧ - seven
٨ - eight
٩ - nine
٠ - zero
What you see above is the ten digits in Arabic.
Both 5 (٥) and 0 (٠) appear here, thus representing 50.
I need the SQL statements for these questions:
1. For each reservation, list the reservation ID, trip ID, customer number, and customer last name. Order the results by customer last name.
2. For each reservation for customer Ryan Goff, list the reservation ID, trip ID, and number of persons.
3. List the trip name of each trip that has Miles Abrams as a guide.
4. List the trip name of each trip that has the type Biking and that has Rita Boyers as a guide.
5. For each reservation that has a trip date of July 23, 2016, list the customer’s last name, the trip name, and the start location.
6. List the reservation ID, trip ID, and trip date for reservations for a trip in Maine (ME). Use the IN operator in your query.
7. Repeat Exercise 6, but this time use the EXISTS operator in your query.
8. Find the guide last name and guide first name of all guides who can lead a paddling trip. (Note: The query results should include duplicate values.)
Here are the tables:
CUSTOMER FIRST NAME POSTAL CODE CUSTOMER NUM LAST NAME ADDRESS Northfold Liam 9 Old Mill Rd Londonderry 10 NH 03053 103 Kasuma Sujata 132 Main St. #1 East Hartford CT 06108 MA 01854 Goff 164A South Bend Rd. Lowell Ryan 105 McLean Kyle 345 Lower Ave. Wolcott NY 14590 106 Morontoia Joseph 156 Scholar St Johnston 02919 107 Marchand Quinn 76 Cross Rd Bath NH 03740 108 32 Sheep stop St Edinboro PA Rulf Usch 16412 109 Caron Jean Luc 10 Greenfield St Rome ME 04963 110 Martha York Bers 65 Granite St NY 14592 112 Jones Laura 373 Highland Ave. Somerville MA 02143 115 Nu Adam 1282 Ocean Walk Ocean City Vaccari 08226 116 Murakami Iris 7 Cherry Blossom St. Weymouth MA 02188 119 Londonderry vT Chau 18 Ark Ledge Ln Clement 05148 120 Gernowski Sadie 24 stump Rd. Athens ME 04912 121 Cambridge VT Bretton-Borak Siam 10 Old Main St 122 Hefferson orlagh 132 South St. Apt 27 Manchester NH 03101 123 25 Stag Rd Fairfield Barnett Larry 06824 124 Busa Karen 12 Foster St. South Windsor CT 06074 125 51 Fredrick St Albion Peterson Becca NY 14411 126 Brown Brianne 154 Central St Vernon CT 06066 PHONE Click to Add 603-555-7563 413-555-3212 860-555-0703 781-555-8423 585-555-5321 401-555-4848 603-555-0456 814-555-5521 207-555-9643 585-555-0111 857-555-6258 609-555-5231 617-555-6665 802-555-3096 207-555-4507 802-555-3443 603-555-3476 860-555-9876 857-555-5532. 585-555-0900 860-555-3234
Answer:
Explanation:
/* From the information provided, For now will consider the name of table as TRIPGUIDES*/
/*In all the answers below, the syntax is based on Oracle SQL. In case of usage of other database queries, answer may vary to some extent*/
1.
Select R.Reservation_ID, R.Trip_ID , C.Customer_Num,C.Last_Name from Reservation R, Customer C where C.Customer_Num=R.Customer_Num ORDER BY C.Last_Name
/*idea is to select the join the two tables by comparing customer_id field in two tables as it is the only field which is common and then print the desired result later ordering by last name to get the results in sorted order*/
2.
Select R.Reservation_ID, R.Trip_ID , R.NUM_PERSONS from Reservation R, Customer C where C.Customer_Num=R.Customer_Num and C.LAST_NAME='Goff' and C.FIRST_NAME='Ryan'
/*Here, the explaination will be similar to the first query. Choose the desired columns from the tables, and join the two tables by equating the common field
*/
3.
Select T.TRIP_NAME from TRIP T,GUIDE G,TRIPGUIDES TG where T.TRIP_ID=TG.TRIP_ID and TG.GUIDE_NUM=G.GUIDE_NUM and G.LAST_NAME='Abrams' and G.FIRST_NAME='Miles'
/*
Here,we choose three tables TRIP,GUIDE and TRIPGUIDES. Here we selected those trips where we have guides as Miles Abrms in the GUIDES table and equated Trip_id from TRIPGUIDES to TRIP.TRIP_Name so that can have the desired results
*/
4.
Select T.TRIP_NAME
from TRIP T,TRIPGUIDES TG ,G.GUIDE
where T.TRIP_ID=TG.TRIP_ID and T.TYPE='Biking' and TG.GUIDE_NUM=G.GUIDE_NUM and G.LAST_NAME='Boyers' and G.FIRST_NAME='Rita'
/*
In the above question, we first selected the trip name from trip table. To put the condition we first make sure that all the three tables are connected properly. In order to do so, we have equated Guide_nums in guide and tripguides. and also equated trip_id in tripguides and trip. Then we equated names from guide tables and type from trip table for the desired results.
*/
5.
SELECT C.LAST_NAME , T.TRIP_NAME , T.START_LOCATION FROM CUSTOMER C, TRIP T, RESERVATION R WHERE R.TRIP_DATE='2016-07-23' AND T.TRIP_ID=R.TRIP_ID AND C.CUSTOMER_NUM=R.CUSTOMER_NUM
/*
The explaination for this one will be equivalent to the previous question where we just equated the desired columns where we equiated the desired columns in respective fields and also equated the common entities like trip ids and customer ids so that can join tables properly
*/
/*The comparison of dates in SQL depends on the format in which they are stored. In the upper case if the
dates are stored in the format as YYYY-MM-DD, then the above query mentioned will work. In case dates are stored in the form of a string then the following query will work.
SELECT C.LAST_NAME , T.TRIP_NAME , T.START_LOCATION FROM CUSTOMER C, TRIP T, RESERVATION R WHERE R.TRIP_DATE='7/23/2016' AND T.TRIP_ID=R.TRIP_ID AND C.CUSTOMER_NUM=R.CUSTOMER_NUM
*/
6.
Select R.RESERVATION_ID, R.TRIP_ID,R.TRIP_DATE FROM RESERVATION R WHERE R.TRIP_ID IN
{SELECT TRIP_ID FROM TRIP T WHERE STATE='ME'}
/*
In the above question, we firstly extracted all the trip id's which are having locations as maine. Now we have the list of all the trip_id's that have location maine. Now we just need to extract the reservation ids for the same which can be trivally done by simply using the in clause stating print all the tuples whose id's are there in the list of inner query. Remember, IN always checks in the set of values.
*/
7.
Select R.RESERVATION_ID, R.TRIP_ID,R.TRIP_DATE FROM RESERVATION WHERE
EXISTS {SELECT TRIP_ID FROM TRIP T WHERE STATE='ME' and R.TRIP_ID=T.TRIP_ID}
/*
Unlike IN, Exist returns either true or false based on existance of any tuple in the condition provided. In the question above, firstly we checked for the possibilities if there is a trip in state ME and TRIP_IDs are common. Then we selected reservation ID, trip ID and Trip dates for all queries that returns true for inner query
*/
8.
SELECT G.LAST_NAME,G.FIRST_NAME FROM GUIDE WHERE G.GUIDE_NUM IN
{
SELECT DISTINCT TG.GUIDE_NUM FROM TRIPGUIDES TG WHERE TG.TRIPID IN {
SELECT T.TRIP_ID FROM TRIP T WHERE T.TYPE='Paddling'
}
}
/*
We have used here double nested IN queries. Firstly we selected all the trips which had paddling type (from the inner most queries). Using the same, we get the list of guides,(basically got the list of guide_numbers) of all the guides eds which were on trips with trip id we got from the inner most queries. Now that we have all the guide_Nums that were on trip with type paddling, we can simply use the query select last name and first name of all the guides which are having guide nums in the list returned by middle query.
*/
What type of device is a computer? Where does it use
Answer:A computer is an electronic device that manipulates information, or data. It has the ability to store, retrieve, and process data. You may already know that you can use a computer to type documents, send email, play games, and browse the Web.
To connect several computers together, one generally needs to be running a(n) ____ operating system
a. Network
b. Stand-alone
c. Embedded
d. Internet
Answer. Network
Explanation:
