University of Tampa Databases Question

Hey there. i will have to provide you with some information with your help. and the requirements

Using Python, Flask, Bootstrap, and PostgreSQL, build a contact tracer website.

This website should enable people to create an account, indicate if they have been sick (from start date to end date), and list all the people they were in contact with recently (with dates). If the person was already marked as in contact with someone else, they will be told they might be sick if their contact was with a sick person. Also support different diseases, and disease has an explanation of what it is.

For example, if Julie gets sick, she will make an account and say she was in contact with Joe and James (at certain times). Then, if Joe creates an account, he will see that he was in contact with someone who was sick (since he was in contact with Julie in the time range that she was sick). He won’t be told the name of the person that was sick. If Joe turns out to be sick, he can list his contacts, too, etc.

Use a Bootstrap theme to make the website look nice. Create your own normalized tables. Everybody’s work should be done on their own, so I should not see the same code for anyone. Turn in our table-creation commands and Python/HTML code. Turn in a ZIP file.

We’ll develop some of this in class so you don’t have to start from scratch.

Hint:

Look on delenn at /home/jeckroth/cinf201/2022-spring/class-notes.txt for explanation of form POST vs. GET.

Hint:

Table structure:

• Users table: id & name
• Contacts table: user 1 id, user 2 id, date
• Diseases table: id, name, explanation
• Users / Diseases table: user id, disease id, start date, end date

Hint:

If using delenn, you will need to “forward” your Flask port. In your Flask code, in the last line, choose a random port like 40289 or whatever. Then, when you start Python, it should use that port. To access it from your computer, you need to set up Putty to forward that port. Right-click on the titlebar and choose Change Settings, expand Connection and SSH and click Tunnels, in Source Port type your port (40289) and in Destination type localhost:40289 (change the port). Then click Add. Then you probably want to save this Session also with a name like cinf201.

On Mac, type: ssh -L 40289:localhost:40289 user@delenn.stetson.edu (change port and user).