Scribd
Upload
4 views3 pages

Database Lab Insurence

The document outlines a database schema for an insurance system, detailing tables for Person, Car, Accident, and Log. It includes specific data entries for accidents, car ownership, and personal information, along with a list of problems to solve related to accidents and car ownership. The problems range from finding individuals involved in accidents to analyzing damage amounts and car details.

Uploaded by

bdagasa7
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
4 views3 pages

Database Lab Insurence

The document outlines a database schema for an insurance system, detailing tables for Person, Car, Accident, and Log. It includes specific data entries for accidents, car ownership, and personal information, along with a list of problems to solve related to accidents and car ownership. The problems range from finding individuals involved in accidents to analyzing damage amounts and car details.

Uploaded by

bdagasa7
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Database:-INSURANCE

Database Schema:
Person(name, street, city)
Car(license, model, owner)
Accident(date, driver, damage_amount)
Log(license, driver, date)

Table:- Accident

Damage_a
Driver Date mount
Adams 1998-04-03 50
Curry 1999-06-18 110
Hayes 1998-04-02 120
Jack 1999-12-13 500
Jackson 1999-12-05 300
Jones 2000-03-10 200
Jony 2000-04-17 800
Smith 1999-08-23 300
Tom 2000-01-05 200
Willium 2000-01-05 700

Table:-Car

Model Owner License


majda Jones l-123
rm-4 Smith l-142
mellian Green l-231
roles Curry l-352
marity Curry l-392
tata-42 Smith l-413
tata-42 Turner l-532

Page | 1
Table:-Log

License Driver Date


l-231 Adams 1998-03-04
l-352 Curry 1999-06-18
l-392 Hayes 1998-04-02
l-392 Jack 1999-12-13
l-352 Jackson 1999-12-05
l-123 Jones 2000-03-10
l-532 Jony 2000-04-17
l-142 Smith 1999-08-23
l-392 Tom 2000-01-05
l-413 Willium 2000-01-05

Table: Person

Name Street City


Curry Nort Harrison
Green Wainut Stamford
Jones Main Harrison
Smith North Rye
Turner Putman Stamford

Page | 2
Problem List

Problem 1: Find the names and addresses of the people whose car were involved in
accidents on date 01-05-20000.

Problem 2: Find the number of accidents in which the cars belonging to “Curry”.

Problem 3: Find the name and address of the people whose car were involved in
maximum accident.

Problem 4: Find the name and address of the people whose car were involved in
accident in which the damage amount is greater than 300$.

Problem 5: Find the name and address of the people whose car were involved in two or
more accidents.

Problem 6: Find the total number of people whose cars were involved in accident in
2000.

Problem 7: Find the name and address of the people whose car was involved in
accident in which damage amount is maximum

Problem 8: Find the license no., model and owner of the car that is not involved in
accident.

Problem 9: Find the name and address of the people whose car was involved in
accident both in 1998 and 2000.

Problem 10: Find the license no., model and owner of the car those were involved in
accident in which damage amount is greater than the average damage amount.

Page | 3

You might also like