Mysql >>> create table

8. ER-Model Mapping to Database Relational Schema Parking_Lot(Lot_Id, Is_lot_avaliable) Parking Lot relation is in 2NF Block(Block_Id, Lot_Id, Is_Block_avaliable) Block relation is in 2NF Stall(Stall id, Block ld, Parking_Type, Parking_Size, Is_Stall_avaliable) Block relation is in 2NF Vehicle (Vehicle_id, Stall_Id, Vehicle_Type, Vehicle_Size, Customer_id) normalizing into 2NF 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) Customer relation is in 2NF Regular_Pass(Pass_Id, Customer_id, Pass_Type, Purchase_Time, Start_Time, End_Time, Cost) Customer relation is in 2NF Fine_Ticket(Ticket_Number,Create_Time, Start_Time, End_Time, Fine_Amount, Customer_Id, Vehicle_id Stall_Id, Employee_id) Fine_Ticket relation is in 2NF Employee (Emplyee Id, Employee_Name, Department) Employee relation is in 2NF