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
GrogVix [38]
4 years ago
3

onsider the following two relations for Millennium College: STUDENT(StudentID, StudentName, CampusAddress, GPA) REGISTRATION(Stu

dentID, CourseID, Grade) Following is a typical query against these relations: SELECT Student_T.StudentID, StudentName, CourseID, Grade FROM Student_T, Registration_T WHERE Student_T.StudentID = Registration_T.StudentID AND GPA > 3.0 ORDER BY StudentName; On what attributes should indexes be defined to speed up this query? Give the reasons for each attribute selected.
Computers and Technology
1 answer:
denpristay [2]4 years ago
3 0

Answer:

Student Id, Gpa

Explanation:

a)

Student Id,GpA are the attributes selected to speed up this query. The reason behind these selections are because the student Id and Gpa are the primary key and foregin key respectively.

b)

Student Id- This is the Primary key

GPA-This is the Foreign key

You might be interested in
Based on the module,
svp [43]

Answer:

Explanation:

One group of students did an experiment to study the movement of ocean water. The steps of the experiment are listed below.

Fill a rectangular baking glass dish with water.

Place a plastic bag with ice in the water near the left edge of the dish.

Place a lighted lamp near the left edge of the dish so that its light falls directly on the plastic bag.

Put a few drops of ink in the water.

The student did not observe any circulation of ink in the water as expected because the experiment had a flaw. Which of these statements best describes the flaw in the experiment? (2 points)

Not enough ink was added.

Not enough water was taken.

The dish was too small for the experiment.

The lamp and the ice bag were at the same place.

8 0
3 years ago
Module 1 and 2 Coding Guided Notes Fill in your answers to each response as you read through the lesson pages in the coding cour
creativ13 [48]

Answer:

Code; code; program.

Explanation:

1. Instructions for computers to solve a problem is known as code. Computer code is how humans and machines talk to each other. Some examples of programming language used to write a code in instructing a computer for the execution of a task are python, Java, Javascript, ruby, c++, c# etc.

2. Learning to code or write a program allows for a solution to a problem.

4 0
3 years ago
Read 2 more answers
On many advanced routers and switches, you can implement QoS through bandwidth management, such as __________, where you control
Mila [183]

Answer:

c. traffic shaping

Explanation:

A traffic shaping system is one that allows to adapt the incoming data traffic that comes from some node of the network giving it a special treatment called conformation of accepted traffic and thus allowing the frames to be forwarded through the network of data under traffic rules without having gone through some traffic shaping method, this can be detected as non-conforming traffic at the edge of access to the discarded metropolitan network.

Traffic shaping is a mechanism that alters the traffic characteristics of the cell flow of a connection to achieve better network efficiency while maintaining QoS objectives or in order to ensure that the cell flow conforms to traffic parameters according to the leaky bucket algorithm configuration of the traffic contract. Traffic shaping can be used in ATM, for example, to reduce peak speed, limit the length of the burst by means of adequate spacing of cells over time. The use and location of this function is network specific.

5 0
3 years ago
Is Apple a consumer or luxury brand? Give examples.
Alexus [3.1K]

Answer:

Apple is a luxury brand due to it stable products, expensive products, and its releasing phones costing $1,000 or more and moving its services to the higher end

Explanation:

6 0
3 years ago
.should your information technology department and information security department report to the same department head? Or, shoul
Lilit [14]

Answer:

Information technology department is related with all the information retrieving, storing ,processing etc through a system .Information security department is responsible for protection of information from unauthorized access.

For maintaining the collaboration and proper functioning of both the department should report to the same head of the department .In this way, they can stay updated, secured, assisted togather and help each other as both departments are working for the information field.

Separate reporting of the both departments to different head can create confusion,risk of security, dysfunctional working,other risks as well.Thus, both departments should report to same head of department .

4 0
3 years ago
Other questions:
  • In an ipv4 address, what are the maximum number of bits that can be used to identify the network address
    14·1 answer
  • A computer system has 9,850 processes and 172 of them were suspended while 276 of them were terminated. Explain why some of the
    12·1 answer
  • Which is the best practice for placing graphics on a slide?
    6·2 answers
  • Which of these is an example of open-source software?
    13·1 answer
  • If a file you are opening for appending does not exist, the operating system will detect the missing file and terminate the oper
    14·1 answer
  • Inserting merge fields in the letter<br>steps required <br>plz ​
    11·2 answers
  • 90 points can someone please write the code for this (HTML):
    13·1 answer
  • 1. How many bits would you need to address a 2M × 32 memory if:
    8·1 answer
  • if someone has become very attached to their mobile device and feels anxious if the cannot connect to the internet, what are the
    7·1 answer
  • The choice of database does not have any impact on the relevancy of search results?
    13·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!