GIPI Covid-19
Social Computing: Public Health: Covid-19 Crisis:
Provide a story, narrative or description about the chosen Application: In order to persuade the public to wear masks, this application will use psychological persuasion and visual persuasion techniques. This application will use reward system plus videos that portray the importance of wearing a mask to protect oneself and others. By rewarding the public for wearing a mask sounds expensive, but the loss of closing businesses is way greater than rewarding people for wearing a mask. In fact, the relief bill could be used to reward the users of this application. This application will be available in all mobile devices that is connected to the internet because without the internet there is no way to communicate with the server. The application will be easy to understand and navigate by all users. First the user must sign up and verify themselves, then update their profile with a latest photo and provide a payment method. Each user will have a unique QR code which they can use to scan at a scan station. The scan station will take a picture of that user and send it to the server for verification. If the verification is successful, they will receive a notification on their app. And the user will be awarded. The user can only claim once every 24 hours.
Digital ER Model
The data storage and structure needed for this MySQL which will store the information about the users claim history, bank information, user information, login credentials. The userid will be used as key to store and retrieve data. The scan station will send the user information to processing center where the verification process will be conducted and after the verification is complete the processing center will send the request to reward center which sends request to the bank and back. If the bank verified and completed the transaction then send message back to data center which will stores the data about the transaction and send message back to processing center and the processing center will notify the user about the complete transaction or failed attempt with error message.
The user will have name and userid as entities. The scan station will have usrid, username, user’s taken photo, and location as its attribute. The processing center will have database request keys and already claimed Boolean value as its attribute. The reward center will have databases and bank information as attribute. The bank will have account number and dollar amount as attribute.
The data types will be account number will be long integers, money amount will be double, name will be string, and already claimed will be Boolean.
Relational Model
XML
<?xml version="1.0" encoding="UTF-8"?>
<root>
<User_information>
<Address>123 Main street</Address>
<Age>25</Age>
<Email>example@example.com</Email >
<FirstName>Jack</FirstName>
<LastName>Smith</LastName>
<Password>fHe876se8s76f8f6s</Password>
<PaymentMethod>paypal</PaymentMethod>
<Phone>3336664444</Phone>
<UserId>24242</UserId>
<bankAccountNumber>342342432</bankAccountNumber>
</User_information>
<alreadyClaimed>false</alreadyClaimed>
<transactionHistory>
<transationId>
<amount>3.01</amount>
<bankAccount>111112222</bankAccount>
<date>4/13/1999</date>
</transationId>
</transactionHistory>
</root>
JSON
Database[“user_id] = { “User_information” = {
“FirstName”: “Jack” ,
“LastName”: “Smith” , “UserId”: 24242,
“Age”: 25,
“Address”: “123 Main street” , “Phone”: 3336664444 ,
“Email”: example@example.com, “Password”:”e876se8s76f8f6s”, “PaymentMethod”: “paypal”, “bankAccountNumber”: 342342432 ,
},
“transactionHistory” = { “transationId” = {
“date”:”4/13/1999” ,
“amount”:3.01 ,
“bankAccount”: 111112222,
}
},
“alreadyClaimed”: false;
}
Data manipulation
CRUD
Pseudocode
exist = database[key]; //Check if key already exist
exist = database[key]; //Check if key is valid
exist = database[key]; //Check if key already exist
exist = database[key]; //Check if key already exist