Create the following tables Table 1 (CLIENT_MASTER) Table II (SALE_ORDER) 1. 2. 3. Client No C00001 C00002 C00003 C00004 C00005 C00006 4. 5. Order No 019001 019002 046865 019003 046866 019008 Write SQL commands for the following: Order Date 12-Jan-13 25-Jan-13 18-Feb-13 03-Apr-13 20-May-13 24-May-13 Name SMITHA JAIN VANDANA RAO PREM PUJARI BASU NATH RAVI SHANKAR ROOPA Data for Client_Master Client No C00001 C00002 C00003 C00001 C00004 C00005 City Mumbai Chennai Mumbai Mumbai Delhi Mumbai Data for Sale Order Salesman No 500001 S00002 S00003 S00001 S00002 S00004 Pincode 400054 780001 400057 400056 100001 400050 Dely_Date 20-Jan-13 27-Jan-13 20-Feb-13 07-Apr-13 07-Apr-13 26-May-13 Bal due 15000 0 5000 0 2000 0 Order_Status In process Cancelled Fulfilled Fulfilled Cancelled In process List all details from the client_master table for clients whose Bal_due = 0. Update table client_master, Change city of Client_no C00004 to Jaipur. Retrieve records of clients residing in Mumbai. Find the name and address of customer who has placed Order_no '019003' and 'O19002' respectively. List the client_no, name, city and pincode of clients whose Order_status is "In process".

Create the following tables Table 1 (CLIENT_MASTER) Table II (SALE_ORDER) 1. 2. 3. Client No C00001 C00002 C00003 C00004 C00005 C00006 4. 5. Order No 019001 019002 046865 019003 046866 019008 Write SQL commands for the following: Order Date 12-Jan-13 25-Jan-13 18-Feb-13 03-Apr-13 20-May-13 24-May-13 Name SMITHA JAIN VANDANA RAO PREM PUJARI BASU NATH RAVI SHANKAR ROOPA Data for Client_Master Client No C00001 C00002 C00003 C00001 C00004 C00005 City Mumbai Chennai Mumbai Mumbai Delhi Mumbai Data for Sale Order Salesman No 500001 S00002 S00003 S00001 S00002 S00004 Pincode 400054 780001 400057 400056 100001 400050 Dely_Date 20-Jan-13 27-Jan-13 20-Feb-13 07-Apr-13 07-Apr-13 26-May-13 Bal due 15000 0 5000 0 2000 0 Order_Status In process Cancelled Fulfilled Fulfilled Cancelled In process List all details from the client_master table for clients whose Bal_due = 0. Update table client_master, Change city of Client_no C00004 to Jaipur. Retrieve records of clients residing in Mumbai. Find the name and address of customer who has placed Order_no '019003' and 'O19002' respectively. List the client_no, name, city and pincode of clients whose Order_status is "In process".

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

