Secure Census System

This repository contains the source code for an academic analysis and implementation of a secure digital census system. It stresses security from the beginning of the design, from user authentication, to data encryption, and audit logging. Next.js, a React framework, is used to quickly prototype the project's frontend and backend together in one place. SQLite is used for a local database to exemplify how queries should be made to the database securely. Lastly, additional packages are used for other necessary features in a secure app, such as Joi for data validation, and more.

Getting Started

Requirements:

• Node.js

Steps:

1. from the root directory, use npm install to autmatically download all required node modules
2. create a .env file in the root directory of this project with the following:

NEXTAUTH_URL="http://localhost:3000"
NEXTAUTH_SECRET=410EYYBwXiCOnBqEN+tQgCCKXwJvZiZ8RKNJHPLwiwc=
SECRET_KEY=xfn9P8L9rIpKtWKj68IZ3G865WfdYXNY

4. next use npm run dev to launch the dev version of the application (sufficient for demonstration)
5. navigate to http://localhost:3000 to see the website live

Using the Site

As a random:

1. navigate to http://localhost:3000
2. statistics from data based on all responses is displayed
3. that's it!

As a respondent:

1. nagivate to http://localhost:3000/login
2. enter the following credentials to sign in: akim@gmail.com akakak
3. you will be redirected to the dashboard page if successful
4. on the dashboard home page you may fill out the census response form as you wish and press the submit button at the bottom
5. the page will update, thanking you for your submission, and disallowing any further submission (one response per user)
6. that's it!

As an admin:

1. if you have not, sign in with akim@gmail.com akakak at http://localhost:3000/login
2. navigate to http://localhost:3000/dashboard/admin
3. here the audit logs which track every request are visible to the user
4. that's it!