ItemsSalesID_NamePriceSupplierSIDS DateCIDKetchup12012-5-231.50Block Factory2012-5-242UniqueManufacturerS&S2Salt4042016-4-2332016-2-124Soap3062016-1-10International4Toothpaste33BrothersEnterpriseGeneral5Sugar20BillTraders6.Detergent34AlibabaSIDIDExpress213Customer4CIDName21CityLahorePeshawar24AqibSuleman22SahiwalPeshawar2NadeemSarim44SohailPeshawar436NadirOkara4244PeshawarLahoreNasirKamalU sing the Schem a - data/statistics Can follow ing queries be executed on above relationsor not.lf not then justify with reason.1) (Select ID, I_Name from item s where I_Name like '% a % ') Unio n (Select Nam e,CID fromCustomer)2)(Select * fro m items where P rice > 20) In tersect (Select * from Customer)3)Select * from Customer inner jo in Sales wh ere City='Lahore' and Custom er.CID=Sales.CID4) Select distin ct Name, City from Custom er5) In sert into Sales values (3,'2016-2-12',4)

1. (Select ID,I_name from items where I_name like '%a%' ) union (Select name, CID from Customer)This…

Items Sales ID Name Price Supplier SID SDate CID Ketchup 50 Block Factory 2012-5-23 2012-5-24 2 Salt 40 Unique Manufacturer S&S International 4 2016-4-23 2016-2-12 4 Soap 30 6. 2016-1-10 1 4 Toothpaste 33 Brothers Enterprise General Traders Sugar 20 Bill 6. Detergent 34 Alibaba SID ID Express 1 2 1 Customer 4 CID Name 2 City Lahore 1. 4 Aqib Suleman Peshawar 3 3. Nadeem Sahiwal 5 4. Sarim Peshawar 4 5. Sohail Peshawar Okara Peshawar Lahore 6. Nadir 2 Nasir 4 4 Kamal U sing the Schem a - data/statistics Can follow ing queries be executed on above relations or not.lf not then justify with reason. 1) (Select ID, I_N ame from item s where _Name like '% a % ') Union (Select Nam e,CID from Customer) 2)(Select * fro m items where Price > 20) In tersect (Select * from Customer) 3)Select * from Customer inner jo in Sales where City='Lahore' and Custom er.CID=Sales.CID 4) Select distinct Name, City from Custom er 5) In sert into Sales values (3,'2016-2-12',4) 222344

Items Sales ID Name Price Supplier SID SDate CID Ketchup 50 Block Factory 2012-5-23 2012-5-24 2 Salt 40 Unique Manufacturer S&S International 4 2016-4-23 2016-2-12 4 Soap 30 6. 2016-1-10 1 4 Toothpaste 33 Brothers Enterprise General Traders Sugar 20 Bill 6. Detergent 34 Alibaba SID ID Express 1 2 1 Customer 4 CID Name 2 City Lahore 1. 4 Aqib Suleman Peshawar 3 3. Nadeem Sahiwal 5 4. Sarim Peshawar 4 5. Sohail Peshawar Okara Peshawar Lahore 6. Nadir 2 Nasir 4 4 Kamal U sing the Schem a - data/statistics Can follow ing queries be executed on above relations or not.lf not then justify with reason. 1) (Select ID, I_N ame from item s where _Name like '% a % ') Union (Select Nam e,CID from Customer) 2)(Select * fro m items where Price > 20) In tersect (Select * from Customer) 3)Select * from Customer inner jo in Sales where City='Lahore' and Custom er.CID=Sales.CID 4) Select distinct Name, City from Custom er 5) In sert into Sales values (3,'2016-2-12',4) 222344

Oracle 12c: SQL

3rd Edition

ISBN:9781305251038

Author:Joan Casteel

Publisher:Joan Casteel

Chapter1: Overview Of Database Concepts

Section: Chapter Questions

Problem 4RQ

See similar textbooks

Similar questions

