Construct sql for an accident management database

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"

11 comments:

  1. Home Work For:Construct sql for an accident management database

    https://www.dropbox.com/s/dhp9t8lo34pl0j4/HomeWorkLAB15.txt?dl=0

    ReplyDelete
  2. https://www.dropbox.com/s/m3nz7j1e7t8w49v/lab_15.txt?dl=0

    ReplyDelete
  3. https://www.dropbox.com/s/9he8jgwlqrgs5h9/accident%20management%20database.txt?dl=0

    ReplyDelete
  4. Name :Yeasmin Sultana
    ID#201710251
    Link: https://drive.google.com/open?id=1JBSgQaW1quDT5pP5s9Dt24UtOJqUTpL4

    ReplyDelete
  5. Abdul muzid sunny
    ID: 201720450
    https://drive.google.com/open?id=1CFsy6_PIfAbGvbLkRDoJtc6-uWnVrPj_

    ReplyDelete
  6. Md Aminul Islam Tushar
    ID#201710063

    Link : https://drive.google.com/open?id=1qGQpYqIWofhs6uIsRuY18vwLkcsqPqr9

    ReplyDelete
  7. https://drive.google.com/open?id=1V_uUtPIeC5Td0mDY6lm7NOLIlrCBE-Dc

    ReplyDelete
  8. Name:Sumsunnahar Nawa
    ID:201710090
    Update link:https://drive.google.com/open?id=1tUSLwvhC616xxiimKui1J9NEWWm3MNSp

    ReplyDelete

Popular Posts

Total Pageviews

Followers