Created for the Database/API component of MSA Phase 1
The API is running on an Azure app service and it can be accessed here: https://msa-sims-student.azurewebsites.net/index.html
The student endpoints include all basic CRUD operations as well as an endpoint to retreive all students.
Screenshot of student endpoints
These endpoints allow an address to be created and edited by providing the id of the associated student
The address endpoints include all basic CRUD operations as well as an endpoint to retreive all addresses. There is also an additional endpoint which allows an address to be fetched via the ID of the associated student
Screenshot of address endpoints
The SQL Database has two tables, one for students and one for addresses. Below are screenshows showing example data in each of these tables:
Student table with example data
Address table with example data
There is a one-to-many relationship between students and addresses. This is implemented through the student id field in the address schema as show above. This allows any number of addresses to reference the same student, but keeping it as a single property means the address can only store a reference to exactly one student, enforcing the one-to-many relationship.