in my system i have organization or an individual as my client.they can do blocking(just pay the registration fee)/booking(full payment)for any 3 different facilities ie.community hall,auditorium,concert chamber.cc & audi are booked based on 4 different slots for each day.it is possible for a customer to block/book any number of slots/facilities.now i have considered 3 tables 1 for customer,blocking & booking.but the problem is once if cust does blocking first & den later he cums 4 booking,my data will be duplicated in both block & book table.how can i avoid data duplication.cust(1)->blocking(m),cust(1)->booking(m)& blocking(1)->booking(1)
