Database Concepts (7th Edition)
7th Edition
ISBN: 9780133544626
Author: David M. Kroenke, David J. Auer
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 5, Problem 5.31RQ
Program Plan Intro
Select query in
In DBMS (Database Management System), the SQL “SELECT” query is used to display all the data from the database table which returns this data in the form of a result table.
Syntax:
SELECT * FROM table_Name;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
THIS MODULE IS ABOUT SUBQUERIES, SO YOU MUST USE SUBQUERIES INSTEAD OF TABLE JOINS
(a) From which two fields in which table can you calculate the enrollment of a section?(b) From which table can you get both course and section numbers?(c) Which field in table SECTION uniquely identifies a section, section id or section no?(d) Write a SQL statement to show sections and their enrollment.(e) Write a SQL statement to show sections with enrollment greater than five. Display both course andsection numbers
Instructions
Write SQL queries to solve the following problems. We will be using the “university” database. All queries should involve only the instructor table. After you are done, save your work as .sql file and turn in the .sql file into Moodle for grading.
Write a SQL statement to display all columns using the SQL asterisk (*) wild-card character.
Write a SQL statement to display ID and name of the instructors (ID appears first).
Write a SQL statement to display department names.
Write a SQL statement to display unique department names. (expect 7 rows returned)
Write a SQL statement to display all info about instructors having a salary greater than 75000. (expect 6 rows returned)
Write a SQL statement to display department name, instructor name, and salary for instructors that have a salary less than 70000. Sort the results in ascending order by department name. (expect 4 rows returned)
Write a SQL statement to display name, department name, and salary for instructors that have a…
question 5
please use the picture below to answer the following question
Assuming all other tables are already created, write a SQL statement to create the following tables and the given constraint(s).
Chapter 5 Solutions
Database Concepts (7th Edition)
Ch. 5 - Explain how entities are transformed into tables.Ch. 5 - Prob. 5.2RQCh. 5 - Prob. 5.3RQCh. 5 - What is denormalization?Ch. 5 - Prob. 5.5RQCh. 5 - Explain the problems that denormalized tables may...Ch. 5 - Explain how the representation of weak entities...Ch. 5 - Explain how supertype and subtype entities are...Ch. 5 - Prob. 5.9RQCh. 5 - Prob. 5.10RQ
Ch. 5 - Show two different ways to represent the 1:1...Ch. 5 - Prob. 5.12RQCh. 5 - Prob. 5.13RQCh. 5 - Prob. 5.14RQCh. 5 - Prob. 5.15RQCh. 5 - Prob. 5.16RQCh. 5 - For your answer to question 5.15, code an SQL...Ch. 5 - Prob. 5.18RQCh. 5 - Prob. 5.20RQCh. 5 - Prob. 5.21RQCh. 5 - Explain how the terms parent table and child table...Ch. 5 - For your answers to questions 5.20, 5.21, and...Ch. 5 - Prob. 5.24RQCh. 5 - Prob. 5.25RQCh. 5 - Prob. 5.26RQCh. 5 - Prob. 5.27RQCh. 5 - Prob. 5.28RQCh. 5 - Define the three types of recursive binary...Ch. 5 - Prob. 5.30RQCh. 5 - Prob. 5.31RQCh. 5 - Prob. 5.32RQCh. 5 - Prob. 5.33RQCh. 5 - Prob. 5.34RQCh. 5 - Code an SQL statement that creates a table with...
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
- You have the following tables: MANAGERS (MANAGER_ID, LAST_NAME, FIRST_NAME, DEPARTMENT) ACCOUNTS (ACCOUNT_NUMBER, MANAGER_ID, CUST_ID, BALANCE) CUSTOMERS (CUST_ID, LAST_NAME, FIRST_NAME) Write a SQL statement that lists account number, balance, MANAGER’s last name, CUSTOMER ID, and CUSTOMER’s last name for every account in the ACCOUNTS table.arrow_forwardTrue or False? To select all columns from a table named STUDENTS, we can use the SQL statement ‘’SELECT STUDENTS FROM’’.arrow_forwardYou are working with a database table that contains customer data. The table includes columns about customer location such as city, state, country, and postal_code. The state names are abbreviated. You want to check for state names that are greater than 2 characters long. You write the SQL query below. Add a LENGTH function that will return any state names that are greater than 2 characters long.arrow_forward
- Write a PL/SQL Programming block to do below actions 2.Before you work on Quesiton 2 , please create a table because you will be inserting numbers in thisMessages tableCREATE TABLE messages( RESULTS NUMBER)Run below query to see if there is any data :SELECT * FROM MESSAGESarrow_forwardWrite an SQL statement to create a table named Car. The Car table should have the columns to hold a car’s manufacturer, year model, and a 20-character vehicle ID number.arrow_forwardWrite the SQL code that will produce the same information that was shown in Problem 2, but sorted by the employee’s last name. The results of running that query are shown in Figure P7.3.arrow_forward
- Answer the following questions based on the information in the PATIENT table below. Write SQL queries statement and provide the output of each query. (Screenshot the interface in MySQL that show SQL statement and output for each question). PATIENT PID PNAME AGE ADATE 1001 JAMAL 35 2000-10-28 M 1002 TAN 52 1003 MARIAM 30 2000-11-20 M 2000-07-16 F 2000-12-18 M 1004 JOE 27 1005 SOFEA 19 2000-04-25 F 1) Change the admission date of Sofea to 18-12-2000. GENDERarrow_forwardWrite an SQL statement to change the value of Std. Poodle in BreedName of PET_3 to Poodle, Stdarrow_forwardWrite a sql query to create the following table.arrow_forward
- USE this part to write SQL statements Branch(branch_id:integer, branch_name:varchar(50), branch_location:varchar(40), money_on_hand:numeric(15,2) create table Branch (branch_id integer, branch_name varchar(50), branch_location varchar(40), money_on_hand numeric(15,2), primary key (branch_id)); Loan(loan_number:integer, branch_id:integer, amount:numeric(8,2)) foreign key branch_id references Branch(branch_id) create table Loan (loan_number integer, branch_id integer, amount numeric(8,2), primary key (loan_number), foreign key (branch_id) references Branch (branch_id)); Customer(customer_id:integer, customer_last_name:varchar(35),customer_first_name:varchar(25), customer_street:varchar(30), customer_zip:integer) create table…arrow_forwardWrite an SQL query that uses a multiple-column subquery in a FROM clause. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses a subquery with the GROUP BY statement and HAVING clause. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses a multiple-row subquery in a WHERE clause. The subquery will include the GROUP BY statement and another multiple-row subquery in a HAVING clause. Explain what the query is intended to do. Write an SQL query that joins three tables and uses any type of a subquery. Explain what the query is intended to do. Write an SQL query that is based on multiple tables and uses the DECODE function. Explain what the query is intended to do.arrow_forwardWrite a SQL statement to get the list of all the law firms from thedatabase in alphabetical order by firm name. Include all thecolumns from the LawFirm table.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you