Reference no: EM131373975
Database Design Discusion
Part 1 Combining Tables
Please respond to BOTH of the following questions:
Question A
What is a join command? In addition, How can you combine two tables/views together? For instance one table contains 100 rows and the other one contains 200 rows, have exactly the same fields and you want to show a query with all data (300 rows).
Question B
Why can a "group by" or "order by" clause be expensive to process? What is the difference between a where and having clause?
Part 2 Peer Responses
Please respond to two peers.
Peer 1 Bill
The join clause does as it sounds, it will join two more tables in a relational database. I looked at some forums for suggestions, and one of the better answers I found in how to join the tables would be using the following syntax:
CREATEVIEW vw_combined AS
SELECT *
FROM TABLE1 t1
JOIN TABLE2 t2 ON t2.col = t1.col
Again, both tables need to have the same columns of data. The having clause is a limit on the results that are produced on the search. The where clause determines what row to be included on the select and what it is specifically looking for.
Peer 2 Ted's responce to Bill
Bill, how would you combine the contents of two tables without a JOIN?
Evaluate the given statement
: "Ultimately, the study of international business is no different from the study of domestic business. Thus, there is no point in having a separate course on international business." Evaluate this statement.
|
Describe two features any of the ornithopod dinosaurs
: Name and describe two features any of the Ornithopod Dinosaurs had that helped them eat plants. Explain how that feature would help them eat plants.
|
What is the definition of genre
: What is the definition of genre, according to the scholars that Dirk quotes (Lloyd Bitzer, Amy Devitt, and Carolyn Miller)? What two things do you need to identify in a text in order to understand its genre
|
Discuss the possible implications of such a development
: How do the Internet and the associated World Wide Web affect international business activity and the globalization of the world economy?
|
How can you combine two tables or views together
: What is a join command? In addition, How can you combine two tables/views together? For instance one table contains 100 rows and the other one contains 200 rows, have exactly the same fields and you want to show a query with all data (300 rows).
|
Sildenfil for severe lymphatic malformations
: The drug (Viagra) has been used to treat pulmonary hypertension in children. Its typical side effects in children are nausea, headaches and cold-like symptoms such as a runny nose or fever, Lane said. Spontaneous erections are possible but are an ..
|
Who benefits from globalization of flat panel display
: Why is the manufacturing of flat panel TVs migrating to different locations around the world?- Who benefits from the globalization of the flat panel display industry? Who are the losers?
|
Disease or condition researchers are attempting to treat
: Choose one modern example of gene therapy (since 2005), describe the disease or condition researchers are attempting to treat, and explain how the therapy might repair the underlying cause of the disease.
|
What technology was the most difficult to live without
: Prepare a one-to-two page paper that addresses the following questions: What did you learn from your experience? What technology was the most difficult to live without
|