Skip to content

Latest commit

 

History

History
36 lines (29 loc) · 1.02 KB

README.md

File metadata and controls

36 lines (29 loc) · 1.02 KB
Raw

Pharmacy-Management-System-Python-tkinter-MSSQL-DBMS

This project uses tkinter (a library of python) for the GUI and MySQL for storing data.

-------Tools--------- Following tools are required to run this code:

  1. Python Interpretor such as pycharm
  2. Microsoft SQL Server Management Studio

-------Libraries--------- Make sure following libraries are installed on python Interpretor:

  • tkinter
  • pypyobdc / pyobdc

-------Database Setup--------- Before Running the code :

  • create a database named as 'Pharmacy Management System' in MS SQL:

  • create table inside this database using the following code:

create table pharma( ref_no INT PRIMARY KEY NOT NULL, comp_name varchar(60), typ varchar(60), med_name varchar(60), lot_no varchar(60), issue varchar(60), expire varchar(60), uses varchar(60), side_eff varchar(60), price varchar(60), )

-------Server Name--------- Make sure you assign sever name from MS SQL (which is usually name of your pc/laptop) to a string self.server_name (line:252) inside function named 'connect_database'