Task 1, 2, 3

Task 1 : How to store the list of courses to take in each term and in each year and for each of the 4 programs ? How to store the prerequisites of a course ? Note that there are various types of prerequisites. Refer to the examples presented previously.Task 1 does not require any implementation. It only requires that you define the data structures (or database table structure) that you will use and implement. You may use Database, and/or Files to store the data.

-----Task 1 Thoughts--------

• Can we have a list/array within a database? Could this be used to store pre-requisites?
• How will different types of pre-requisites be handled?
• Does Carleton scheduling have an API we can interact with? Could simplify data collection!
• How do you figure out a course's capacity?

Task 2 : How to store the courses offerings (term, LEC, LAB, capacity) ? Task 2 does not require any implementation. It only requires that you define the data structures (or database table structure) that you will use and implement. You may use Database, and/or Files to store the data.

Task 3 : How to store and access/update the list of electives (the project must consider all types of electives) ? Task 3 does not require any implementation. It only requires that you define the data structures (or database table structure) that you will use and implement. You may use Database, and/or Files to store the data

Notes:

Courses (See your detailed schedule on Carleton Central):

• Must be identifiable (Title, Subject, Number, Section, Term, CRN, Type) and unique (Primary Key = CRN)
• Must have a schedule (Time, Days)
• Must know its capacity and if its full (Capacity, Status)
• Must know how much credits its worth. This is because of course prerequisites. Some prerequisites require that a student be completed a certain amount of credits in a given year standing.

Proposed Database Table structure:

Table: Courses

Title | Subject | Number | Section | Term | CRN | Credits | Type | Time | Days | Capacity | Status

Table: Lecture To Lab or Tutorial Mapping

Lecture ID | Lab or Tutorial ID

Table: Prerequisite Type

ID | Description

Table: Class to Prerequisite Mapping

Prerequisite ID | Class CRN | Prerequisite Type | Course

Table: Academic Programs

ID | Name

Table: Academic Program to Course Mapping

Academic Program ID | Term | Course Type | Course