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

  • 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
    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
  • Lab 12 : Grading System using Pl/SQL
    Write a program in PL/SQL to Calculate Grade, GPA and CGPA after considering a result table where subject wise marks are inserted by c...
  • 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...
  • Lab 7 : Binary Relation with M:N cardinality ratio for a supplier and engineering parts
    Consider a binary relationship with M: N cardinality ratio. A supplier supplies many engineering parts , and a part is supplied by ma...
  • DAY 2: DBMS
    DBMS: Database management System is software, which is use for maintaining Database. Database System supports single-user and mult...
  • Practice Lab-2 : SQL Statement Practice amongh two tables
    Step 3: Create Table & Alter Table   Step 4: Create Integrity Constraint Step 5: Insert values Step 6: See the inserted values ...
  • DAY 5 : DISTRIBUTED DBMS
    What is Distributed Database Management System ? A distributed database management system is a software system that permits the man...
  • LAB 3: OPERATOR
    SQL অপারেটর ওরাকল অপারেটর এর মাধ্যমে একটি বা একাধিক আউটপুট তৈরী করা যায় । একই ভাবে অপারেটর একটি অথবা একাধিক অপারেন্ড / ভ্যালু(মান) / ...

Total Pageviews

Followers