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 Systems: Design, Implementation, & Management

12th Edition

ISBN:9781305627482

Author:Carlos Coronel, Steven Morris

Publisher:Carlos Coronel, Steven Morris

Chapter3: The Relational Database Model

Section: Chapter Questions

Problem 14P: Do the tables exhibit referential integrity? Answer yes or no, and then explain your answer. Write...

See similar textbooks

Similar questions

Consider the following tables. Primary keys are identified after each table. Hotel(Hnum,HName,Location) PK = HNum Room(RNum,HNum,Type,View,Price) PK = RNUM , HNum Booking(id,HNum,GNum,RNum,DateFrom,DateTo) PK = id Guest(GNum,Fname,Lname,Gender,DOB,City) PK = GNum Write SQL queries AND Relational algebra expressions (using the relational algebra operators: ρ, σ, π, , υ, ∩, sum, avg, count) for each of the following queries a) List all information about the rooms that have a price below the average price of all single rooms b) For each Hotel, List the total number of rooms c) List the names of hotels that have no booking in them d) List the first name and last name of Parisian guests who book a double room in Paris PLEASE ANSWER THE QUESTION BY WRITING SQL QUERIES AND RELATIONAL ALGEBRA EXPRESSION. Thank you.
Consider the following schema and write SQL query for given statements. Student ( regNo, sName, sCity, sCGPA, sAge)Course ( cCode, cName, credit_hours)Enrollment (regNo, cCode, semester,quality_points,Grade) 1- Display 2nd row of Student table using Cursors. 2- Display all records of Enrollment table which are placed at even rows. 3- Execute given query in SQL and do as directed.a) UPDATE STUDENT SET ECITY = ‘ISB’ WHERE EID>101b) Count how many records have been updated in above query using cursor. 4- Write a mechanism which must not allow user to delete more than 1 records using cursor and transaction.
SQL: Start with the Employee table used in Lab 4. CREATE TABLE Employee ( EMPLOYEE_ID INT NOT NULL, FIRST_NAME CHAR(20), LAST_NAME CHAR(20), JOB_LEVEL INT, SALARY BIGINT, COMMISSION_PCT INT, CONSTRAINT PKEmployeeID PRIMARY KEY (EMPLOYEE_ID) ); INSERT INTO Employee VALUES (100,'Steven','King',1,50000,10), (101,'Neena','Kochhar',1,50000,10), (102,'Lex','De Haan',2,60000 ,15), (103,'Alexander','Hunold',2,60000,15), (104,'Bruce','Ernst',3,70000,25), (105,'Johann','Ernst',4,75000,30); Create another table. CREATE TABLE NumEmployeesByLastName ( LastName CHAR(20), NumEmployees INT ); a. Write a query to initialize the NumEmployeesByLastName table by inserting one row for each last name already in the Employee table, and having the accurate count of the number of employees having that last name. Assume that there are no null values in the Employee table. After your query, if you execute the following query, you would…
Write a simple PL/SQL function which has the following definition. Refer to the "EMP" below for appropriate column names CREATE TABLE emp ( empno number(4) CONSTRAINT pk_emp PRIMARY KEY, ename varchar2(10) NOT NULL, job varchar2(10), mgr number(4) referneces emp ON DELETE CASCADE, hiredate date, sal number(6), comm number(6), deptno number(3), CONSTRAINT fk_emp_deptno FOREIGN KEY (deptno) REFERENCE dept ON DELETE CASCADE) ------------------------------------------------------------------- Function name: Count_Emp Purpose: To count the number of managers from the EMP table Input parameter: employee job type ( is the employee an emp or mgr) Output parameter: None Input/Output parameters: None Return Value: an integer value representing the total number of managers. Precondition: None Postcondition: the employee table is unchanged. The output of the function is the number of managers in the emp table Use % TYPE where possible.
Write an SQL query for the following questions: List the name of doctors with the number of written prescriptions. List the customers and the number of prescriptions each has. create table Addresses(address_id varchar2(10) not null constraint addresses_pk primary key,city varchar2(20) not null,state varchar2(20) not null,country varchar2(20) not null,note varchar2(50)); create table Doctors(doctor_id varchar2(10) not null constraint doctor_pk primary key,address_id varchar2(10) not null,first_name varchar2(20) not null,last_name varchar2(20) not null,phone varchar2(20),email varchar2(20),note varchar2(50),constraint doctor_fk foreign key (address_id) references Addresses(address_id)); create table Customers(customer_id varchar2(10) not null constraint customer_id primary key,address_id varchar2(10) not null,first_name varchar2(20) not null,last_name varchar2(20) not null,phone varchar2(10),note varchar2(50),constraint customer_fk foreign key (address_id) references…
ou 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. 1 2 3 4 5 SELECT * FROM customer WHERE ВыполнитьСбросить What country appears in row 1 of your query result? 1 балл Ireland France Chile India
2) Write SQL query that returns the Name of ALL employees (based on EMP_LNAME and EMP_FNAME in EMPLOYEE table, call this EMP_NAME), Gender of ALL employees (based on EMP_TITLE in EMPLOYEE table, call this EMP_NAME), and Pilot ratings if any (PIL_RATINGS in PILOT table). Output: EMP_NAME EMP_GENDER Rhett VanDam M John Lange M Jeanine Duzak F
How would I programmatically loop through employees ( a SQL Table) and display each name as <li> element and sort them by LastName? Example: foreach ($employees as $emp) { echo '<li class="mdl-list__item">'; echo $emp['FirstName']; echo '</li>'; }
Let's assume that the following indices are now set on the schema from the previous task: - Level 2 B+ index on the attribute Vehicle.year - Hash index on the attribute Rental.date Our DBMS has the following algorithms to perform the join: - Block nested loops join - Index nested loops join Translate the following SQL query into relational algebra and find the plan that reads the fewest pages or blocks: SELECT Vehicle.brand, Vehicle.model FROM Vehicle JOIN Rental ON (Vehicle.vid = Rental.vid) WHERE Vehicle.year = 2015 AND Rental.date > ’31.12.2022’
7. Write an SQL query to update a view named VP having columns (X,Y,Z) to have columns (X,Y,Z,W) from the table T.
Write an SQL query to fetch the employees whose name begins with any two characters, followed by a text “hn” and ending with any sequence of characters. Write an SQL query to fetch all the EmpIds which are present in either of the tables – ‘EmployeeDetails’ and ‘EmployeeSalary’.
Hello, I need to create a Horse table in SQL using the following columns, data types, and constraints. ID - integer with range 0 to 65 thousand, auto increment, primary key RegisteredName - variable-length string with max 15 chars, not NULL Breed - variable-length string with max 20 chars, must be one of the following: Egyptian Arab, Holsteiner, Quarter Horse, Paint, Saddlebred Height - number with 3 significant digits and 1 decimal place, must be ≥ 10.0 and ≤ 20.0 BirthDate - date, must be ≥ Jan 1, 2015

SEE MORE QUESTIONS

Recommended textbooks for you

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

Database Systems: Design, Implementation, & Manag…

Computer Science

ISBN:

9781305627482

Author:

Carlos Coronel, Steven Morris

Publisher:

Cengage Learning

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

SEE MORE TEXTBOOKS