Ask Question, Ask an Expert

+61-413 786 465

info@mywordsolution.com

Ask Homework Help/Study Tips Expert

Students at your hometown high school have decided to organize their social network using databases.

So far, they have collected information about sixteen students in four grades, 9-12. Here's the schema:

Highschooler ( ID, name, grade ): there is a high school student with unique ID and a given first name in a certain grade. Friend ( ID1, ID2 ): the student with ID1 is friends with the student with ID2.

Friendship is mutual, so if (123, 456) is in the Friend table, so is (456, 123). Likes ( ID1, ID2 ): the student with ID1 likes the student with ID2. Liking someone is not necessarily mutual, so if (123, 456) is in the Likes table, there is no guarantee that (456, 123) is also present.

Create SQL Queries to Find:

1. Find the names of all students who are friends with someone named Gabriel.

2. Find all students who do not appear in the Likes table (as a student who likes or is liked) and return their names and grades. 3. Find the name and grade of all students who are liked by more than one other student.

3. For every student who likes someone 2 or more grades younger than themselves, return that student's name and grade, and the name and grade of the student they like.

Homework Help/Study Tips, Others

  • Category:- Homework Help/Study Tips
  • Reference No.:- M93125501

Have any Question?


Related Questions in Homework Help/Study Tips

Assignment 2 critical thinking essaythe purpose of this

Assignment 2: Critical Thinking Essay The purpose of this assignment is to demonstrate your theoretical understanding of psychological momentum and to also have you research and think about this topic in more detail. Rea ...

Public health services please respond to the

"Public Health Services" Please respond to the following: Analyze two (2) essential public health care services found in the text. Examine these services in relationship to one (1) well-known healthcare organization in y ...

Question prepare a 2-3 page report format below in which

Question: Prepare a 2-3 page report (format below) in which you address the questions below: 1. c 2. What proportion of the food supply does each control? 3. What proportion and which kinds of food are produced in other ...

Assignment -the advanced service management fead49 course

Assignment - The Advanced Service Management (FEAD49) course gives you an overview of the key theoretical concepts frequently discussed and debated in the field of service research. In this individual assignment, you sho ...

One of the results of the introspective philosophies was

One of the results of the introspective philosophies was the rise of thoughts that rushed the improvement of logical instruments utilized to explore the normal world. Physiology and psychophysics emerged. What was Christ ...

Interview three 3 individuals of your choosing using the

Interview three (3) individuals of your choosing, using the set of questions you created. Your questions must include: (Responses to these questions will be used in later assignments.) 1) Age 2) Race 3) Ethnicity 4) Gend ...

This weeks assignment is a creative exploration of the

This week's assignment is a creative exploration of the public realm in which you live. First, identify a "third place" in your community (i.e. a coffeeshop where people hang out and are known to each other). Second, spe ...

Question for this assignment you will first review the

Question: For this assignment, you will first review the following case study: A textile manufacturer is closing its North Carolina plant and moving the production of its products to a developing nation in Southeast Asia ...

Assignmentin this assignment you will be creating an essay

Assignment In this assignment, you will be creating an essay on "Describe contemporary policing trends and issues that law enforcement is facing". Your essay will follow the academic 5-paragraph format: Introduction para ...

Multiple-choice questions -1 the artifacts of the ancient

MULTIPLE-CHOICE QUESTIONS - 1. The artifacts of the ancient Nok people of the Jos Plateau provide archaeological evidence of all of the following EXCEPT a. highly developed iron-making capabilities. b. settled communitie ...

  • 4,153,160 Questions Asked
  • 13,132 Experts
  • 2,558,936 Questions Answered

Ask Experts for help!!

Looking for Assignment Help?

Start excelling in your Courses, Get help with Assignment

Write us your full requirement for evaluation and you will receive response within 20 minutes turnaround time.

Ask Now Help with Problems, Get a Best Answer

Why might a bank avoid the use of interest rate swaps even

Why might a bank avoid the use of interest rate swaps, even when the institution is exposed to significant interest rate

Describe the difference between zero coupon bonds and

Describe the difference between zero coupon bonds and coupon bonds. Under what conditions will a coupon bond sell at a p

Compute the present value of an annuity of 880 per year

Compute the present value of an annuity of $ 880 per year for 16 years, given a discount rate of 6 percent per annum. As

Compute the present value of an 1150 payment made in ten

Compute the present value of an $1,150 payment made in ten years when the discount rate is 12 percent. (Do not round int

Compute the present value of an annuity of 699 per year

Compute the present value of an annuity of $ 699 per year for 19 years, given a discount rate of 6 percent per annum. As