Tasks and Duties
The student will be required to design and implement a database for a hypothetical e-commerce platform. The database should cater for all the necessary entities such as users, products, orders and transactions. The student should use an SQL-based DBMS such as MySQL or PostgreSQL. The task involves the following steps: (1) Requirements gathering and analysis; (2) Conceptual Design using ER diagrams; (3) Logical Design; (4) Physical Design and (5) Implementation of the database schema on the chosen DBMS. The deliverable will be a DOC file containing the ER diagrams, SQL scripts for creating the database schema and a report explaining the design and implementation process. The evaluation criteria will be based on the comprehensiveness and correctness of the database design and implementation.
The student will be required to build a Web API for the e-commerce platform whose database design and implementation was done in Week 1. The API should provide endpoints for performing CRUD operations on the main entities of the platform. The student can use any suitable language and framework for building the API, but they must ensure that the API is RESTful. The deliverable will be a DOC file containing the API specification, example requests and responses, and a report explaining the design and implementation of the API. The evaluation criteria will be based on the correctness, completeness and quality of the API.
The student will be required to design the UI/UX for the e-commerce platform. They should use a design tool like Adobe XD or Sketch to create mockups for the main pages/screens of the platform. They should also create a user flow diagram to illustrate how users will interact with the platform. The deliverable will be a DOC file containing the mockups, user flow diagram and a report explaining the design decisions. The evaluation criteria will be based on the quality of the design and the usability of the platform.
The student will be required to implement the front-end of the e-commerce platform using a suitable language and framework. The front-end should be responsive and should consume the API built in Week 2. The deliverable will be a DOC file containing the source code, screenshots of the implemented front-end, and a report explaining the implementation process. The evaluation criteria will be based on the quality and correctness of the implementation, and the responsiveness of the front-end.
The student will be required to conduct comprehensive testing on the e-commerce platform. They should test the database, API, and front-end and fix any bugs that they find. They should use a systematic approach for testing and debugging such as unit testing, integration testing, and system testing. The deliverable will be a DOC file containing the test cases, test results, identified bugs, and a report explaining the testing and debugging process. The evaluation criteria will be based on the comprehensiveness of the testing, the number and severity of the identified bugs, and the quality of the debugging.
The student will be required to deploy the e-commerce platform on a suitable platform such as Heroku or AWS. They should also create comprehensive documentation for the platform including user manuals and technical documentation. The deliverable will be a DOC file containing the deployment guide, user manuals, technical documentation, and a report explaining the deployment and documentation process. The evaluation criteria will be based on the success of the deployment and the quality and comprehensiveness of the documentation.