Phase 2. Part 1. Implementing the Prototype's Database (Bronze)
Use Python to code for creating an SQLITE3 database and create the data tables. Include primary keys, indexes (if they are required) and foreign keys.
Use Datagrip to generate a detailed ER diagram. You must also generate database creation scripts.
Take your own picture using your phone, save to your laptop and insert it to your database. Using Datagrip, write SQL to insert your details to the database. Now use Datagrip to link the image data to your personal data.
Document what you have done? What issues did you have?
Phase 2. Part 2. Implementing the Prototype's Data Management (Silver)
Install the server database of your choice onto your laptop. Link Datagrip to your database using the latest and recommended ODBC driver. Now create your database using the SQL script you developed for SQLITE3. Load your patient data and test image into the database.
Using Datagrip, compare the SQLITE3 and server database structures and SQL. Note the differences in languages and any differences in how the image is saved.
Use Datagrip to generate an ER diagram.
Phase 3. Part 1. Implementing the Prototype's GUI using SQLITE3 (Silver)
Using your choice of GUI library, write a Python form that will load your details and your saved picture. Think how you would benchmark this data transaction.
Enhance the application to enable you to edit and save changes to your patient records to the database.
Enhance the application to make changes to the images - delete existing or load new images using directory services or drag and drop,.
Document your work make a note of issues you have overcome and what issues could happen (e.g. timeouts).
Phase 3. Part 2. Reflection and testing enhancements (Gold)
Now using your experience, connect your application with your server database. Make a note of what you changed and why.
Benchmark transactions between the server database and the SQLITE database. What are your conclusions and what are your recommendations?
The server databases often come with their own administration software. How do these applications compare with Datagrip. Make sure you are objective and provide evidence.
Python is an interpretive language. Can you see any issues in using Python as your front-end programming tool? What about using Python as a programming language in the database server's stored procedures?
The marking is based around you demonstrating your understanding of the requirements, your capability to deliver a working prototype of image management and above all, you must give me the confidence, as your manager, that you will deliver and get "the job done".
4 freelancers están ofertando el promedio de $109 para este trabajo
Its not a very difficult task I surely can help you get done with this in given amount of time. I have plenty of experience in python and database design and development.