1 / 19

Medical Schedule Project

Medical Schedule Project. By Lori Tribble. CS8628 Software Architecture Spring 2006. Project Presentation Will Start Momentarily…. Introduction. Items to cover Project Description E-R Diagram Data Dictionary Relational Schema CRUD Matrix System Architecture Sample screens

maegan
Download Presentation

Medical Schedule Project

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Medical Schedule Project By Lori Tribble CS8628 Software Architecture Spring 2006 • Project Presentation • Will • Start • Momentarily…

  2. Introduction Items to cover • Project Description • E-R Diagram • Data Dictionary • Relational Schema • CRUD Matrix • System Architecture • Sample screens • Synchronization Code • Conclusion

  3. Project Description This project will create an application that will run on the Pocket PC to handle scheduling of dosages of medicine for patients. The patient or caregiver uses the database to keep up with when a medication needs to be taken, if it has been taken and how much was taken. The results are then synchronized on the desktop. A desktop application can then provide reports that the patient can give to caregivers or doctors.

  4. E-R Diagram

  5. Data Dictionary Table: MedTable Table: FillTable Table: TimesTable

  6. Data Dictionary Table: PatientTable Table: DrTable Table: PharmTable Table: AdminTable

  7. Relational Schema

  8. CRUD Matrix C = Create or Insert a Record (row) R = Read/Query or Select a row U = Update or Modify D = Delete

  9. System Architecture

  10. Sample Screens

  11. Sample Screens

  12. Sample Screens

  13. Sample Screens

  14. Sample Screens

  15. Sample Screens

  16. Sample Screens

  17. Synchronization Code Friend Shared Sub sync() Try openDb() With Conn.SyncParms .UserName = "afsample" .Stream = ULStreamType.TCPIP .Version = "ul_default" .SendColumnNames = True End With Conn.Synchronize() Catch ex As Exception MsgBox(ex.ToString()) End Try closeDb() End Sub

  18. Conclusion Problems Initial Sybase setup Reference files not getting deployed Too many schema source files Emulator does not save data Getting the forms to update correctly Open Issues Desktop application that can start the Mobilink server and issue a synchronization TimesTable form is not complete Use of Global Auto Increment Customize Scripts

  19. End of Presentation End Of Today’s Presentation

More Related