Ready for submission

2 files changed, 35 insertions, 0 deletions

diff --git a/assignments/1/README.md b/assignments/1/README.md
index 1855b10..d876d93 100644
--- a/assignments/1/README.md
+++ b/assignments/1/README.md
@@ -153,6 +153,41 @@ Consider a one-relation database with the following attributes:
   * Foreign key constraints ensure that a valid corresponding relation must exist in the relation that the foreign key references.
   * A unique constraint on `departments(manager_id);` to ensure an employee cannot manage more than one department.
 
+Example postgresql SQL:
+```sql
+CREATE TABLE employees (
+  id bigint primary key,
+  department_id bigint,
+  project_id bigint,
+  hired_at date,
+  title varchar(255),
+  area varchar(255),
+  salary decimal
+);
+
+CREATE TABLE departments (
+  id bigint primary key,
+  manager_id bigint references employees(id),
+  budget decimal
+);
+
+CREATE TABLE projects (
+  id bigint primary key,
+  department_id bigint references departments(id),
+  budget decimal
+);
+
+CREATE TABLE phones (number varchar(255) primary key, employee_id bigint references employees(id));
+CREATE TABLE offices (number varchar(255) primary key, employee_id bigint references employees(id));
+
+ALTER TABLE employees ADD CONSTRAINT departments_fk FOREIGN KEY (department_id) REFERENCES departments(id);
+ALTER TABLE employees ADD CONSTRAINT projects_fk FOREIGN KEY (project_id) REFERENCES projects(id);
+
+CREATE UNIQUE INDEX department_manager_idx on departments(manager_id);
+CREATE UNIQUE INDEX employee_phones_idx on phones(employee_id);
+CREATE UNIQUE INDEX employee_offices_idx on offices(employee_id);
+```
+
 ## Question 6
 
 Consider the following relations:
diff --git a/assignments/1/README.pdf b/assignments/1/README.pdf
index 8a74b0b..95aea85 100644
--- a/assignments/1/README.pdf
+++ b/assignments/1/README.pdf