kE3C8iBh

1/* --------------------------------------------
2	PROBLEM 1 
3----------------------------------------------- */
4DROP TABLE IF EXISTS dorm_room CASCADE;
5DROP TABLE IF EXISTS student CASCADE;
6
7CREATE TABLE dorm_room (
8	building TEXT NOT NULL,
9    number INT NOT NULL,
10    dorm_room_building TEXT PRIMARY KEY,
11    dorm_room_number INT NOT NULL
12);
13
14CREATE TABLE student (
15    id INT PRIMARY KEY,
16    first_name TEXT NOT NULL,
17    last_name TEXT NOT NULL,
18    dorm_room_building TEXT,
19    dorm_room_number INT,
20    FOREIGN KEY (dorm_room_building)
21    	REFERENCES dorm_room(dorm_room_building)
22    	ON DELETE CASCADE
23);
24
25/* --------------------------------------------
26	PROBLEM 2
27----------------------------------------------- */
28CREATE TABLE