Bhavya's MIS Lab Class Assignment Week 6

.docx

School

Stevens Institute Of Technology *

*We aren’t endorsed by this school

Course

632

Subject

Computer Science

Date

Dec 6, 2023

Type

docx

Pages

4

Uploaded by DeanSteelElephant36

Report
Bhavya Sri Linganagunta Data Management LAB Class Assignment Week 6: SQL part 3 1. (a) Change the car make from “Chevrolet” to “Chevy” for every car model with that make in the car type table. QUERY: UPDATE car_model_table SET car_maker = 'Chevy' WHERE car_maker = 'Chevrolet'; select * from car_model_table where car_maker = 'Chevy' RESULT: (b) How many rows were updated? Answer: 35 Rows
2. Add a new pending claim for policy 104332058-X with the following details: Claim Number: 565071285-9 Claim Date: December 31, 2018 Claim Amount: $5,000 QUERY: INSERT INTO claim (Policy_Number, Claim_Number, Claim_Date, amount) VALUES ('104332058-X', '565071285-9', '2018-12-31', 5000); Select * from claim where policy_number = '104332058-X' RESULT: 3. Remove the policy associated with the vehicle that has a VIN ending in “21733” QUERY: DELETE FROM policy
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS
Recommended textbooks for you
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Text book image
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
Text book image
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
SEE MORE TEXTBOOKS