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

Write Mysql code for: The database has three tables for tracking horse-riding lessons: Horse with columns: ID - primary key RegisteredName Breed Height BirthDate Student with columns: ID - primary key FirstName LastName Street City State Zip Phone EmailAddress LessonSchedule with columns: HorseID - partial primary key, foreign key references Horse(ID) StudentID - foreign key references Student(ID) LessonDateTime - partial primary key Write a SELECT statement to create a lesson schedule for Feb 1, 2020 with the lesson date/time, student's first and last names, and the horse's registered name. Order the results in ascending order by lesson date/time, then by the horse's registered name. Make sure unassigned lesson times (student ID is NULL) appear in the results. Hint: Perform a join on the LessonSchedule, Student, and Horse tables, matching the student IDs and horse IDs.
Create a Pl SQL package named EMP_PKG which will have the above three functions and procedures as follows: CALC_TAX - private CHECK_FNAME - Public AVG_SAL - Public
Assistance with SQL statements Previous code; CREATE TABLE Lab4program_piershed ( code VARCHAR(5) PRIMARY KEY, name VARCHAR(20), tel VARCHAR(20));CREATE TABLE Lab4course_xxxx ( cid INT PRIMARY KEY, name VARCHAR(20), credits INT, mycode VARCHAR(5), FOREIGN KEY (mycode) REFERENCES Lab4program_xxxx(code)); 1. Insert 3 records into your Lab4program_xxxx table. The code should be "CPS", "TECH", "MATH", or "BIO". Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 3 records to your table. 2. Insert 4 records into your Lab4course_xxxx table with at least 2 different mycode. Please copy/paste your SQL statements with the output message in the text that shows you successfully insert 4 records to your table.
Views in SQL are kind of virtual tables. A view also has rows and columns as they are in a real table in the database. We can create a view by selecting fields from one or more tables present in the database. A View can either have all the rows of a table or specific rows based on certain conditions. Under what circumstances would you create a View?
PL/SQL Help I need to create a PL/SQL trigger called aprove_rental that will prevent an INSERT if a clients rating (client_credit_rtg) is less than 1.5 from the rental table. Im using sqlplus to test this trigger. Tables : create table client (client_num char(4), client_lname varchar2(15) not null, client_fname varchar2(15), client_phone char(8), client_credit_rtg decimal(2,1) check(client_credit_rtg between 0.0 and 5.0), client_fave_cat char(3), primary key (client_num), foreign key (client_fave_cat) references movie_category(category_code) ); create table rental (rental_num char(7), client_num char(4), vid_id char(6), date_out date not null, date_due date not null, date_returned date, primary key (rental_num), foreign key (client_num) references client, foreign key (vid_id) references video ); PLEASE WRITE THIS FROM SCRATCH AND NOT JUST COPY AND PASTE FROM ANOTHER ANSWER, BECAUSE THEY DONT WORK FOR ME
Using the WideWorldDistributors database and the Sales schema create a function that takes InvoiceID as an input parameter and returns all the rows from the table InvoiceLines for the InvoiceID value passed into the function. If the result is a NULL return a zero
Q2/ write SQL commands to create tables of a Bank database, where these tables will have the following schemas: branch(branch_name, branch_city, assets) customer(customer name, customer_street, customer_city) loan(loan_number, branch_name, amount)
The database contains a Horse table, with columns: ID integer, primary key Registered Name variable-length string. The database contains a Student table, with columns: • ID integer, primary key First Name - variable-length string LastName variable-length string Write a SQL Query to create a Schedule table, with columns: HorseID - integer with range 0 to 65535, not NULL • Student ID integer with range 0 to 65535 Lesson DateTime - date/time, not NULL (HorseID, Lesson DateTime) is the primary key Also, create the following foreign key constraints on Schedule columns: HorseID references Horse. When an ID is deleted from Horse matching Lesson Schedule rows are deleted. Student ID references Student. When an ID is deleted from Student, matching Student ID 's are set to NULL).
write SQL queries to create procedures for a database called Saleco. The database contains the following tables: customer, invoice, line, product, and vendor. A procedure called get_customer_invoices that takes a customer ID as input and returns a list of all invoices for that customer, along with the total amount due for each invoice. A procedure called get_vendor_products that takes a vendor ID as input and returns a list of all products sold by that vendor, along with the number of units sold and the total revenue generated for each product. A procedure called get_invoice_details that takes an invoice ID as input and returns a list of all products purchased on that invoice, along with the quantity purchased, the unit price, and the total price for each product.
Q2/ write SQL commands to create tables of a Bank database, where these tables will have the following schemas: branch(branch_ name, branch_city, assets) customer(customer_name, customer_street, customer_city) loan(loan_number, branch_name, amount)
4. The following table resulted from the query SELECT * FROM DBA_FREE_SPACE. TABLE SPACE_ FILE_ID NAME SYSTEM 1 SYSTEM 1 2 DATA DATA DATA INDEX N 3 A WO 3 4 BLOCK_ID BYTES BLOCKS RELATIVE_FNO 100 250 600 150 350 15 614400 921600 307200 614400 61440 307200 100 150 50 2 112334 100 10 50 Write the SQL statement that will defragment the free space in the DATA tablespace.
Q2: A-Given the following tables: Student Subject Std_ID 001 002 003 004 Fname Smith Smith Beal Thomson Lname Jolin Susan Fred Marie Std_ID 001 001 002 002 003 Semester 004 Falls03 Spro4 Falls03 C_ID Eng01 Ger01 Eng01 Ger01 Ger01 CSection Spro4 Spro4 Spro4 1. For each table in the database, identify the primary key and the foreign key(s). 2. Do the tables exhibit entity integrity? Explain your answer? 3. Do the tables exhibit referential integrity? Explain your answer? Ita01 ZZZZZZ IN 2N IN 2N IN CName English IN German English German German Italian Grade A B A B A B