Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

please solve this question database lab thanks ll touch 17:16 50% CSC1335L_Test2_A_V... a COBS! Diab - Test 2 Fall 2020 2021 Section- Answer all the

please solve this question
database lab
thanks image text in transcribed
ll touch 17:16 50% CSC1335L_Test2_A_V... a COBS! Diab - Test 2 Fall 2020 2021 Section- Answer all the following questions by writing the appropriate SQL queries in a word document with your name and student number, then hund the word document once done. Good luck Owner Name Sam Smith 2 Saraiver von Phone 0101190 OLC 2000 222 L-1970 Car Number Owner_id 1 2 BMW alep 1 Toyota Com 2030 10000 2036 15000 2007 20000 Based on the above tables, write the SQL statements for each of the following operation: 1. Create the tables Owner and Car as shown above 2. Insert the data shown above for each table. 3. Update the Brand to "Honda" for the car with Number - 1. 4. Delete the Owner with name start with letter 'E'. 5. Display all cars' Brand and Ycar which cost between 10000 and 25000 6. Display all distinct owners whose Name contain letter or starts with letter 7. Display all cars owned by an owner with phone --222 8. Display all ownets" name with their corresponding cars" Brand and Year which Cest> 15000

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Intelligent Information And Database Systems Asian Conference Aciids 2012 Kaohsiung Taiwan March 19 21 2012 Proceedings Part 3 Lnai 7198

Authors: Jeng-Shyang Pan ,Shyi-Ming Chen ,Ngoc-Thanh Nguyen

2012th Edition

3642284922, 978-3642284922

More Books

Students also viewed these Databases questions

Question

What is the role of Zn2+ in carbonic anhydrase?

Answered: 1 week ago