Im currently creating a database that records my cinema visits. I have at present have split one of my tables tblcinema into two tables. The majority of information regarding cinema location, ticket price etc are held in tbl cinema and details regarding the screens and best seating position are held in another table. This was done to reflect that not all cinemas have the same number of screens thus preventing multiple fields to lay empty. However the problem I now face is what relationship should I define between the two tables.