Register
Submit a solution
The challenge is finished.

Challenge Overview

In this challenge series we want to create an API for an educational management system (PacSIMS) that will later be used for two way integration with other EMIS.

In this challenge we will design the backend REST API that will expose data from the existing database (database model is attached in the forums). No coding is required. Challenge output is:

  • Swagger API definition

  • API to DB mapping document
���Api users will have three roles: Read only (RO), ReadWrite (RW) and admin. RO can call only endpoints to fetch data (used for data export from PacSims). RW can call endpoints that modify database data (used for importing data into PacSims), and admin role can generate new access tokens. JWT tokens will be used for authorisation and only admin role will be able to call the endpoint to generate new tokens. Admin should be authenticated with a preshared key/secret.

Database entities that should be exposed via API are Students, Enrolment School, Enrolment Courses, IAMarksheetResults, EAMarksheetResults, OutcomeBasedCourseMLOResults, OutcomeBasedCourseResults, OutcomeBasedCourseSLOResults. All of them should be exposed for read/write operations.

API will later be implemented with NodeJS, using SqlServer as the backend.



Final Submission Guidelines

Submit the swagger API design
Submit the API to db mapping document

ELIGIBLE EVENTS:

2018 Topcoder(R) Open

Review style

Final Review

Community Review Board

Approval

User Sign-Off

ID: 30063035