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 3, Problem 3.46RQ
Program Plan Intro
SQL:
- SQL stands for “Structured Query Language”.
- The current version of SQL is “ANSI SQL – 92”.
- It contains constructs which are used to define and process
database . They are executed using DBMS-supplied command prompt. - 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.
Table Creation:
Creating table comes under Data Definition Language (DDL). Syntax for creating table is as follows:
CREATE TABLE TABLE_NAME (
Column1 datatype,
Column2 datatype,
…
);
DELETE FROM statement:
“DELETE FROM” statement is used in order to delete existing records (rows and columns) from the table.
Note: It is necessary to use “WHERE” clause when deleting values, because, when it is ignored all the values from the mentioned column name gets deleted.
Syntax:
DELETE FROM table_Name WHERE condition;
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
//trying to make recursive SQL statement to get the days of the week , can you tell me what does not work in this query:
WITH cte_number (counter, weekday) AS(SELECT 0, Datename(DW,0) UNION ALLSELECTcounter+1, Datename(DW, counter+1)FROM cte_numberwhere counter<6) select weekday from cte_number;
//thanks for you assistance
Write the SQL statements using the university schema to perform the followingoperations: Delete all takes tuples corresponding to any section of any course withthe word “advanced” as a part of the title; ignore case when matching theword with the title.
The SQL SELECT statement performs case-sensitive comparisons. a. True b. False
Chapter 3 Solutions
Database Concepts (7th 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 - Prob. 3.23RQCh. 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 - Prob. 3.44RQCh. 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
- Develop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department id= 90 (there is suppose to be 3 employee who work in Department 90)- IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first name. salary of each employee and store them in local variables.+ SELECT LOAD INTO v_firstname1, v_salarxlWHERE emrlexee.id=100 Then second WHERE emploxee.id3101+ SELECT first_name, salary INTO v_firstname2, v_salary2 Then third + SELECTSELECTI tirst.name, salary INTO v_firstname3, v_salary3 iin WHERE emploxee id=102 ..... You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END.+ Then add another SELECT statement in BEGIN-END to find company average salary SELECT xa(salary) INTO aKasal FROM EMPLOYEES; !!! Do not forget to create y avgsal local variable in DECLARE section.arrow_forwardWrite an SQL statement to delete all rows of pets of type Anteater. What will happen if you forget to code the WHERE clause in this statement?arrow_forwardExecute the following statements using MYSQL: 1.Create a Trigger "trigger regno" for the salesman table (Before INSERT) set the value as O for the experience > 7 and evaluate it. Also write the syntax to drop the Trigger "trigger regno* 2. Insert a value for Customer table (#Last 3 digit of your register no, #Your name, Vellore, 55, 010). Insert a value for salesman table ("10", #Your name, 5, 4000). 3. List out the number of customers in each city by arranging them from low to high. ( 4. Select all the salesman who's work experience is between 4 and 8.arrow_forward
- Q1: Suppose you want to get all student names that start with letter ‘M’ and end on ‘D’. Write a regular expression to get this type of data from database table. SQlarrow_forwardFill the blanks with the suitable PL/SQL statements that correct each of the errors that appear in the given PL/SQL program. declare vAddress employee.Address%VR0WTYPE; begin select ename , address into vAddress from employee where salary = 1500; DBMS_OUTPUT.PUT_LINE('NOM =' || vEname || 'Adresse=' || vAddress ); exception when MANYROWS then dbms_output.put_line("This query returned many rows"); end;arrow_forwardThis is a database system question regarding SELECT: Which of the following statements is true for SELECT statements in general? a. HAVING is executed before WHERE when running an SQL query b. SELECT is executed before FROM when running an SQL query c. Each SELECT clause must have a WHERE clause as well. d. COUNT(column_name) function returns the number of values in the column, including any NULLs e. HAVING clause specifies a condition for selecting grouped tuples from the GROUP BY clause.arrow_forward
- 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…arrow_forwardYou 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_forward: Write SQL queries DDL Queries to implement the following Relational Model i.e. create the Nurse and Care_Center relations (including primary key and foreign key). Intelligently write data types. Show Output.arrow_forward
- 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 numbersarrow_forwardDevelop a PL/SQL block that would go through all the employees from EMPLOYEES table who work in department_id= 90 (there is suppose to be 3 employee who work in Department 90) IN BEGIN END END SECTION; Execute 3 separate of SELECT statement one after the other. Each SELECT will pull first_name , salary of each employee and store them in local variables. SELECT LOAD INTO v_firstname1, v_salary1 WHERE employee_id=100 Then second SELECT first_name, salary INTO v_firstname2, v_salary2 ….. WHERE employee_id=101 Then third SELECT, SELECT first_name, salary INTO v_firstname3, v_salary3 ….. WHERE employee_id=102 You must now have 6 local variables. DECLARE all of them accordingly in DECLARE section and use them in BEGIN and END. Then add another SELECT statement in BEGIN-END to find company average salary SELECT avg(salary) INTO v_avgsal FROM EMPLOYEES; !!! Do not forget to create v_avgsal local variable in DECLARE section.arrow_forwardoracle PL/SQL Create an anonymous block that prints all instructors First Name, Last name, and a phone. Hint: Use cursor and coursor FOR loop. desc instructor----------------------------------------- -------- ----------------------------INSTRUCTOR_ID NOT NULL NUMBER(8)SALUTATION VARCHAR2(5)FIRST_NAME VARCHAR2(25)LAST_NAME VARCHAR2(25)STREET_ADDRESS VARCHAR2(50)ZIP VARCHAR2(5)PHONE VARCHAR2(15)arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Programming with Microsoft Visual Basic 2017Computer ScienceISBN:9781337102124Author:Diane ZakPublisher:Cengage Learning
Programming with Microsoft Visual Basic 2017
Computer Science
ISBN:9781337102124
Author:Diane Zak
Publisher:Cengage Learning