Databse normalisation /Suggestions

[phprock]

I have a situation like this A user can make 0 or many bookings. Each user may have 0 or many passenger ( Adult or Children or Infant).

I have structure like this

booking_user

booking_user_id
booking_user_name
booking_user_phone

booking

booking_id(pk)
booking_user_id(fk)

booking_passenger

passenger_id(pk)
passenger_booking_id(fk)
passenger_name
passenger_type ( ie,1 =Adult,2=Children 3=Infant)

My question do u recomend to have separate table for Adult,Children, infant for best database normalisation..

I m just storing names of the passenger.

Regards

[mrhappiness]

Originally posted by phprock
My question do u recomend to have separate table for Adult,Children, infant for best database normalisation..

Yes 🙂

[laserlight]

My question do u recomend to have separate table for Adult,Children, infant for best database normalisation.

Yes.
In fact, you're already doing that, except that for some reason you decided to shift the passenger_type data to the documentation.
After all, you jut need a table:

booking_passenger_type

type_id
type_name

[phprock]

Well, Thank you .
What u think to use enum for passenger type ?

[mrhappiness]

If you are absolutely 100% sure that you won't have any more types: think about it very carefully

if you think it's possible to have more types: don't do so