Secure Database
Developed By Marco Lopez
As a team, we recently collaborated on a project to create a secure website on www.bluehost.com. Our leader, Angela, drew a diagram, which I used to develop a SQL database consisting of five tables: Faculty, Patient, Test, and Visit. This database enables doctors and patients to schedule appointments, login and access test results. I created PHP pages to link the HTML web pages made by Elizabeth to the database. To ensure the website's security, we implemented various security measures such as hashing for passwords and Multi-Factor Authentication (MFA) using PHP. Elizabeth also added a Captcha and SSL/TLS to the website. Angela included Password Validation to ensure that users enter a strong password containing at least 16 characters, a mix of lower and upper case words, and numbers.
Additionally, to comply with HIPAA law, I added two search bars for doctors to search for test results and obtain patient information such as their name and email. Patients can only search for their own test results for their privacy. By working together, we successfully created a secure website that meets the needs of both doctors and patients.