Consider an Animal table with the following columns: • ID - integer, auto increment, primary key • Name - variable-length string Breed variable-length string, must be one of the following: - Holsteiner, Paint, Saddlebred • Height - decimal number, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be > Jan 1, 2010 Write the SQL Query to make the following updates: 1. Change the name to Luck and birth date to May 1, 2015 for animal with ID 2. 2. Change every breed to NULL for animal born on or after December 20, 2015. 3. Delete all rows for animals born before March 13, 2013.

Consider an Animal table with the following columns: • ID - integer, auto increment, primary key • Name - variable-length string Breed variable-length string, must be one of the following: - Holsteiner, Paint, Saddlebred • Height - decimal number, must be ≥ 10.0 and ≤ 20.0 • BirthDate - date, must be > Jan 1, 2010 Write the SQL Query to make the following updates: 1. Change the name to Luck and birth date to May 1, 2015 for animal with ID 2. 2. Change every breed to NULL for animal born on or after December 20, 2015. 3. Delete all rows for animals born before March 13, 2013.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Related questions

Q: select * from cast where cast_id=162652763; Use explain to display the query plan without creating…

A: the answer is given below

Q: in pl/sql ,use Cursor to get all the records from table job_history for employee_id 121

A: pl/sql code for the above question is solved in step 2:- assume table job_history has columns…

Q: Please write a query for dvdrental database. Please list all the customers. For each customer…

A: According to the information given: We have to write a query for dvdrental database on the basis of…

Q: Given the table customers which contains columns customer_id, first_name, last_name, and state, and…

A: SELECT C.LASTNAME, A.STATE, A.ZIP FROM CUSTOMER AS C INNER JOIN ADDRESS AS A on…

Q: Write the T-SQL scripts for the following tasks: Write a query to select the employees whose…

A: Please refer to the following step for the complete solution of the problem above.

Q: Write a query which set the following constraints in Customers table (in MySQL). First Name and…

A: We are going to add constraints to the columns in the table Customers. First we will add constraint…

Q: In Sql Oracle Apex application, Using GROUPING SETS, write a query to show the following groupings:…

A: First query performs a grouping on two columns Department_Id and Job_Id Group By X, Y means put all…

Q: In SQL, write the appropriate statements to insert default values for these three tables, each table…

A: Prescription table: INSERT INTO prescription (pre_no,pre_date,pre_amount)VALUES (10,12,1200); INSERT…

Q: Alter - Add Referential Integrity Constraint You have to only use Alter table SQL statement Identify…

A: According to the given problem statement we are required to add the referential integrity using…

Q: write sample sql quiries for these Write a query to display employee number, first name, job id…

A: Please refer below for your reference: Queries are: 1. SELECT employee number, first name, job id…

Q: 1. Write a query to create the "Student" table (SID, Sname, SAge, SDept, SCity), where the Student…

A: SQL is used to access the rows from the relational database. As we know that relation is made up of…

Q: Write a query that Balance of each CUSTOMER who have made purchase(s) before AND subtotal that each…

A: Sql which means structured query languages and it is a domain-specific language used in programming…

Q: SQL queries

A: According to the question, we need to write the SQL queries of the following questions: Write a…

Q: Q3: How many unique titles do we have in the employee table? Hint: You need to create TWO queries,…

A: 1) SELECT DISTINCT titles FROM EMPLOYEE

Q: 1d. Modify the Doctors table by applying the following constraints: Column Name Constraint Salary…

