Answered step by step
Verified Expert Solution
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
i want Documentation for this project
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started