Answer:
Answered below
Explanation:
foods = ["chocolate", "chicken", "corn"]
fifth_char = []
for food in foods:
"""Add a try statement to add fifth character to fifth_char list. If word is not long enough, the except part executes the the pass and nothing is printed.""'
try:
fifth_char.append(food[4])
except:
pass
#print out elements in new list
for c in fifth_char:
print(c)
what of the following uses heat from deep inside the earth that generates steam to make electricity
Answer:
Geothermal power plants.
What is the most important part of the brainstorming process?
Answer:
Some people may say that the most important part of brainstorming is the ability to come up with creative ideas, but this end result is still linked to the need for a lack of judgement or criticism during the session.
Explanation:
brainliest please
Which of the following describe ALAC audio files? Choose all that apply.
uses a codec that is open source
uses a codec that lives in iPods and other Apple hardware
was developed by Apple
is exclusively supported by Apple iTunes
may have .mp3 and .mp4 file extensions
Answer:
B,C,D
Explanation:
Answer:
B C D
Explanation:
4.5.2 For loop: printing a dictionary python
Answer:
for x, y in thisdict.items():
print(x, y)
Explanation:
A non-profit organization decides to use an accounting software solution designed for non-profits. The solution is hosted on a commercial provider's site but the accounting information suchas the general ledger is stored at the non-profit organization's network. Access to the software application is done through an interface that uses a coneventional web browser. The solution is being used by many other non-profit. Which security structure is likely to be in place:
Answer:
A firewall protecting the software at the provider
Explanation:
The security structure that is likely to be in place is :A firewall protecting the software at the provider
Since the access to the software application is via a conventional web browser, firewalls will be used in order to protect against unauthorized Internet users gaining access into the private networks connected to the Internet,
Discuss the relationship of culture and trends?
explain the procedure you will undertake to create a new partition
Which of the following would a cyber criminal most likely do once they gained access to a user id and password
Answer:
do something wrong as you
What is output?
public class Division{
public static double division(double a, double b) throws Exception {
if(b == 0)
throw new Exception("Invalid number.");
return a / b;
}
public static void main(String[] args) {
try {
System.out.println("Result: " + division(5, 0));
}
catch (ArithmeticException e) {
System.out.println("Arithmetic Exception Error");
}
catch (Exception except) {
System.out.println("Division by Zero");
}
catch(Throwable thrwObj) {
System.out.println("Error");
}
}
}
A. Error.
B. Arithmetic Exception Error.
C. Arithmetic Exception Error Division by Zero Error.
D. Division by zero.
Answer:
D. Division by zero.
Explanation:
This Java code that is being provided in the question will output the following error.
Division by zero
This is because the main method is calling the division method and passing 0 for the variable b. The method detects this with the if statement and creates a new Exception. This exception is grabbed by the catch(Exception exception) line and prints out the error Division by zero.
A
is the movement you see when one slide changes to another in slide show
view.
O style
O
dissolve
O transition effect
O
bevel effect
Answer:
Transition effect
Explanation:
Transition effects are slide changing with animations.
PLEASE HELP!!!
Question 6:
A retailer of computers maintains a record containing the following information for every individual
computer sold
• Manufacturer name
• Model number
• Physical memory size
• Processor name
• Date of sale
• Price sold for
Using only the database, which of the following CANNOT be determined?
The average price of a computer was sold by the retailer
In which months less than 100 computers were sold
o Which models of computer stocked by the retailer have not had a single sale
The most popular model of computer sold by the retailer
Explain with examples:
What are the reasons of a successful and unsuccessful software project?
Answer:
A good starting point is by addressing some of the key reasons software projects fail.
Explanation:
Not Enough Time. ...
Insufficient Budget. ...
Poor Communication. ...
Never Reviewing Project Progress. ...
Inadequate Testing. ...
Testing in the Production Environment. ...
Lack of Quality Assurance. ...
Not Conforming to Industry Standards.
User involvement, management support, reasonable requirements, and accurate projections are some of the most frequent aspects that contribute to software project success.
What is a software project?A software project is the entire process of developing software, from gathering requirements to testing and maintenance, carried out in accordance with execution techniques over a predetermined amount of time to produce the desired software output.
Some of the most frequent factors that influence the success of software projects are user interaction, management support, fair needs, and realistic estimates.
Application bug or error, environmental conditions, infrastructure or software failure, virus, hacker, network/hardware failure, and operator error are the main causes of software project failure.
According to the study, project success and failure are most heavily influenced by the degree of customer/user interaction, software process management, and estimation and timeline.
Thus, these are the reasons of a successful and unsuccessful software project.
For more details regarding software project, visit:
https://brainly.com/question/3818302
#SPJ2
Create a recursive procedure named (accumulator oddsum next). The procedure will return the sum of the odd numbers entered from the keyboard. The procedure will read a sequence of numbers from the keyboard, where parameter oddsum will keep track of the sum from the odd numbers entered so far and parameter next will (read) the next number from the keyboard.
Answer:
Explanation:
The following procedure is written in Python. It takes the next argument, checks if it is an odd number and if so it adds it to oddsum. Then it asks the user for a new number from the keyboard and calls the accumulator procedure/function again using that number. If any even number is passed the function terminates and returns the value of oddsum.
def accumulator(next, oddsum = 0):
if (next % 2) != 0:
oddsum += next
newNext = int(input("Enter new number: "))
return accumulator(newNext, oddsum)
else:
return oddsum
The UNIX cal command prints out the calendar of the month/year that the user enters. Type in the following, one at a time, and observe the output:
cal 3 2014 cal 2014 cal 1 1
To learn more about this command, type in man cal for help.
Write a program named cal.c that prints out the following (which is the output when you type in cal 10 2018 in UNIX). Note that you are not asked to implement the cal command. You can assume that you know October 1 is a Monday. You will need to use loops and the % operator.
October 2018 Su Mo Tu We Th Fr Sa 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31
Solution :
#include<[tex]$\text{stdio.h}$[/tex]>
int [tex]$\text{dayofweek}$[/tex](int d, [tex]$\text{int m}$[/tex], int y){
static [tex]$\text{int t}[]$[/tex] = { 0, [tex]$3,2$[/tex], 5, [tex]$0,3$[/tex], 5, 1, [tex]$4,6,2,4$[/tex] };
y -= [tex]$m<3$[/tex];
return ([tex]$y+$[/tex] y/4 - y/100 + y/400 + t[m-1] + d) % 7;
}
int main() {
int month,year,i;
printf("Enter Month : ");
scanf("%d",&month);
printf("Enter Year : ");
scanf("%d",&year);
//find week day number
int day = dayofweek(1,month,year);
char * weekDays[] = {"Su","Mo","Tu","We","Th","Fr","Sa"};
printf("\n");
//print week day header
for(i=0;i<7;i++)
printf("%s ",weekDays[i]);
printf("\n");
//print days accordingly
for(i=0;i<day;i++)
printf(" ");
for(i=day;i<=day+30;i++){
printf("%-2d ",i-day+1);
if((i+day)%7==0)
printf("\n");
}
}
For this question we won't be directly working within LinkedList however. Instead, we'll be working with a Runner class:
public class Runner {
private LinkedList firstItemList;
private LinkedList listRemainder;
public Runner() {
firstItemList = null;
listRemainder = null;
}
}
For this question, write a method for the Runner class that will take in a LinkedList, split into two linked lists, and assign their values to firstItemList and listRemainder. Assign firstItemList to be a new LinkedList that just contains the first value. Assign listRemainder to be a new linkedList that contains everything EXCEPT the remainder.
More clearly, if you are given a linked list that looks like: 1 --> 2 --> 3 --> 4 Then assign firstItemList to 1 --> null and listRemainder to `2 --> 3 --> 4``
Please note this will be the only question that deals with a Runner Class instead of the LinkedList class directly.
public void split(LinkedList wholeList) {
}// end split
Solve in JAVA please using LinkedList methods and Node methods only if necessary
Answer:
Explanation:
The following method will take in a LinkedList as an argument and split it, adding only the first element to the firstItemList and the rest of the elements to listRemainder. The firstItemList and ListRemainder may have to be changed to static in order for the method to be able to access them, or add a setter/getter method for them.
public static void split(LinkedList list) {
firstItemList = new LinkedList();
listRemainder = new LinkedList();
firstItemList.add(list.peek());
list.pop();
listRemainder = list;
}
The complete java code for the Runner class can be defined as follows:
Java Code:public class Runner<T>//defining a class Runner
{
private LinkedList<T> firstItemList;//defining LinkedList type array variable that is firstItemList
private LinkedList<T> ListRemainder;//defining LinkedList type array variable that is ListRemainder
public Runner()//defining default constructor
{
firstItemList=null;//holding null value in list type variable
ListRemainder=null;//holding null value in list type variable
}
public void split(LinkedList<T> WholeLinkedList)//defining a method split that takes a list in parameter
{
if(WholeLinkedList==null)//defining if block that checks parameter variable value equal to null
return;//using return keyword
firstItemList=WholeLinkedList;//holding parameter variable value in firstItemList
ListRemainder=WholeLinkedList.next;//holding parameter variable next value in ListRemainder
firstItemList.next=null;//holding null value in firstItemList.next element
}
}
Code Explanation:
Defining a class Runner.Inside the class two LinkedList type array variable that is "firstItemList, ListRemainder" is declared.In the next step, a default constructor is defined, in which the above variable is used that holds null value in list type variable.In the next line, a method "split" is declared in which it accepts "WholeLinkedList" as a parameter.Inside this, if a conditional block is defined that checks parameter variable value equal to null if it's true it returns nothing.outside the conditional block, it checks the parameter value and holds value in it.Find out more about the linked list here:
brainly.com/question/23731177
Time-management techniques work most effectively when performed in which order?
prioritize tasks, reward system, study-time survey, project schedule
project schedule, study-time survey, reward system, prioritize tasks
reward system, prioritize tasks, project schedule, study-time survey
study-time survey, project schedule, prioritize tasks, reward system
Answer:
study-time survey, project schedule, prioritize tasks, reward system.
Explanation:
Time management can be defined as a strategic process which typically involves organizing, planning and controlling the time spent on an activity, so as to effectively and efficiently enhance productivity. Thus, when time is properly managed, it avails us the opportunity to work smartly rather than tediously (hardly) and as such making it possible to achieve quite a lot within a short timeframe. Also, a good time management helps us to deal with work-related pressures and tight schedules through the process of properly allocating the right time to the right activity.
Hence, time-management techniques work most effectively when performed in the following sequential order; study-time survey, project schedule, prioritize tasks, and designing (creating) a reward system.
Answer:
The Answer is:
D. study-time survey, project schedule, prioritize tasks, reward system
Explanation:
got it right on edge
What does an operating system provide so you can interact with a device
Answer:
Operating system software provides the user interface for interacting with the hardware components, whereas application software enables you to accomplish specific tasks.
Explanation:
please give me brainlist and follow
An operating system provides graphical user interface, which enables the user to interact seamlessly with a computer device.
Graphical user interface (GUI) provides user-friendly visual representations to help the user to manage the human interaction with the device via the operating system.
Some graphical user interface tools include icons, menus, and mouse.
Thus, with visual representations of data and operating instructions, users are able to understand the operating system and interact easily with the computer device.
Read more about graphical user interface at https://brainly.com/question/16956142
A ___________ is a variable used to pass information to a method.
Answer:
A parameter is a variable used to pass information to a method.
Explanation:
A parameter is a variable used to pass information to a method.
What are the features of parameter?In general, a parameter "beside, subsidiary" is any quality that aids in describing or categorizing a certain system. In other words, a parameter is a component of a system that is crucial or useful for identifying the system or assessing its functionality, status, or other characteristics.
In some fields, such as mathematics, computer programming, engineering, statistics, logic, linguistics, and electronic music production, the term "parameter" has more precise definitions.
In addition to its technical applications, it also has broader meanings, particularly in non-scientific situations. For example, the terms "test parameters" and "game play parameters" refer to defining qualities or boundaries.
A novel method of characterizing surface texture, in particular surfaces having deterministic patterns and features, is the use of feature parameters.
Traditional methods for characterizing surface texture, such profile and areal field parameters, are considered as supplementary to the feature parameter approach.
Learn more about parameter, here
https://brainly.com/question/29911057
#SPJ6
5.27 LAB*: Program: Soccer team roster (Vectors)
This program will store roster and rating information for a soccer team. Coaches rate players during tryouts to ensure a balanced team.
(1) Prompt the user to input five pairs of numbers: A player's jersey number (0 - 99) and the player's rating (1 - 9). Store the jersey numbers in one int vector and the ratings in another int vector. Output these vectors (i.e., output the roster). (3 pts)
Ex:
Enter player 1's jersey number:
84
Enter player 1's rating:
7
Enter player 2's jersey number:
23
Enter player 2's rating:
4
Enter player 3's jersey number:
4
Enter player 3's rating:
5
Enter player 4's jersey number:
30
Enter player 4's rating:
2
Enter player 5's jersey number:
66
Enter player 5's rating:
9
ROSTER
Player 1 -- Jersey number: 84, Rating: 7
Player 2 -- Jersey number: 23, Rating: 4
...
(2) Implement a menu of options for a user to modify the roster. Each option is represented by a single character. The program initially outputs the menu, and outputs the menu after a user chooses an option. The program ends when the user chooses the option to Quit. For this step, the other options do nothing. (2 pts)
Ex:
MENU
a - Add player
d - Remove player
u - Update player rating
r - Output players above a rating
o - Output roster
q - Quit
Choose an option:
(3) Implement the "Output roster" menu option. (1 pt)
Ex:
ROSTER
Player 1 -- Jersey number: 84, Rating: 7
Player 2 -- Jersey number: 23, Rating: 4
...
(4) Implement the "Add player" menu option. Prompt the user for a new player's jersey number and rating. Append the values to the two vectors. (1 pt)
Ex:
Enter a new player's jersey number:
49
Enter the player's rating:
8
(5) Implement the "Delete player" menu option. Prompt the user for a player's jersey number. Remove the player from the roster (delete the jersey number and rating). (2 pts)
Ex:
Enter a jersey number:
4
(6) Implement the "Update player rating" menu option. Prompt the user for a player's jersey number. Prompt again for a new rating for the player, and then change that player's rating. (1 pt)
Ex:
Enter a jersey number:
23
Enter a new rating for player:
6
(7) Implement the "Output players above a rating" menu option. Prompt the user for a rating. Print the jersey number and rating for all players with ratings above the entered value. (2 pts)
Ex:
Enter a rating:
5
Answer:
Explanation:
The following code is written in Java and loops five times asking for the desired inputs from the user and saves that information in two Vectors named jerseyNumber and ratings. Then creates a while loop for the menu and a seperate method for each of the options...
import java.util.Scanner;
import java.util.Vector;
class Brainly {
static Scanner in = new Scanner(System.in);
static Vector<Integer> jerseyNumber = new Vector<>();
static Vector<Integer> ratings = new Vector<>();
public static void main(String[] args) {
for (int x = 0; x < 5; x++) {
System.out.println("Enter player " + (x+1) + "'s jersey number:");
jerseyNumber.add(in.nextInt());
System.out.println("Enter player " + (x+1) + "'s rating:");
ratings.add(in.nextInt());
}
boolean reloop = true;
while (reloop == true) {
System.out.println("Menu");
System.out.println("a - Add player");
System.out.println("d - Remove player");
System.out.println("u - Update player rating");
System.out.println("r - Output players above a rating");
System.out.println("o - Output roster");
System.out.println("q - Quit");
char answer = in.next().charAt(0);
switch (answer) {
case 'a': addPlayer();
break;
case 'd': removePlayer();
break;
case 'u': updatePlayer();
break;
case 'r': outputRating();
break;
case 'o': outputRoster();
break;
case 'q': System.exit(0);
reloop = false;
break;
}
}
}
public static void addPlayer() {
System.out.println("Enter player's jersey number:");
jerseyNumber.add(in.nextInt());
System.out.println("Enter player's rating:");
ratings.add(in.nextInt());
}
public static void removePlayer() {
System.out.println("Enter Jersey number:");
int number = in.nextInt();
for (int x = 0; x < jerseyNumber.size(); x++) {
if (jerseyNumber.get(x) == number) {
jerseyNumber.remove(x);
ratings.remove(x);
}
}
}
public static void updatePlayer() {
System.out.println("Enter Jersey number:");
int number = in.nextInt();
System.out.println("Enter new Rating:");
int rating = in.nextInt();
for (int x = 0; x < jerseyNumber.size(); x++) {
if (jerseyNumber.get(x) == number) {
ratings.set(x, rating);
}
}
}
public static void outputRating() {
System.out.println("Enter Rating:");
int rating = in.nextInt();
for (int x = 0; x < ratings.size(); x++) {
if (ratings.get(x) >= rating) {
System.out.println(jerseyNumber.get(x));
}
}
}
public static void outputRoster() {
for (int x = 0; x < jerseyNumber.size(); x++) {
System.out.println("Player " + (x+1) + " -- Jersey number: " + jerseyNumber.get(x) + ", Rating: " + ratings.get(x));
}
}
}
Discuss similarities and differences between the software development and video game development processes.
Answer:
Game design is actually making the graphics of the game and how it works, software design is when the make all the equipment for the console and how it looks like.
Briefly stated, game design is an art, whereas software design is about the technicalities involved in creating any form of software, which include software architecture development, UX/UI, etc. Software design will eventually be a part of the game design, prototyping, and development process, among other things. Designing a game means having a creative idea, prototyping the gameplay, conceptualizing art, and then moving on to actual development process which will have programming, detailed artwork, audio production, game play development, etc.
Explanation:
Game design is an art, whereas software development is all about the technicalities which are involved in creating any form of software.
What is game design and software development?Game design is the making of the graphics of a game and how it actually works, software design is the making of all the equipment for the console and how it actually looks like.
Game design is an art, whereas software design is about the technicalities which are involved in creating any form of software, which include the software architecture development, UX/UI development, etc. Software design will eventually be a part of the whole game design, prototyping, and developmental processes, among other things. Designing a game means having a creative idea or thought, prototyping the gameplay, conceptualizing of the art, and then moving on to actual development process which will have all the programming, detailed artwork, audio production, game play development, etc.
Learn more about Software development here:
https://brainly.com/question/3188992
#SPJ2
Write a python program to print the square of all numbers from 0 to 10.
Answer:
for i in range(11):
print(i**2)
Write the following generic method that sorts an ArrayList of Comparable items. The sort method must use the compareTo method.
public static > void sort(ArrayList list)
Write a test program that:
1. prompts the user to enter 10 integers, invokes this method to sort the numbers, and displays the numbers in ascending order
2. prompts the user to enter 5 strings, invokes this method to sort the strings, and displays the strings in ascending (alphabetical) order
Answer:
Explanation:
The following code is written in Java, it prompts the user to enter 10 integers and saves them to an ArrayList. Then it prompts for 5 strings and saves them to another ArrayList. Then, it calls the sort method and adds the lists as parameters. Finally, it prints out both lists completely sorted in ascending order.
import java.util.ArrayList;
import java.util.Scanner;
class Division{
public static double division(double a, double b) throws Exception {
if(b == 0)
//throw new Exception("Invalid number.");
return (a / b);
return a / b;
}
public static void main(String[] args) {
Scanner in = new Scanner(System.in);
ArrayList<Integer> mylist2 = new ArrayList<>();
for (int x = 0; x < 10; x++) {
System.out.println("Please Enter a Number: ");
int number = in.nextInt();
mylist2.add(number);
}
ArrayList<String> mylist = new ArrayList<>();
for (int x = 0; x < 5; x++) {
System.out.println("Please Enter a Word: ");
String word = in.nextLine();
mylist.add(word);
}
sort(mylist);
sort(mylist2);
for (String x: mylist) {
System.out.print(x + ", ");
}
System.out.println("");
for (int x: mylist2) {
System.out.print(x + ", ");
}
}
public static <E extends Comparable<E>> ArrayList<E> sort(ArrayList<E> list) {
E temp;
if (list.size()>1) // check if the number of orders is larger than 1
{
for (int x=0; x<list.size(); x++) // bubble sort outer loop
{
for (int i=0; i < list.size() - x - 1; i++) {
if (list.get(i).compareTo(list.get(i+1)) > 0)
{
temp = list.get(i);
list.set(i,list.get(i+1) );
list.set(i+1, temp);
}
}
}
}
return list;
}}
outline four advantages of digital
cameras over analogue cameras
Answer:
Explanation:
A digital camera refers to a camera whereby the photographs are being captured in digital memory. An analogue camera refers to the traditional camera that typically sends video over cable.
The advantages of digital cameras over analogue cameras include:
1. Massive Storage Space:
There is a large storage space for photos and thus helps to prevent limitations to film. There are memory cards that can store several images.
2. Multiple functions:
The digital camera performs several functions like face detection, night and motion detection This makes capturing of images more fun and brings about better images.
3. Video Camera:
Digital cameras can also capture moving pictures while analog camera typically captures images that are still. Digital camera is vital as it can be used for live streaming.
4. Smaller and Lighter:
Digital cameras are usually smaller and lighter which makes them more portable and easy to carry about.
Assume you have created an inheritance hierarchy with the following classes:
Class: Organization
Methods: getName(), getNumEmployees(), getTaxLiability()
Class: Nonprofit extends Organization
Methods: getAnnualContribution(), getTaxLiability()
Class: Commercial extends Organization
Methods: getTaxLiability()
In your implementation class, assume you create the following line of code.
Organization o = new Nonprofit();
Using this line of code, write additional code that will call the getAnnualContribution() method
Answer:
Creating an object of Class Organization Organization o = new Nonprofit
Explanation:
Organization Methods: getName(), getNumEmployees(), getTaxLiability(). Class: Nonprofit extends Organization Methods: getAnnualContribution(), getTaxLiability(). Class: Commercial extends Organization Methods: getTaxLiability().
Which of the following transfer rates is the FASTEST?
1,282 Kbps
O 1,480 Mbps
1.24 Gbps
181 Mbps
Answer:
The correct answer is 1,480 Mbps.
Explanation:
For this you have to know how to convert bytes to different units.
1,000 Bytes (b) = 1 Kilobyte (Kb)
1,000 Kilobyte (Kb) = 1 Megabyte (Mb)
1,000 Megabytes (Mb) = 1 Gigabyte (Gb)
and Finally, 1,000 Gigabytes (Gb) = 1 Terrabyte (Tb)
Answer:
1,480 Mbps
Explanation:
1,480 Mbps is equal to 1.48 Gbps, and so it is the fastest transfer rate listed because it is greater than 1.24 Gbps. In summary, 1,480 Mbps > 1.24 Gbps > 181 Mbps > 1,282 Kbps.
what materials can I find at home and make a cell phone tower
Answer:
you cant
Explanation:
You simply cant make a tower from materials found in a household
Write a recursive method called permut that accepts two integers n and r as parameters and returns the number of unique permutations of r items from a group of n items. For given values of n and r, this value P(n, r) can be computed as follows:
n!/(n - r)!
For example , permut (7, 4) should return 840.
Answer:
Following are the code to the given question:
public class Main//defining a class Main
{
static int permut(int n, int r)//defining a method permut that holds two variable
{
return fact(n)/fact(n-r);//use return keyword to return calcuate value
}
static int fact(int n)//defining a fact method as recursive to calculate factorials
{
return n==0?1:n*fact(n-1);//calling the method recursively
}
public static void main(String[] abs)//main function
{
//int n=7,r=4;//defining integer variable
System.out.println(permut(7,4));//use print method to call permut method and print its values
}
}
Output:
840
Explanation:
Following is the explanation for the above code.
Defining a class Main.Inside the class two methods, "permut and fact" were defined, in which the "permut" accepts two values for calculating its permutated value, and the fact is used for calculates factorial values recursively. At the last, the main method is declared, which uses the print method to call "permut" and prints its return values.Specialized high-capacity second storage devices designed to meet organizational demands
1 CD DEVICES
2. FLASH DRIVES
3. PLATTERS
4. MASS STORAGE DEVICES
Answer:
CD devices
Explanation:
Answer:
Mass storage devices
Explanation:
I don't think I can really explain it, that is just the definition of it.
Elimination:
CD and flash drives aren't high-capacity
Platters aren't really storage devices, they are a part of hard drives
Create the following: (1) a CREATE VIEW statement that defines a view named FacultyCampus that returns three columns: FirstName, LastName, and Term for faculty that are teaching during the semester, along with the terms they teach, and (b) a SELECT statement that returns all of the columns in the view, sorted by Term, of faculty members who are teaching during the semester.
Answer:
a-
CREATE VIEW FacultyCampus
AS
SELECT F.FirstName, F.LastName, C.Term
FROM Faculty F, Course C
WHERE C.Faculty_ID=F.Faculty_ID
b-
SELECT *
FROM FacultyCampus
ORDER BY Term DESC
Explanation:
As the database table creation is not given, the question is searched and the remaining portion of the question is found which indicates the table created. This is attached:
From the created database, the view is created as follows:
a-
CREATE VIEW FacultyCampus
AS
SELECT F.FirstName, F.LastName, C.Term
FROM Faculty F, Course C
WHERE C.Faculty_ID=F.Faculty_ID
Here first the view is created in which the selection of the first name from faculty table, last name from faculty table, and term from the Course table is made where the values of Faculty ID in course table and Faculty ID of Faculty table are equal.
The select query is as follows:
b-
SELECT *
FROM FacultyCampus
ORDER BY Term DESC
Here the selection of all the columns from the view is made and are ordered by the term in the descending form.
Consider the following two relations for Millennium College
STUDENT(StudentID, StudentName,CampusAddress, GPA)
REGISTRATION(StudentID, CourseID, Grade)
Following is a typical query against these Relation:
SELECT Student_T.StudentID,StudentName,
CourseID, Grade
FROM Sudent_T, Registration_T
WHERE Student_T.StudentID =
Registration_T.StudentID
AND GPA> 3.0
ORDER BY StudentName;
Required:
On what attributes should indexes be defined to speed up this Query? PLease give reasons for each selected