Show all the hugs that will take place

Assignment Help Computer Engineering

Reference no: EM133423758

Question: You are having a family reunion. Everyone will be there. You expect everyone to hug one another. you need a query that will show all the hugs that will take place. Note: make sure you only get one direction of the hug (if you aren't careful, it will show up twice).

This is based off 3 tables the first being person with name and gender and person ID and then a parent table with parentid and childid and foreign keyed with both of those ID's referencing the first table and the next table is spouse with spouseid and spouseid2 again foreign keyed to the person table. How would you write a query for this.

Reference no: EM133423758

Questions Cloud

Explain how you came up with the maps : Explain how you came up with the maps (you will lose the majority of the marks if you daw the final maps without explanations).

What are two professions of constand and abraham viljoen : What did Morris Janowitz, working for the Psychological Warfare Division, discover was the dominant Nazi motive to fight in WWII?

Do research online on how to write or structure : how to write or structure/format a business letter and share at least one link in class. Discuss what you learned in your research and share the topic

Discuss why the bet v1 protein is found in so many fruits : Discuss why the Bet v1 protein is found in so many fruits and vegetables, and provide some plausible reasons for why the author is not allergic to all fruits

Show all the hugs that will take place : you need a query that will show all the hugs that will take place - How would you write a query for this

Describe available types and strategies of ongoing training : Describe the available types and strategies of ongoing training and technical support that are available to support nursing staff through the implementation

Describe historical basis for darwin theory of evolution : Darwin drew from several lines of reasoning in the development of his theory of evolution. Describe the historical basis for Darwin's theory of evolution.

What is the percent server utilization : Determine the system departure and response times of these 14 customers and What is the percent server utilization

Targeting some students in replies : As the instructor, you notice that this student is being blunt, disrespectful, and targeting some students in their replies.

User Account

All Pages