![Database Concepts (8th Edition)](https://www.bartleby.com/isbn_cover_images/9780134601533/9780134601533_largeCoverImage.gif)
Database Concepts (8th Edition)
8th Edition
ISBN: 9780134601533
Author: David M. Kroenke, David J. Auer, Scott L. Vandenberg, Robert C. Yoder
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 3, Problem 3.39RQ
Program Plan Intro
SQL:
- SQL stands for “Structured Query Language”.
- The current version of SQL is “ANSI SQL – 92”.
- SQL is not a
programming language. It is text-based and it is also called as data sublanguage.- In order to get SQL as a complete programming language, it should be included in scripting languages like Java, C#, and so on.
- It contains constructs which are used to define and process
database . They are executed using DBMS-supplied command prompt. - Some of the DBMS products provide GUI tools in order to perform tasks are as follows:
- SQL Server
- Oracle Database
- MySQL
Display values from table:
The contents from the table can be viewed by using “SELECT” statement which comes under Data Manipulation Language (DML). Syntax to view the contents using asterisk (*) is as follows:
SELECT * FROM table_Name;
Columns can also be retrieved by replacing all the column names in place of the asterisk symbol.
“JOIN ON” Syntax:
The “JOIN ON” syntax is usually used to join two or more than two tables. This syntax usually works with “WHERE” clause. The keyword “JOIN” is normally placed between the table names in the SQL FROM clause. The keyword “ON” includes the matching key values.
Expert Solution & Answer
![Check Mark](/static/check-mark.png)
Want to see the full answer?
Check out a sample textbook solution![Blurred answer](/static/blurred-answer.jpg)
Students have asked these similar questions
Which operator is used in the join condition to perform an outer join?
Select one:
a.-
b.>
c.(+)
d.=
Why are the NATURAL JOIN keywords not an option for producing a self-join?
Answer part (4) of question 3.37 but use joins using JOIN ON syntax
Chapter 3 Solutions
Database Concepts (8th Edition)
Ch. 3 - Prob. 3.1RQCh. 3 - What is a data sublanguage?Ch. 3 - Prob. 3.3RQCh. 3 - Prob. 3.4RQCh. 3 - Prob. 3.5RQCh. 3 - Why do some standard SQL-92 statements fail to run...Ch. 3 - Use the following tables for your answers to...Ch. 3 - Write an SQL CREATE TABLE statement to create the...Ch. 3 - Prob. 3.9RQCh. 3 - Prob. 3.10RQ
Ch. 3 - Prob. 3.11RQCh. 3 - Is PET or PET_2 a better design? Explain your...Ch. 3 - Prob. 3.13RQCh. 3 - Prob. 3.14RQCh. 3 - Prob. 3.15RQCh. 3 - Prob. 3.16RQCh. 3 - Prob. 3.17RQCh. 3 - Write an SQL statement to display the breed, type,...Ch. 3 - Prob. 3.19RQCh. 3 - Prob. 3.20RQCh. 3 - Write an SQL statement to display the breed, type,...Ch. 3 - Write an SQL statement to display the name, breed,...Ch. 3 - Write an SQL statement to display the pet ID,...Ch. 3 - Prob. 3.24RQCh. 3 - Prob. 3.25RQCh. 3 - Write an SQL statement to display the name and...Ch. 3 - Prob. 3.27RQCh. 3 - Write an SQL statement to count the number of...Ch. 3 - Write an SQL statement to count the number of...Ch. 3 - Prob. 3.30RQCh. 3 - Prob. 3.31RQCh. 3 - Prob. 3.32RQCh. 3 - Prob. 3.33RQCh. 3 - Answer question 3.33, but do not consider any pet...Ch. 3 - Write an SQL statement to display the last name,...Ch. 3 - Write an SQL statement to display the last name,...Ch. 3 - Write SQL statements to (1) create the BREED...Ch. 3 - Prob. 3.38RQCh. 3 - Prob. 3.39RQCh. 3 - Prob. 3.40RQCh. 3 - Write an SQL statement to display the...Ch. 3 - Write SQL statements to add three new rows to the...Ch. 3 - Write SQL statements to add three new rows to the...Ch. 3 - Write an SQL statement to change the value of Std....Ch. 3 - Explain what will happen if you leave the WHERE...Ch. 3 - Prob. 3.46RQCh. 3 - Prob. 3.47RQCh. 3 - Prob. 3.48RQ
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- Using tables named T1 and T2, write a query example for each of the three join types you described in Question 2. Assume that T1 and T2 share a common column named Cl.arrow_forwardWhat three join types are included in the outer join classification?arrow_forwardStudent: studentNO, firstName, lastName, studentProgram Professor: professorID, professorProgram, professorName Student_professor: studentNO, professorID, mentor Complete the following requirements: Using the UNION operator, do a full outer join to display the student last name and student program as well as the professor name and professor program. No JOIN operator is to be used in this requirement. Create a query/subquery to display student first name, last name and program. The student program must be same as that in the professor table and the professor program name starts with a ‘C’. This query will use a subquery and not a join. Create a query to display the professor ID, professor name and mentor column including records where the professor ID is not on the student_professor table. Note, this will be a left join. Make sure to eliminate duplicates from the output. Display the average age of students in each student program. Display the number of students in the Computer…arrow_forward
- 1. Using your code examples, explain what the following are and when you would use them: A subquery. A Join.arrow_forwardWhich type of join is demonasted by the folloing query? Select from make. model where make modelID to mode ID a) Non-Equlion b) Self Join c) Cross Join d) Equijoinarrow_forwardNatural join operation is denoted by symbol____. Select one: a. U. b. ρ. c. σ. d. ⨝.arrow_forward
- Describe any issues you might have when doing join operations with the NATURAL JOIN keywords.arrow_forwardThe team wants to track potential list of users who may have forgotten their items on the cars. Therefore, you need to return USER_FIRST_NAME, USER_LAST_NAME, TRAVEL_START_TIME, TRAVEL_END_TIME information from the USERS and TRAVELS tables connected inside a JOIN statement by the USING function and USER_ID fieldarrow_forwardWhat is the difference between an inner join and outer join?arrow_forward
- Q: This is an SQL question, which is correct: Which of the following statements about JOINs are true? a. If NATURAL JOIN and FULL OUTER JOIN have the same number of rows, then LEFT OUTER JOIN AND RIGHT OUTER JOIN will not have the same number of rows. b. Number of rows in a NATURAL JOIN is always less than the number of rows in a FULL OUTER JOIN c. LEFT OUTER JOIN and RIGHT OUTER JOIN will always have the same number of rows d. Number of rows in a NATURAL JOIN can be equal to the number of rows in a FULL OUTER JOIN e. LEFT OUTER JOIN can produce more rows than FULL OUTER JOINarrow_forwardDescribe any difficulties you may have when performing join operations with the NATURAL JOIN keywords.arrow_forwardYou can create both Inner Join and Left Join on same Tableau File on different worksheet. Group of answer choices : True False In Techwear, the shipping number becomes the sales transaction number when the invoice is created, Group of answer choices : True Falsearrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage LearningDatabase Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
- A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305251038/9781305251038_smallCoverImage.gif)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781305627482/9781305627482_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781285196145/9781285196145_smallCoverImage.gif)
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
![Text book image](https://www.bartleby.com/isbn_cover_images/9781111527273/9781111527273_smallCoverImage.gif)
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr