I need an 'As is process' for the question ASAP: Movie theatre ticketing system - The customer selects a movie and then the seats, after the

payment is completed the ticket is transferred to his email. Each ticket has invoice ID, which

would reside in the invoice table. The customer table will have the details of the customer, the

movie table will have all the listed movies in the theatre, the primary keys of both the tables

will be present in the booking table. The relationship between the customer and booking table

is many to one as each customer can book multiple tickets for different movie but each booking

id can only be assigned with one customer. The relationship between movie table and booking

table is one to many as one booking id can contain only one movie (considering the customer

can only book for one movie at a time), however many booking IDs can have the same movie.

The booking ID is in a one to one relationship with the invoice table, which is only generated

after payment, each invoice can be generated for only one booking ID, and each booking ID can

only be related to one invoice ID.