Notes

1.
CREATE TABLE Classroom
(building varchar (15),
room_number varchar (7),
capacity numeric (4,0),
primary key (building, room_number));

1a.
INSERT INTO Classroom (building, room_number, capacity)
VALUES ('Packard', '101', '500');
VALUES ('Painter', '514', '10');


2.
CREATE TABLE Department
(dept_name varchar (20),
building varchar (15),
budget numeric (12,2) check (budget > 0),
primary key (dept_name));

2a.
INSERT INTO Department (dept_name, building, budget)
VALUES ('Biology', 'Watson', '90000');
VALUES ('Comp. Sci.', 'Taylor', '100000');
VALUES ('Elec. Eng.', 'Taylor', '85000');

3.
CREATE TABLE timeslot
(time slot id varchar (4),
day varchar (1),
start hr numeric (2) check (start hr >= 0 and end hr < 24),
start min numeric (2) check (start min >= 0 and start min < 60),
end hr numeric (2) check (end hr >= 0 and end hr < 24),
end min numeric (2) check (end min >= 0 and end min < 60),
primary key (time slot id, day, start hr, start min));

3a.
INSERT INTO timeslot (time_slot_id, day, start_time, end_time)
VALUES ('A','M','8:00','8:50');