Aseed fde.
Suppose that you are given a database that records information about human resources of a large multi-national company. You can find the enhanced en- tity relationship diagram of this database below. Answer the following question by writing am SQL query on this database. You are given an example output for the question. Records with '9999-01-01’ as their to date attribute are the current ones. salaries employees titles emp_no INT(11) emp_no INT(11) emp_no INT(11) salary INT(11) O birth_date DATE %23 title VARCHAR(50) from_date DATE first_name VARCHAR(14) from_date DATE to_date DATE last_name VARCHAR(16) O to_date DATE Indexes gender ENUM(M', F) Indexes PRIMARY hire_date DATE PRIMARY PRIMARY dept emp emp_no INT(11) dept_manager Kdept_no CHAR(4) O from_date DATE emp_no INT(11) departments dept_no CHAR(4) dept_no CHAR(4) to date DATE O from_date DATE O dept_name VARCHAR(40) KIndexes O to_date DATE Indexas PRIMARY Indexes PRIMARY dept_no PRIMARY dept_name dept no Find the first names and…
L Consultant ConsitNum LastName FirstName Street 19 Christopher Patrick Sarah Tom 35 $1 Client ClientNum ClientName 175 299 322 363 405 449 Turner Jordan Allen Shields 458 Hershey, Jarrod Goduto, Sean Two Crafty Cousins Prichard's Pizza & Salazar, Jason Fisherman's Spot Shop Seymour, Lindsey Bonnie's Beautiful Boutique Yates, Nick Howler, Laura Harpersburg Bank MarketPoint Sales Street 135 Mill Street 12 Saratoga Parkway 9787 NCR 350 West 501 Air Parkway 733 458 554 Brown Dr. 2287 Port Rd. 82 Elliott St. 373 Lincoln Ln. 322 867 322 363 867 826 677 733 826 867 WorkOrders OrderNum OrderDate ClientNum 67101 9/6/2018 67313 9/7/2018 9/10/2018 67424 67838 67949 68252 68868 68979 9/10/2018 9/10/2018 9/12/2018 9/14/2018 9/17/2018 4091 Brentwood Ln 9565 Ridge Rd. 231 Day Rd. 1368 E. 1000 S. 65 Forrest Blvd. 826 Host St. City Tri City Easton Lizton Sunland City Easton Tri City Sunland 68252 68868 68979 68979 Lizton 56473 Cherry Tree Dr Easton FL. 49 Elwood Ave. Harpersburg FL. Amo Tri City State…
Assignment (7)_9599bd...4ca854f63ff1644f1b1d Course's Name: C+ Palestine Technical University - Kadoorie Instructar's Nawe :Dr. Mota: Daadoo Course's Number: 1214100 Sudent's Name: Exam's Period : Snudent's Number: Questions Number : Total Mark :10 Section's Number: Due Date 14 May Pages' Number :1 Anignment Write a C++ program to swap elements of two arrays using pointers. Example: Input: Input first array: 100 330 30 40 50 60 70 80 90 10 Input second array: 1e 9 8 7 6 5 4 3 2 1 Output: First array after swapping: 10 9 8 7 6 5 4 3 2 1 Second array after swapping: 100 330 30 40 50 60 7e 80 90 10 Good Luck! II
Dentist DentistID DentistName DentistEmail james james@yahoo.com robert@yahoo.com david@yahoo.com richard@yahoo.com D1 D2 robert D3 david D4 richard D5 thomas thosmas@yahoo.com Treatments TreatID TreatType Fillings & Repair Price F1 50 G1 Gum Surgery 200 T1 Tooth Decay 80 T2 Teeth Cleaning 15 W1 Wisdom Teeth Removal 300 Patients PatientID PatientName PatientContact PatientEmail 16505130042 joseph@yahoo.com 16505135321 charles@yahoo.com 16505137728 daniel@yahoo.com P1 joseph P2 charles P3 daniel P4 matthew 16505133211 matthew@yahoo.com P5 anthony 16505139214 anthony@yahoo.com
Cse oop question
Assigning group access controls eliminates individual accountability. Select one: O True O False
legal aspects of cybersecurity Taissa, Sophie, Natalie, Misty, and Jackie all share a house in downtown Dayton. Duringthe great blizzard of 2023, all five co-habitants were snowed in and quickly ran out offood. Jackie tried to leave the house to get food, but quickly fell in the snow. Jackie’sroommates then murdered Jackie, and ate some of her remains to survive. Now the snowhas melted, and the girls are worried about the police finding out what they did. Natalie has had enough. She takes Jackie’s remains, throws them in a black, thick,hefty bag, and tosses them into the Rumpke dumpster she wheels from the side of thehouse, past the fence surrounding her house, and onto the curb in front of her house thenight before trash collection. Police have been waiting in a car on the street andimmediately search the hefty bag as soon as Natalie goes inside the house. Police findthe remains, obtain a warrant for the home, and arrest the girls. Did the police commitany Fourth Amendment…
question atatched
legal aspects of cybersecurity Taissa, Sophie, Natalie, Misty, and Jackie all share a house in downtown Dayton. Duringthe great blizzard of 2023, all five co-habitants were snowed in and quickly ran out offood. Jackie tried to leave the house to get food, but quickly fell in the snow. Jackie’sroommates then murdered Jackie, and ate some of her remains to survive. Now the snowhas melted, and the girls are worried about the police finding out what they did. Taissa wants to keep some evidence to blackmail her friends just in case things turnsour in the future. Whenever the girls discuss Jackie’s murder, Taissa surreptitiouslyrecords the discussions on her iPhone without anyone else knowing. Which of thefollowing best describes Taissa’s actions?A. Taissa committed an unconstitutional act.B. Taissa violated the Wiretap ActC. Taissa violated the Electronic Communications Privacy ActD. Taissa’s actions recording her friends are legal in most states.
QUESTION ONE Visual Basic AutoClick Limited (ACL) operates a used automotive sales garage in Accra with two categories of customers, namely Individual and wholesale Dealers. A whole sale dealer is a term used to describe another used automotive dealer who buys from ACL. All whole sale dealers are offered wholesale dealer discount. ACL also runs a vehicle trade-in policy whereby an individual customer who owns a vehicle can trade in their vehicle at a negotiated price. Additionally, ACL add interior extras, such as Paint Touch-up, Undercoat, etc. and exterior extras such as wheel upgrades, new tires, etc., on the request of their customers at an additional cost. Management requires an application that will manage the sale of its used vehicles. You are tasked to develop this app, create a Visual Basic Application that will take as input for each vehicle its lot number, Make, Model, Year, Millage, Engine Capacity and Price. For each Extra its ID, Name, Type (interior or Exterior) and…
QUESTION ONE Visual Basic AutoClick Limited (ACL) operates a used automotive sales garage in Accra with two categories of customers, namely Individual and wholesale Dealers. A whole sale dealer is a term used to describe another used automotive dealer who buys from ACL. All whole sale dealers are offered wholesale dealer discount. ACL also runs a vehicle trade-in policy whereby an individual customer who owns a vehicle can trade in their vehicle at a negotiated price. Additionally, ACL add interior extras, such as Paint Touch-up, Undercoat, etc. and exterior extras such as wheel upgrades, new tires, etc., on the request of their customers at an additional cost. Management requires an application that will manage the sale of its used vehicles. You are tasked to develop this app, create a Visual Basic Application that will take as input for each vehicle its lot number, Make, Model, Year, Millage, Engine Capacity and Price. For each Extra its ID, Name, Type (interior or Exterior) and…