Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

need perfrom select, join, Sum, Avg, Alter table of this Manager Managere Name 1-1 lowns 0 Cart CarPlate No {PK} Car Type . Can Colore

image text in transcribedimage text in transcribed

need perfrom select, join, Sum, Avg, Alter table of this

Manager Managere Name 1-1 lowns 0 Cart CarPlate No {PK} Car Type . Can Colore Can Availability ORDER Onder ID &PK} Onder Date Time Duration Orden Place CarBrand Car Model Staff StaffID {pk} Staff Name Staff Gender Staff Age Staff Mobile No Staff Salary Fuel Type 1. Requine Payment manages Payment ID {Pk} 0 Book acice Customer Payment Date Payment Status Customer ID Cust Name CustIC Cast Phone No cust Email CustAddress Vouchen Reedemp Pay for other Donate SOL Query for Creating Tables Manager Create Table Manager . Managerlo number(4) Not Null Primary key ManagerName varchar2:30) . Staff . Create Table Staff . . . . StaffID number(4) Not Null Primary key. StaffName varchar2/30). Staff Gender Varchar2/1) StaffAge number 3). Staff MobileNo number 10). StatSalary number(3,2) Customer Create Table Customer . . Customer numberi4) Not Null Primary key. CustomerName varchar2/30). Customeric number(4) CustomerPhoneNo numbersol. CustomerEmail varchar2/30). CustomerAddress varchar2130 Car . Create Table Car CarPlateNo varchar2/10) Not Null Primary key. Cartype varchar2/10). CarColor varchar218) CarAvailability varchar2/2). CarBrand varchar21101. Car Model varchar2/10). CarFuel Type varchar2/10) 1: . Order Create Table Order . . Order ID number(4) Not Null Primary key. Order Date Date Time Duration number(4) Order Place varchar2/15) Payment . Create Table Payment Paymenti number(4) Not Null Primary key. PaymentDate Date, Price number 10,2) PaymentStatus varchar211). Voucher Redemo varchar2120). PayforOther varchar2130). Donate varchar2130)

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

Students also viewed these Databases questions

Question

=+How should it be delivered?

Answered: 1 week ago

Question

=+4 How does one acquire a global mindset?

Answered: 1 week ago