Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

Online Systems For Physicians And Medical Professionals How To Use And Access Databases

Authors: Harley Bjelland

1st Edition

1878487442, 9781878487445

More Books

Students also viewed these Databases questions

Question

3. You can gain power by making others feel important.

Answered: 1 week ago