19. The following code refers to the sample data in the table people. What is the result of each selectstatement?* FROM people WHERE spouse id IS NULL WITH CHECK OPTION;CREATE VIEW new people AS SELECT(a) SELECT COUNT (*) FROM people;(b) SELECT COUNT(*) FROM new_ people;INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown');(c) SELECT COUNT(*) FROM people;(d) SELECT COUNT (*) FROM new people;INSERT INTO new_people (firstname, lastname, spouse_id) VALUES ('Clara', 'Clayton', 6) ;(e) SELECT COUNT(*) FROM people;(f) SELECT COUNT (*) FROM new_people; For the remaining questions, use the following table of people:people (id (pk), firstname, lastname, spouse_id (fk))The table was created as:CREATE TABLE people (id INT NOT NULL AUTO INCREMENT PRIMARY KEY,firstname VARCHAR(30), lastname VARCHAR (30), spouse id INT,CONSTRAINT spouse fk FOREIGN KEY (spouse id) REFERENCES people (id));This is some sample data:Participation Activity 9+----| id | firstname | lastname | spouse_id |+1 | Marty2 | Jennifer| McFly| Parker| McFly| Tannen| McFly||3 | Lorraine4 | Biff5 | GeorgeNULL |NULL |5 |NULL |3 |+----+--

Note: - As per the guidelines we can only answer one specific question at a time. Please resubmit…

19. The following code refers to the sample data in the table people. What is the result of each select statement? FROM people WHERE spouse_id IS NULL WITH CHECK OPTION; CREATE VIEW new people AS SELECT * (a) SELECT COUNT(*) FROM people; (b) SELECT COUNT(*) FROM new_people; INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown'); (c) SELECT COUNT(*) FROM people; (d) SELECT COUNT(*) FROM new_people; INSERT INT0 new_people (firstnameę, lastname, spouse_id) VALUES ('Cclara', 'Clayton', 6); (e) SELECT COUNT(*) FROM people; (f) SELECT COUNT(*) FROM new_people;

19. The following code refers to the sample data in the table people. What is the result of each select statement? FROM people WHERE spouse_id IS NULL WITH CHECK OPTION; CREATE VIEW new people AS SELECT * (a) SELECT COUNT() FROM people; (b) SELECT COUNT() FROM new_people; INSERT INTO new_people (firstname, lastname) VALUES ('Einstein', 'Brown'); (c) SELECT COUNT() FROM people; (d) SELECT COUNT() FROM new_people; INSERT INT0 new_people (firstnameę, lastname, spouse_id) VALUES ('Cclara', 'Clayton', 6); (e) SELECT COUNT() FROM people; (f) SELECT COUNT() FROM new_people;

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

Similar questions

Write a SELECT statement that returns all rows with salary, last name, street address and ZIP code (SALARY, LAST_NAME, STREET, ZIP_CODE) from the EMPLOYEE and ADDRESS tables, sorted by SALARY from largest to smallest. STREET and ZIP_CODE are in the ADDRESS table, while the other fields are in the EMPLOYEE table. The common key is EMPLOYEE_ID.
T-SQL procedure for MICROSOFT SQL SERVER A: obtain the name and credit limit of the customer whose number currently is stored in I_CUSTOMER_NUM. Place these values in the variables I_CUSTOMER_NAME and I_CREDIT_LIMIT, respectively. Output the content of I_CUSTOMER_NAME and I_CREDIT_LIMIT. HINT use cursor instructions as a template for the problem. Instructions goes as follows CREATE PROCEDURE usp_DISP_REP_CUST @repnum char(2) AS DECLARE@custnum char(3) DECLARE@custname char(35) DECLARE mycursor CURSOR READ_ONLY FOR SELECT CUSTOMER_NUM, CUSTOMER_NAME FROM CUSTOMER WHERE REP_NUM = @repnum OPEN mycursor FETCH NEXT FROM mycursor INTO @custnum, @custname WHILE @@FETCH_STATUS=0 BEGIN PRINT@custnum+' '+@custname FETCH NEXT FROM mycursor INTO @custnum, @custname END CLOSE mycursor DEALLOCATE mycursor
INFO 2303 Database Programming Assignment : PL/SQL Practice Note: PL/SQL can be executed in SQL*Plus or SQL Developer or Oracle Live SQL. Question: Write an anonymous PL/SQL block that will delete all patients for doctors that works in the Family Practice Verify that patients have been deleted accordingly. Then do a select * from patients where doc_id = (select doc_id from doctor where area = ‘Family Practice’. You should get no rows. Patietn table: CREATE TABLE PATIENT(PT_ID NUMBER(3),PT_LNAME VARCHAR2(15),PT_FNAME VARCHAR2(15),PTDOB DATE,DOC_ID NUMBER(3),NEXTAPPTDATE DATE,LASTAPPTDATE DATE,CONSTRAINT PATIENT_PT_ID_PK PRIMARY KEY (PT_ID),CONSTRAINT PATIENT_DOC_ID_FK FOREIGN KEY(DOC_ID)REFERENCES DOCTOR); INSERT INTO patient VALUES(168, 'James', 'Paul', TO_DATE('14-MAR-97'), 432, TO_DATE('01-JUL-03'), TO_DATE('01-JUN-03'));INSERT INTO patient VALUES(331, 'Anderson', 'Brian', TO_DATE('06-MAR-48'), 235,TO_DATE('01-JUL-03'), TO_DATE('01-JUN-03'));INSERT INTO patient…
SQL CODE FOR For the players who show up in Batting, Bowling, and Fielding tables, create a list that shows their names, runs they have scored, wickets they have taken, and catches they have taken? table is in picture (bowling table is same as batting and fielding )
Write a ASQ statement to return to see all of the first names in the People table. SELECT first name FROM people; WHERE FROM People first name; FROM People SELECT first_name; First name WHERE FROM People;
Create a stored procedure that will return the number of customers in a given state. The parameter for your stored procedure should accept the state abbreviation ('UT') and return the results of a query that returns the number of customers in that state.
WEEK 3 ASSIGNMENT Complete the following exercise: Using the student table you created in week two insert four rows into your table. Update the first name to “Luke” and last name to “Plew” for one of the rows you inserted above. Delete the row you updated above. Explain how you insert data in one table from another table. Your answer should be a minimum of three sentences in length.
Employee(empno, ename, street, city, mgrssn) work_project(eno, pno, number_of_hours) Write a query and optimize it to find employee name and project number in which they work and who live in "New_york". Identify the type of indexing to be applied on 'empno' in Employee Table.
NVL to replace null value.
Q2: Design Database for the following scenario and Write SQL queries. Create an ERD for the following scenario. Suppose there is a grocery store near your house. Following can be considered for ERD: A grocery store may have more than one employee. A grocery store has exactly one manager. The manager has one or more sales men working under him. Grocery store has more than one portion for the products. • Each product has a barcode, name, expired date. Many customers can busy many products, but each product is bought by only one customer. Each customer will get an invoice for his /her purchase. The bill invoice has an id.
Refer to the film and inventory tables of the Sakila database. The tables in this lab have the same columns and data types but fewer rows. Write a query that lists the titles of films with the fewest rows in the inventory table. This query requires a subquery that computes the minimum of counts by film_id: SELECT MIN(count_film_id) FROM ( SELECT COUNT(film_id) AS count_film_id FROM inventory GROUP BY film_id ) AS temp_table; This subquery is provided in the template.
Third normal form says: a. No nonkey columns depend on another nonkey column. b. Every column that's not part of the primary key is fully dependent on the primary key. c. Eliminate repeated fields. d. None of the above.