person(ss#, name, address)
car(license, year, model)
accident(date,driver,damage-amount)
owns(ss#,license)
log(license, date, driver)
Consider the above database, where the primary keys are underlined. Construct the following sql queries for this relational database.
(a) Find the total number of people whose cars were involved in accidents in 2016
(b) Find the number of accidents in which the cars belonging to "Torin" were involved
(c) Add a new customer to the database
(d) Delete the Mazda belonging to "Torin"
(e) Add a new accident record for the Toyota belonging to "Tutum"
car(license, year, model)
accident(date,driver,damage-amount)
owns(ss#,license)
log(license, date, driver)
Consider the above database, where the primary keys are underlined. Construct the following sql queries for this relational database.
(a) Find the total number of people whose cars were involved in accidents in 2016
(b) Find the number of accidents in which the cars belonging to "Torin" were involved
(c) Add a new customer to the database
(d) Delete the Mazda belonging to "Torin"
(e) Add a new accident record for the Toyota belonging to "Tutum"
Home Work For:Construct sql for an accident management database
ReplyDeletehttps://www.dropbox.com/s/dhp9t8lo34pl0j4/HomeWorkLAB15.txt?dl=0
https://www.dropbox.com/s/m3nz7j1e7t8w49v/lab_15.txt?dl=0
ReplyDeletehttps://www.dropbox.com/s/9he8jgwlqrgs5h9/accident%20management%20database.txt?dl=0
ReplyDelete