create table Camp(name int not null, primary key (name), minAge int, maxAge int, startTime time, endTime time);

create table session(id int not null, primary key(id), beginningDate date, endDate date);

create table fieldTrip(tripId int not null, primary key(tripId), destination varchar(50), leaveTime time, returnTime time, sessionId int, foreign key (sessionId) references session(id));

create table group_X(groupId int not null, primary key(groupId), kidsAge int, minAge int, maxAge int, sessionId int, foreign key (sessionId) references session(id));

create table activity(activityId int not null, primary key(activityId), name varchar(50), minAge int, maxAge int, startTime time, endTime time, sessionId int, foreign key (sessionId) references session(id));

create table child(childId int not null, primary key(childId), name varchar(50), age int, nextGrade int, numbParents int, sessionId int, foreign key (sessionId) references session(id));

create table parent(parentId int not null, primary key(parentId), name varchar(50), address varchar(100), homePhone varchar (50), workPhone varchar(50), childId int, sessionId int, foreign key (sessionId) references session(id));

create table employee(employeeId int not null, primary key(employeeId), name varchar(50), age int, position varchar(50), schedulesFor varchar(50), sessionId int, foreign key (sessionId) references session(id));