Consider the following tables: Branch1 PropertyForRent1 branchNo bCity propertyNo pCity BO03 Glasgow PA14 Aberdeen BO04 Bristol PL94 London BO02 London PG4 Glasgow Create these two tables exactly as in the 1. figure above using SQL Developer or SQL Command Line 2. Provide Screenshots for the results obtained: 2.1 SELECT b.*, p.* FROM Branch1 b, PropertyForRent1 p WHERE b.bCity = p.pCity; 2.2 SELECT b.*, p.* FROM Branch1 b LEFT JOIN Implement the following Queries and PropertyForRent1 p ON b.bCity = p.pCity; 2.3 SELECT b.*, p.* FROM Branch1 b RIGHT JOIN PropertyForRent1 p ON b.bCity = %3D p.pCity; 2.4 SELECT b.*, p.* FROM Branch1 b FULL JOIN PropertyForRent1 p ON b.bCity = p.pCity;

Consider the following tables: Branch1 PropertyForRent1 branchNo bCity propertyNo pCity BO03 Glasgow PA14 Aberdeen BO04 Bristol PL94 London BO02 London PG4 Glasgow Create these two tables exactly as in the 1. figure above using SQL Developer or SQL Command Line 2. Provide Screenshots for the results obtained: 2.1 SELECT b., p. FROM Branch1 b, PropertyForRent1 p WHERE b.bCity = p.pCity; 2.2 SELECT b., p. FROM Branch1 b LEFT JOIN Implement the following Queries and PropertyForRent1 p ON b.bCity = p.pCity; 2.3 SELECT b., p. FROM Branch1 b RIGHT JOIN PropertyForRent1 p ON b.bCity = %3D p.pCity; 2.4 SELECT b., p. FROM Branch1 b FULL JOIN PropertyForRent1 p ON b.bCity = p.pCity;

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

Quèstion 12 Write SQL queries for the following: i. Insert all rows from Product table into Parts table by using subquery. ii. Find the average of the sales Amount column in Sales table where supplier ID is S212. i. select all the details of the suppliers from the Supplier table where Supplier.address starts with "Toy. TTT Arial 3 (12pt)
Write a SQL query that displays the number of customers who born on the 16th day of a month . Write in SQL a query that displays the ids of the customers who have the highest income . Create a view named ‘customerDetails’ to hold all the details of customers whose first names start with ‘S’ and their incomes are between 500 and 1000 Omani Rials . my SQL and orcale language
Instructions: Write the suitable SQL statement to answer the following questions based on the following tables ( image for better table) Table Name: Employee EMP_ID FNAME LNAME SALARY JOIN_DATE DEP_NO 101 John Abraham 10000 01-JAN-13 11 202 Michael Clarke 80000 01-JAN-13 22 303 Roy Thomas 70000 01-FEB-13 11 404 Tom Jose 60000 01-FEB-13 22 505 Jerry Pinto 65000 01-FEB-13 22 606 Philip Mathew 75000…
Please written by computer source I do not know which table to use here all the tables —— Pls use oracle Pl/sql command line —— The system must contain tables such as category(catNo ,catogeryName) ,Items(itemNo,ItemName,Price,total_quantity, catNo), Items_stor_entry(entry_no number primary key,itemNo,entry_date ,quantity), Employee (employeeNo,employeeName,job) ,branch(No,Name), Customer(customerNo,costomerName,gender) , ,Invoice (employeeNo,customerNo,total price ,invoiceNo,InvoiceDate,branchNo ) InvoiceDeatail contain List Of Purchase Items contain detail information related to the invoice (invoiceNo,ItemNo, paidPrice, quantity) . create getItemTotalPrice function which to return quantity*paidPrice . --- procedure to add new Category which use validation method checkExistingCategory using exception to validate category name if its not exists before, then add this category and generate the category number automatically using database trigger.
Write queries in SQL to answer each of the following questions: 1. Find all students in Comp. Sci. dept 2. Find all students with total credits > 100 3. Find all students who took course in Spring 2010 (Remove duplicates please) 4. Find all courses taken by the student whose ID is 76543 and also find his name create table student (ID varchar(5), name varchar(20) not null, dept_name varchar(20), tot_cred numeric(3,0), primary key (ID) ); create table takes (ID varchar(5), course_id varchar(8), sec_id varchar(8), semester varchar(6), year numeric(4,0), grade varchar(2), primary key (ID, course_id, sec_id, semester, year) ); insert into student values ('00128', 'Zhang', 'Comp. Sci.', '102'); insert into student values ('12345', 'Shankar', 'Comp. Sci.', '32'); insert into student values ('19991', 'Brandt', 'History', '80'); insert into student values ('23121', 'Chavez', 'Finance', '110'); insert into student values ('44553', 'Peltier', 'Physics', '56'); insert into student values…
Part 2: PL/SQL By using PL/SQL create the following: 1- A procedure Proc_Insert(arg2,arg3..argn): When the procedure is executed, the value of the passed arguments will be inserted into a table of your database.Note(you have to use one of the created Sequences to generate a value to be inserted into a field of your table). 2- A Procedure Update_value(arg1,arg2): The procedure searches about arg1 value in a specific column of your table and changes the value of the searched item to be equals arg2. 3- A procedure called del_Record_from_Table(arg1) that deletes a specific row from one of the tables you created. 4- A Function getAllData(arg): When Your call your function it should search about an item in your table and returns all data about it. 5- A row type trigger that's fires to accept the deleted rows from a table on your database and store them into another table. -You must create a new table to accept the deleted rows. - The new table must contain two additional columns, the first…
In SQL, write the appropriate statements to insert default values for these two tables, each table containing 5 inserts
Using DML SQL, write the appropriate SQL query for each of the following:a) Insert A new customer with the following information:(Name: Ali, SSN: 1111, Address: Riyadh, Phone: 05555)b) Delete all the loans for customer with SSN: 2222c) Select all customer who got loans more than 250000 SAR, print the customers SSN, named) Print all the Accounts in Bank: ALBILAD and in branch no: 5
Please use MySQL language and mySQL as server
Use the following table to find the OUTPUT of the following SQL queries: Table Name: Patients MEDICAL NO FIRST NAME SUR NAME GENDER PHONE DOB 12-Jun-2001 FAX 22114454 1001 Said Alalawi Male 98877445 1002 Othman Mualla 20-Apr-2000 Male 1003 Sameera Bader 19-Oct-2005 Female 25541122 1004 Fahad Alhinai 24-Feb-2004 91122544 Male Female 1005 Shamsa Alfahdi 15-Sep-2002 SELECT TO CHAR (DOB, 'DD/YY/MM') FROM patients WHERE Medical_no=1001; Answer: BLOOD TYPE A B O AB B WEIGHT 68 78 52 66 35 SMOKER NO YES NO YES NO PCR_TEST Negative Positive Positive Negative Negative
Consider the tables provided below and answer the following SQL questions: Table 1: Service SereicelD SereiceName Accounting. Security Maintenance Table 2: ServiceSetUp SereicelD SetupFee 2 3 4 100 300 350 Recurring 25 50 125 Tax 10% 11 9% Questions: Write insert statements to enter first two records into Table 1 as shown in above figure. Display a list that presents the data contained in Table 1 sorted by column 2 in descending order. Display the name of the service that has setup fee greater than $300. d. Display average of tax rates for all services.
I need to write a SELECT query in SQL using these instructions. Attached is the code that created the tables. SHOW name-of-tech part which are less than $300 and The Name of the Supplier. This will show which supplier has what parts under $300. FOR [Supplier] QUERY WILL USE: JOIN yes SUBQUERY no AGGREGATION no