A: Initially, Doctors table is created using the following syntax. CREATE TABLE table_name( column1…

Q: Create the following table in your database with the following schema: Table: Products I Column Name…

A: Create table syntax : CREATE TABLE TABLE_NAME( column_name data_type, column_name data_type,…

Q: Create table sales ( cust varchar(20), prod varchar(20), day integer, month integer, year integer,…

A: Answer

Q: Write a query to display all vendors sorted by vendor name. Write a query to display the product…

A: SQL queries are a set of instructions given to the database to retrieve specific data. SQL was…

Q: Write all the sql code (including create, insert and select)

A: in the following section we will be writing the queries based on information provided in the above…

Q: The given SQL creates a Movie table and inserts some movies. The SELECT statement selects all…

A: Answer

Q: Create the following tables in your database with the following schema: Table: Countries | Column…

A: We need to write code of create table and insert table only.

Q: Q11. Write an SQL query to do the following: a. Create table customer_info with the given details.…

A: Using CREATE statement we can create table in SQL. Syntax: CREATE TABLE Table_Name(Column1_Name…

Concept explainers

SQL Query

Structured Query Language is the full form of SQL. It is one of the standard languages to deal with the relational database. It is used to insert, update, delete, and search the records stored in a RDBMS. The relational databases are created and managed by using SQL.

Question

100%

Consider an Animal table with the following columns:
• ID - integer, auto increment, primary key
•
Name variable-length string
• Breed - variable-length string, must be one of the following:
•
Holsteiner, Paint, Saddlebred
Height decimal number, must be ≥ 10.0 and ≤ 20.0
-
• Birth Date - date, must be > Jan 1, 2010
Write the SQL Query to make the following updates:
1. Change the name to Luck and birth date to May 1, 2015 for animal
with ID 2.
2. Change every breed to NULL for animal born on or after December 20,
2015.
3. Delete all rows for animals born before March 13, 2013.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Describe Concept

VIEW

Step 2: Writing SQL queries to make specified updates

VIEW

Solution

VIEW

Step by step

Solved in 3 steps

SEE SOLUTION Check out a sample Q&A here

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

SQL ( ORACLE SQL DEVELOPER ) : THIS IS FIRST , SECOND AND THIRD TABLE for the Task 1 to solve : create table author_45( auth_name char(50), gender char(1), age number(3), nationality char(50), PRIMARY KEY (auth_name) ); create table book_45( isbn number(10), title char(50), ver_no number(2), publisher char(50), PRIMARY KEY (isbn) ); create table writtenBy_45( isbn number(10), auth_name char(50), yr_published number(4), price number(3), no_copy number(4), PRIMARY KEY (isbn,auth_name), foreign key (isbn) references book_45, foreign key (auth_name) references author_45 ); insert into author_45 values ('Benoit','F',42,'French'); insert into author_ 45 values ('Antonini','M',33,'Italian'); insert into author_ 45 values ('McAven','F',31,'Australian'); insert into author_ 45 values ('Williams','M',90,'British'); insert into book_45 values (101,'atabases',1,'Possum'); insert into book_45 values (202,'SQL Primer',2,'Hall'); insert into book_45 values…
This is a Database based question.
Write a query in SQL code for: "List the book categories and the average book price of each category." Tablename is "BOOKS" and column names are: ISBN TITLE PUBDATE PUBID COST RETAIL DISCOUNT CATEGORY
Consider the following tables EMP | EMPNO (PK) 10 11 12 13 14 DEPT DEPTNO(PK) 10 20 ENAME 30 40 DEPTNO( FK) 10 Ahmad Jamal Ali AlMansoori 20 Sarah Sulaiman 30 Omar Ameen 20 Maha Al Ali 40 DNAME Accounting Research LOC Abu Dhabi Abu Dhabi Marketing Dubai Operations Abu Dhabi Write a query that will display the employee number and name for all employees who work in a department with any employee whose name contains a letter 'A'.
Write SQL CODE List the Professor's First (EMP_FNAME) and Last names (EMP_LNAME) of those who teach more than 2 classes (CLASS table). Use Noncorrelated Subquery with INNER JOIN.
Q4
Write an SQL query using a Wildcard operator that will show any ISBNstarting with 995 in the Books table. This query must also show the ISBNand the book title only.
HW2: Basic SQL 1. Write a query that will show all probation officers 2. Write a query that will show the first and last names of probation officers 3. Now write a query that shows first and last name of probation officers. Include the field prob_id but rename prob_id to probation officer ID. 4. Write a query that will show crime id, and the total charges for each crime ID. Include an alias for the total charges column called Total Charges. 5. Write a query that will concat the last and first names of criminals into one column. Add a space and comma between the last and first name of criminals. Give the column the alias Criminal Name. 6. List the last name and first name of all authors in only 1 column. Add a comma to separate the two names. 7. Run a query that will return the order#, item#, isbn, quantity, paideach. Include in the query a arithmetic operation that will total quantity and paideach. Alias the virtual column so it is labeled Item Total
You have a table named student having attributes student_name, id, batch, contact. Write a SQL query to display the names of all students in alphabetically increasing order.
Task Write a query to retrieve the records of students who have their total marks greater than or equal to 500 Total marks refer to the sum of the marks of a single student. The result should be in the following format • STUDENT ID • SUM OF MARKS The result should be sorted in descending order by STUDENT D Table description Table: marks Name STUDENT_ID Type Description INTEGER This is the student's unique ID These are the marks obtained STUDENT MARKS INTEGER