5. Use XAMPP Control Panel (My SQL) to answer the following questions. Write SQL queries statement and also provide the output of each query to answer the following questions. (Screenshot the interface in MySQL that show SQL statement and output for each question). Table 1: PROPERTY pid 1 2 3 1200000 4 5000000 price 100000 3400000 owner Alia Bob Bob Marsha Table 2: MAINTENANCE mid company Name M1 Super Plumbing M2 Super Plumbing M3 South Carpeting srqFeet 560 2000 1200 800 empName George Dave Kim managed By Property Pete Park Property Property Pete Fancy Property location Lake View Serene Serene Lake View date 2020-12-12 type Sink 2020-11-11 Toilet 1 2021-01-01 Painting 4 Pid 1 d)' List property location, owner name and maintenance date for property managed by Property Pete. Sort the answer in descending order by property location.
sql code sql code sql code
- Create a trigger that will insert new emp_no, salary, from_date and to_date into salaries table after a new employee record is inserted. Assume the new employee salary is 10000 and from_date is current date and to_date is “9999-01-01” - List the employees’ first names and salaries where their salary is above the average salary among the employees
Express the following SQL code in Relational Algebra form.SELECT *FROM COURSEWHERE (COURSE.COLLEGE <> ’Business’OR COURSE.COLLEGE <> ’Engineering’)AND COURSE.CREDIT = ’U’;
My other instruction for SQL says: Create and test a stored procedure called checkin_transaction that processes a “checkin” transaction. When a book is checked in, the corresponding CHECKOUT record is updated to show the date it was checked in, and the Pat_ID attribute in the BOOK table is updated to NULL. The entire transaction (starting with START TRANSACTION; and ending with COMMIT;) should be in between the BEGIN and END statements of the stored procedure. You should be able to call the procedure with a statement like this, passing the values of the Book_Num, Pat_ID, and Check_In_Date to the procedure: CALL checkin_transaction(5243, 1170, ‘2017-04-30’) Do you guys know how?
C++ Nested loops: Print seats. Given numRows and numColumns, print a list of all seats in a theater. Rows are numbered, columns lettered, as in 1A or 3E. Print a space after each seat, including after the last. Ex: numRows = 2 and numColumns = 3 prints:1A 1B 1C 2A 2B 2C #include <iostream>using namespace std; int main() { int numRows; int numColumns; int currentRow; int currentColumn; char currentColumnLetter; cin >> numRows; cin >> numColumns; /* Your solution goes here */ cout << endl; return 0;}
Write a PL/SQL block that will allow the user to enter FNo and that will display Customer Name from Booking table. Include predefined exception with suitable messages1- SQL returns more than one records2- Records are not available
Write the SQL10. 1/ Drop the STORE table 2/ Drop the PURCHVW view
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 1001 JAMAL 35 1002 TAN 52 PNAME AGE ADATE 1003 MARIAM 30 1004 JOE 27 1005 SOFEA 19 GENDER 2000-10-28 M 2000-11-20 M 2000-07-16 F 2000-12-18 M 2000-04-25 F 2. Find the name of patient who admits on the same date as Sofea.
5. Use XAMPP Control Panel (My SQL) to answer the following questions. Write SQL queries statement and also provide the output of each query to answer the following questions. (Screenshot the interface in MySQL that show SQL statement and output for each question). Table 1: PROPERTY pid 1 2 3 4 price 100000 3400000 1200000 5000000 owner Alia Bob Bob Marsha Table 2: MAINTENANCE mid company Name M1 Super Plumbing M2 Super Plumbing M3 South Carpeting Kim srqFeet 560 2000 1200 800 empName George Dave I managed By Property Pete Park Property Property Pete Fancy Property location Lake View Serene Serene Lake View date Pid 2020-12-12 1 2020-11-11 1 2021-01-01 Painting 4 type Sink Toilet a) Create the above two table. Use any suitable data type and assign a primary key and foreign key.
LAB 2: SUBTASK 1: Fill in the following tables: as preliminary lab work (some are filled for your guidance) SUBTASK 2: Build the tables in Oracle Live SQL with your account according to the tables above. SUBTASK 3: Build the relations among the tables. Addresses Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry address_id V NO 1234567890 Customers Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry customer id V number NO Good_groups Column Name Primary Key Foreign Key Data Type Nullable Default Sample Entry good_group_id V number varchar2(10) NO
. Write a T-SQL correlated subquery selecting the store code, store name, store ytd sales from the store table where the store code matches the selection result of the max store code from the store table where the store code matches. /* Created with SQL Script Builder v.1.5 */ /* Type of SQL : SQL Server */ CREATE TABLE EMPLOYEE ( EMP_CODE int, EMP_TITLE varchar(4), EMP_LNAME varchar(15), EMP_FNAME varchar(15), EMP_INITIAL varchar(1), EMP_DOB datetime, JOB_CODE varchar(5), STORE_CODE int ); INSERT INTO EMPLOYEE VALUES('1','Mr.','Williamson','John','W','5/21/1964','SEC','3'); INSERT INTO EMPLOYEE VALUES('2','Ms.','Ratula','Nancy','','2/9/1969','MGR','2'); INSERT INTO EMPLOYEE VALUES('3','Ms.','Greenboro','Lottie','R','10/2/1961','GEN','4'); INSERT INTO EMPLOYEE VALUES('4','Mrs.','Rumpersfro','Jennie','S','6/1/1971','GEN','5'); INSERT INTO EMPLOYEE VALUES('5','Mr.','Smith','Robert','L','11/23/1959','GEN','3'); INSERT INTO EMPLOYEE…