Create Student Table and Teacher Table

[h0ethan04]

Description

• Your task is to create some of the tables that we will be using throughout the rest of this project.

Instructions

• Create students and teachers tables according to the database model
  • Refer to PostgreSQL documentation for creating a table
• Create students and teachers tables schema under server/db/schema/.
• Name the schema files as students.sql and teachers.sql

Notes

• Arrows on the DB model indicate foreign constraints
• For now, assume that all attributes are NOT NULL unless otherwise specified
• Use DB Fiddle or Local Postgres to test (NOT NEONDB PRODUCTION DATABASE)
• If your table relies on another table by foreign key, create a dummy table containing the primary key and any other fields needed

Acceptance Criteria

• SQL creation code should exist in a file located in server/db/schema/students.sql and server/db/schema/teachers.sql
• Should be able to insert rows into table successfully (be sure to include pictures of this)

Resources

• DB Model
• Create Table Tutorial
• Refer to Sample Table Creation