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
ReplyDeleteTest
ReplyDeleteName :Yeasmin Sultana
ReplyDeleteID#201710251
Link: https://drive.google.com/open?id=1JBSgQaW1quDT5pP5s9Dt24UtOJqUTpL4
Abdul muzid sunny
ReplyDeleteID: 201720450
https://drive.google.com/open?id=1CFsy6_PIfAbGvbLkRDoJtc6-uWnVrPj_
Md Aminul Islam Tushar
ReplyDeleteID#201710063
Link : https://drive.google.com/open?id=1qGQpYqIWofhs6uIsRuY18vwLkcsqPqr9
https://drive.google.com/open?id=1V_uUtPIeC5Td0mDY6lm7NOLIlrCBE-Dc
ReplyDeleteName:Sumsunnahar Nawa
ReplyDeleteID:201710090
Update link:https://drive.google.com/open?id=1tUSLwvhC616xxiimKui1J9NEWWm3MNSp