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...
  • 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 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...
  • Perfect Number
    Write a program to check perfect number using pl/sql
  • 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 ...
  • DAY 4 : Directory Service
    What is Directory Service ? A directory service is a software application — or a set of applications — that stores and organizes...
  • DAY-1: EXAMPLE-1
    Student Table Key word: Select, Create, Insert Schema: Entity/Field Name Data Type Student_id Number(10) ...
  • Lab 9 : Organizational Database Design
         Design a complete schema with relational diagram for the following situation: An organization has two types of employees, salarie...