Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i want Documentation for this project i want Documentation for this project Please give an upvote 1) The entities are customer, car, accident, rent operations,

i want Documentation for this project
image text in transcribed
i want Documentation for this project
image text in transcribed
image text in transcribed
image text in transcribed
Please give an upvote 1) The entities are customer, car, accident, rent operations, employee and insurance ret Somehow.com 3) Create table customer Cusid integer primarykey Name varchar(20) not null Address varchar(30) not null, Phone integer not null); Create table cart Carno integer primary key. Name varchar(20) not null Model integer not null, Year integer); Create table insurance Insno integer primary key, Amount integer not null, Carno integer Foreign key (carno) references car(Carno)); Create table accident Date date not null, Location varchar(20) not null, Carno integer, Foreign key(carno) references car (Carno)); Create table employee Empid integee primary key. Name varchar(20) not null, Phone integer not null, Role varchar(20) not null; Carno integer Foreign key[carno) references car (Carno)); Create table rent operations Name varchar(20). Type varchar(20) not null); Part ((1)) : The entities: insuranc, accident, car, customer Explorer rent operation (Ins-No amount) type (report-Ng location date Insurance accident Fnap I name M have home (check Icar rent Costomer year (CNO) Phone cid) adres Job) model noge ome Eld Employee 1 Address) name) manages M rent operation type Part 2 (mapping)) -Relations. -primary key / Forein Key connection customers F.K Id Frame/Lname phone address cho P.K car: ICNe model name year! (P.K Insurance: le F.K Ins-No amount type

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Programming The Perl DBI Database Programming With Perl

Authors: Tim Bunce, Alligator Descartes

1st Edition

1565926994, 978-1565926998

More Books

Students also viewed these Databases questions

Question

Express v as a power series expansion in terms of 6. AppendixLO1

Answered: 1 week ago