Question
There are table: CITIZEN CITIZEN Name Type Description ID STRING Citizen ID Address STRING Citizen Address OWN_CAR STRING YES SAMPLE DATA CITIZEN TABLE ID Name
There are table: CITIZEN
| CITIZEN | ||
| Name | Type | Description |
| ID | STRING | Citizen ID |
| Address | STRING | Citizen Address |
| OWN_CAR | STRING | YES |
SAMPLE DATA
CITIZEN TABLE
| ID | Name | Address | OWN_CAR |
|
| 1 | West | Kemboja st | YES |
|
| 2 | Vanya | Teratai st | NO |
|
| 3 | Mozia | Mawar st | NO |
|
| 4 | Andana | Kemuning st | YES |
|
| 5 | Zeni | Bunga st | NO |
|
Make a Query to Update the OWN_CAR column in the CITIZEN table with ALL NO status to UNCONFIRMED!
little bit explanation is appreciated, thanks.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started
Principles Of Multimedia Database Systems
Authors: V.S. Subrahmanian
1st Edition
1558604669, 978-1558604667
