create table Camp(name int not null, primary key (name), minAge int, maxAge int, startTime time, endTime time);
Question:
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));
Database Systems Design Implementation and Management
ISBN: 978-1337627900
13th edition
Authors: Carlos Coronel, Steven Morris