[PRIMARY FEATURE] Course Curriculum Schema - Githubissues

BroncoDirectMe / Backend

BroncoDirectMe's API for the Chrome Extension

https://broncodirect.me

9 stars 1 forks source link

[PRIMARY FEATURE] Course Curriculum Schema #57

Closed PattyCakesxD closed 1 year ago

PattyCakesxD commented 1 year ago

User Story

As a developer, I want to structure the course curriculum data in a well-defined, scalable, and easily query-able way.

Technical Tasks

Write a SQL query to define and create the schema of the 'Curriculum' table with the following columns:

id (primary key, auto increment)
Department
Course Name
Course Number
Course Description
Pre-Reqs
Course Category

Acceptance Criteria

A new 'Curriculum' table is created with the proposed schema

Related Issues:

Backend#58 Curriculum Table Helper Functions