added foreign key for reservation
queries so far
added queries and data