Question
Mysql Server -- create table Parking_Lot(Lot_Id, Is_lot_avaliable) Block(Block_Id, Lot_Id , Is_Block_avaliable) Stall(Stall_Id, Block_Id , Parking_Type, Parking_Size, Is_Stall_avaliable) Vehicle(Vehicle_Id, Stall_Id , Vehicle_Type, Vehicle_Size, Customer_Id ) vehicle1(vehicle_Id,
Mysql Server -- create table
Parking_Lot(Lot_Id, Is_lot_avaliable)
Block(Block_Id, Lot_Id, Is_Block_avaliable)
Stall(Stall_Id, Block_Id, Parking_Type, Parking_Size, Is_Stall_avaliable)
Vehicle(Vehicle_Id,Stall_Id, Vehicle_Type, Vehicle_Size, Customer_Id)
vehicle1(vehicle_Id, stall_Id)
vehicle2(vehicle_Id, Vehicle_Type, Vehicle_Size, Customer_Id)
Customer(Customer_Id, Is_Regular_Customer, Customer_Name, Phone_Number, Registration_Time)
Regular_Pass(Pass_Id, Customer_Id, Pass_Type, Purchase_Time, Start_Time, End_Time, Cost )
ine_Ticket(Ticket_Number,Create_Time,Start_Time,End_Time,Fine_Amount,Customer_Id,Vehicle_Id, Stall_Id, Employee_Id)
Employee(Emplyee_Id, Employee_Name, Department)
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