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. Bashir FardoushMarch 29, 2016 at 8:43 AM

    Home Work For:Construct sql for an accident management database

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

    ReplyDelete
  2. Monowara MehrinMarch 29, 2016 at 9:49 AM

    ReplyDelete
  3. Reshma AkterMarch 29, 2016 at 10:58 AM

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

    ReplyDelete
  4. Amena akter AnniMarch 29, 2016 at 7:45 PM

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

    ReplyDelete
  5. JockerNovember 15, 2018 at 2:22 AM

    Test

    ReplyDelete
  6. Yeasmin SultanaNovember 15, 2018 at 5:59 AM

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

    ReplyDelete
  7. Abdul muzid sunnyNovember 15, 2018 at 8:25 AM

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

    ReplyDelete
  8. AnonymousNovember 15, 2018 at 9:49 AM

    Md Aminul Islam Tushar
    ID#201710063

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

    ReplyDelete
  9. Shakil Ibne ShaikhNovember 15, 2018 at 10:58 AM

    ReplyDelete
  10. Shakil Ibne ShaikhNovember 15, 2018 at 11:00 AM

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

    ReplyDelete
  11. sumsunnahar nawaNovember 18, 2018 at 5:28 AM

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

    ReplyDelete

Subscribe to: Posts (Atom)

Popular Posts

  • Perfect Number
    1. Write a program to display all the perfect number from a column of a table. Use Cursor and User defined function.
  • Prime Number
    1. Write a program to count the prime number from previously stored values in a column of a table using pl/sql
  • Fibonacci Series using pl/sql
    1. Write pl/sql code to generate Fibonacci Series and save the series into a table. 2. Generate Fibonacci Series using a PL/SQL user defi...
  • Perfect Number
    Write a program to check perfect number using pl/sql
  • DAY-1: EXAMPLE-1
    Student Table Key word: Select, Create, Insert Schema: Entity/Field Name Data Type Student_id Number(10) ...
  • DAY-1: THE SQL
    What is SQL? SQL stands for Structured Query Language. SQL is used to communicate with a database. According to American National Stan...
  • Lab 5 : Exercise on SQL queries.
    (a) Consider the relational table given below and answer the following SQL queries.   Think that the table has filled up by employee’s re...
  • DAY 6 : NORMALIZATION OF DBMS
    What is Data Normalization ? Normalization is the process of efficiently organizing data in a database. There are two goals of ...
  • Prime Number From a Table
    Write a pl/sql source code to check all data from a student_id column of a student table. After check show all student_id which are prime....
  • (no title)
    Index of Oracle DBMS Practice and Study Schedule Track Activated DAY-1: THE SQL DAY-1: EXAMPLE-1 DAY-1: DEFINITION DAY...

Total Pageviews

Followers