BIOM9450语言写作、Java程序设计调试

” BIOM9450语言写作、Java程序设计调试Biomedical and Health Informatics (BIOM9450)Major Project: A Web-Based Medication and Diet Regime Management SystemDue: Monday 30th November 5:00 pmTasksIn this project you are required to design a web-based medication and diet regime management system thatwould be suitable for use by a qualified health practitioner in an aged-care facility. You will not be given indepthdetails on how the Tasks are to be achieved: that is up to your ingenuity, creativity and perseverance. Themedication database, as well all web pages in your application should be your own design. However, essentialuser information must be entered and validated, and the referential integrity of the data maintained. In addition,patient confidentiality is to be maintained via a secure login feature.As a starting point, your database Design should include at least four tables: a Medications table, a Diet regimetable, a Patient table, and a Practitioner table. You will very likely need other tables to tie all the informationtogether but this is by your Design!The conceptual way such a system works is that a Web service running on aged-care facility system thatpopulates the Medications and the Diet regime tables for all residents for the upcoming week. The aged-carefacility system also delivers (in blister packs) the medications and the diet regime for each patient for theupcoming seven days. There are three medications and Diet regime rounds: morning, afternoon, and evening.The process is as follows:1. A practitioner logs onto the system2. A medications round (morning, afternoon or evening) for a particular day is selected.3. A diet regime round (morning, afternoon or evening) for a particular day is also selected.4. A patient is selected from a list (possibly also displaying their picture).5. Each medication and the diet regime menu for this patient is viewed and prepared and the medicationname, dosage, route of administration (as a minimum) are displayed. A set of rules about food, exercise,or beauty in the diet regime menu are also displayed. The practitioner dispenses and acknowledgesdelivery of EACH medication and the diet regime for the patient. Medications do not always have to begiven, so the system Should record such options as: given, refused, fasting, no stock, ceased. The systemshould also naturally record the name of the dispensing practitioner. If the medication for a patient isrefused, the system should send an email to the aged-care facilitys director with patient ID andpractitioner name.6. Step 4 is repeated for each medication and diet regime for this patient.7. Steps 3-5 are Repeated for all patients in the facility for which the practitioner is caring.It should be assumed that the medications and the diet regime data is available. For the sake of this project youshould choose to manually pre-populate the medications and the diet regime tables with data for the upcomingweek (i.e. the first week of December starting 30th November). You should also include data for the previousweek and have dispensed the medications and the diet regime to various (at least five) patients by at least twopractitioners. This will allow us to test the system and generate reports on medications and the diet regimeusage.If you do not know about diet regimes, you can browse the web. Many diet regime databases are proprietary butthere are some open source collections, e.g. httpss://www.healthdirect.gov.au/healthy-eating-over-602If you do not know about types of medication you can browse the web. Many medication databases areproprietary but there are some open source collections, e.g. https://medlibrary.org/drugs/index.htmlThe practitioner table should include a user name and a password for each practitioner/administrator in thesystem. It can be assumed that this data already exists in appropriate tables (i.e. you do not need to create webforms to do this data entry). Besides patient name and a photo, the patient table should also include a field todescribe what room the Patient resides in the aged-care facility. The above patient data is to be entered into thedatabase via an appropriate web page form.Practitioners should be able to insert new patient data into the database, as well as search, browse and edit data.In addition, practitioners should be able to view flexible medications and diet regime summary reports (twoseparate summaries) that can be configured for either all patients or a single patient and can be retrospective (forpast week) or prospective (for the upcoming week). This report should also be able to be sub-categorised bypractitioner. A sample Report from a significantly more complex web-based system is shown below to give yousome ideas on report layout.Finally in order to track practitioner workload, you should include at least one chart (using TeeChart) showingan aspect of medication/diet regime dispensing (for example, the number of patients each practitioner has seeneach day over the past week). To do this, download the TeeChart package from Moodle (TeeChart.zip),unzip it and place it in your G: drive. There is no installation required, as it only contains a bunch of PHP filesfor graphing. However, you will need to include some of these files using the following command, using arelative path from your PHP file: require_once(../TeeChart/sources/libTeeChart.php);If you are unsure about what directory PHP is working from (the directory from which relative paths aredefined), use the command echo getcwd(); to display the current working directory on the page. It will bethe directory of the PHP file which is running the PHP code. A sample php file to plot a very simple chart isincluded on Moodle to get you started.Server side validation of data should be performed using PHP. You may choose to also perform some clientside data validation using JavaScript.3ReportYou are expected to hand in a complete report detailing the tasks undertaken and the approaches adopted,including database design and user interface descriptions. This should include a brief users manual. It is notnecessary to print your PHP code (unless there are particular code snippets that you want to make mention of aswe will be accessing this from the server). Please clearly explain which web page(s) to access to run yourproject. Also ensure You include in your report the username and password of practitioners.Ideally, the system should be complete and bug free. If sections of your program do not work as expected, youshould explain where and why the bug(s) occurred, and what attempts you have made to track the source of theerror. Marks will be allocated for functionality, data entry checking, integrity checking, innovative design, errorfree operation, etc.. If you develop the system outside of the GSBmE computer lab you MUST check the fullfunctionality of the system on the GSBmE computer system (including database, web server and browser).Many times we have had projects Submitted that fail to work as expected due to incompatibility issues.Please make sure as part of the user manual you provide sample login usernames and passwords so wecan easily check your design. NB: A non-plagiarism declaration form must be attached to your hand-in report.Zip everything up and submit your files on Moodle but also leave the current copy on your G: drive. Allby the due date.Proposed Marking Rubric (Total 100) Database (20)o Required data structures and data (10) [should be giveaway marks] Patient (2) Practitioner / Password protection (2) Medications (2) Diet regimes (2) Prepopulated medication data for two weeks (second week not dispensed) (2)o Table design (6) Normalisation, layout, overall design (2) [a general feel] Data type selection (2) [using appropriate data types] Constraints (2) [primary key, field constraints]o Relationships (4) Justification (4) [a brief discussion in the report] Web functionality (28)o Login (3) Username / password check (1) Logout (1) Behaviour, overall security (of all pages) (1)o Medication administration and dispensing (4) Dispensing round (4)o Diet regime administration and dispensing (4) Dispensing round (4o Practitioner tasks (10) Inserting patient data (2) Search/browse/edit data (2) Display patient photo (may be pre-loaded into table) (3) Medications report (2) Diet regime report (1)o TeeChart plot or tabulation (4)o Navigation (3) Error checking and Validation (15)o PHP server validation (and optional Javascript) of key fields (10)4o SQL error handling (2) [1 for no SQL errors encountered, 1 for correct handling]o General user-friendliness of messages (3) [general feel] Web interface, design, presentation (20)o Web (15) [mainly a general feel for the interface, use of CSS, etc.]o Code (5) [style, comments, etc.] Report (17)o Tasks undertaken / approaches (5)o Website user manual (10)o (Note also 2 marks allocated for a description of the justification of the database/structures/normalisationin the Database section above)如有需要，请加QQ：99515681 或邮箱：99515681@qq.com

“