src/data_layer/DBManager.java
private void createRoomTable() throws SQLException {
		Statement state = conn.createStatement();
		state.execute(
				"CREATE TABLE IF NOT EXISTS Room (t_id INTEGER REFERENCES Theatre(t_id) ON DELETE CASCADE, room_id INTEGER, PRIMARY KEY (t_id,room_id));");
	}
/*
	 * Creating room table with cascade delete which means whenever a theater is
	 * deleted, all rooms in that theater are deleted
	 */
Creating room table with cascade delete which means whenever a theater is
deleted, all rooms in that theater are deleted
Creating room table with cascade delete which means whenever a theater is deleted all rooms in that theater are deleted
private void createRoomTable() throws SQLException {
		Statement state = conn.createStatement();
		state.execute(
				"CREATE TABLE IF NOT EXISTS Room (t_id INTEGER REFERENCES Theatre(t_id) ON DELETE CASCADE, room_id INTEGER, PRIMARY KEY (t_id,room_id));");
	}
private void createRoomTable ( ) throws SQLException { Statement state = conn . createStatement ( ) ; state . execute ( "CREATE TABLE IF NOT EXISTS Room (t_id INTEGER REFERENCES Theatre(t_id) ON DELETE CASCADE, room_id INTEGER, PRIMARY KEY (t_id,room_id));" ) ; }
Creating room table with cascade delete which means whenever a theater is
 deleted, all rooms in that theater are deleted
Creating room table with cascade delete which means whenever a theater is deleted all rooms in that theater are deleted