Database Systems Project Contribution

PROJECT TITLE: Database for Pharmacy (Elfata)

TEAM MEMBERS: Chan Elizabeth Wirawan, Naman Vohra, Marco Melvern, and, Michael Edward Baharutan .

  • Designed the schema along with Marco. This includes deciding suitable fields for each table and defining relations between them.
  • Created the fxml, controller, and the setter&getter files for the following tables: transaction, transaction_details, product, supplier, and supplier’s product (Style of buttons excluded). Developed the extra logic needed behind the transaction_details and product tables as these two are related. Thus, contributed mainly to the back-end part of the program.
  • Helped in debugging Chan’s code which generates fxml scenes of Customer and Staff details. Problems related to syntax errors are solved.
  • Studied the basics of iText library which has the ability to generate a pdf file needed for the bill.
  • Provided 5 sample queries in the report. These queries range from simple one like selecting all data from a table to complex queries which include JOIN operations.
  • Created the database (elfataa) and its tables in phpmyadmin. Wrote the queries to create the tables manually (especially the ones using Foreign key).
  • Lastly, provides opinion and assistance to other team members whenever they require it.

Comments are closed.