Create a simple DB, on a cloud, that contains two relations. One relation/table has content describing a student, namely: student ID, consisting of three decimal digits, and a nickname (6 alphabetic characters). The second table/relation should have just two columns: one is the student ID while the other is an identifier of an image stored in the Cloudinary image data store. Thus, an example tuple < 123, picID > denotes that the student 123 has image picID. Note that the picID may be a string that may be used I obtaining the picture from the Cloudinary store. Although your DB must be on a cloud, it could be a managed DB, such as MongoDB, or it could be DB on a DBMS, such as MySQL or SQL Server, that you install on a virtual machine on AWS or some other cloud provider. Use Cloudinary to store images of students.
Please note that you can interpret the above that each student has just one image- a picture of the student. In such a case, the second table, containing the tuples <student ID, picID> is redundant and you may store the picID in the first table. Or, you may interpret the above that each student can have more than one image stored in the Cloudinary store. Just let us know which of the two interpretations you are supporting.
b. Host a web-server to implement back-end functionality using php, .Net, node.js server, or other such web server on Azure or AWS, to create REST-based services described below. Enable audit logging for all incoming requests on the application serve so that the log would contain a) Timestamp, b) User-agent and c) Query Parameters (Request Signature). See Log4j ([login to view URL]) as an example. If your server does not provide a facility to log web services requests, you need to state so explicitly (while making sure that you are correct).
c. Create the following REST-based web services such that parameters are passed using JSON
i. Create a student (parameter passed is student ID).
ii. Insert a picture of a student (passed are student ID and URL or file
iii. Display a picture(s) of a student (passed is the student ID) .This may be achieved by the web service fetching the picture ID from the DB and passing it back to the client app, which then fetches the picture from the Cloudinary store and displays it to the user. Of course, another option is for your web service to fetch the picture ID from the DB; then use it to fetch the picture from Cloudinary; and then return the picture to the client app as a response of the web service invocation.
iv. List the content of the table(s) containing the student information
v. Delete a student (parameter passed is student ID) and all the student’s information.
2. Create a client JS application or a webpage (with JS scripting) that interacts with the user to
enable the user to interactively specify services on student-pictures information (services that correspond to the web services listed above). A client needs to be simple and intuitive and it needs to enable the user to choose an action (e.g., insert new student), provide for input of an appropriate parameter(s) if needed (e.g., a student ID), invoke appropriate web service running on the VM, and then process the response from the web services and inform the user appropriately.
11 freelancers are bidding on average $133 for this job