FVS RDBMS is an inventory control system designed to efficiently model day to day operations of FVS Pharmacy stores.
Before the ICS, all FVS Pharmacys had inefficient database structures that do not properly model the operations of the store.
It is the purpose of this database system to provide an efficient, fast, and practical model for individual FVS Pharamcys.
Visit A Section
Attached is the ER Diagram for our RDBMS
PostgreSQL
The primary language used to create the database is PostgreSQL
PostgreSQL is an open-source relational database management system that supports both SQL and JSON querying.
Below is is snippet on how to create a table with PostgreSQL
create table Employee (
eID serial PRIMARY KEY,
firstname VARCHAR (50) NOT NULL,
lastname VARCHAR (50) NOT NULL,
address VARCHAR (50) UNIQUE NOT NULL,
ssn INT UNIQUE NOT NULL,
pos VARCHAR (50) NOT NULL,
salary INT NOT NULL,
status BOOLEAN NOT NULL
);pgAdmin 4
The management tool used for the database is pgAdmin
pgAdmin 4 is a graphical user interface (GUI) management tool for postgreSQL databases.
Below is a snippet of what the pgAdmin dashboard looks like
Below are instructions on how to run the web ui:
- Clone the project using command
git clone https://github.com/selfejji/Fake-Value-Store-Inventory-Control-System.git- Navigate into the flask folder in the project folder
cd flash- Run command to install all the libraries used by this project
pip install -r requirements.txt- Create a file: database.ini and put the following in it:
[postgresql]
host=localhost
database=DATABASE_NAME
user=USER_NAME
password=YOUR_PASSWORD- Create a file: flask.ini and put the following in it:
[flask]
secret_key=PUT_RANDOM_KEY_HERE- Run development server by using command
python app.py- Copy the address flask says it is running on and paste into your browser.
Below are the developers of this database:
Sammy Elfejji, selfejji2@student.gsu.edu
Samuel Cooney, scooney2@student.gsu.edu
Yared Geremew, ygeremew1@student.gsu.edu
Jamil Morris, Jmorris104@student.Gsu.edu