The FVS ICS

FVS ICS 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

• The Structure of the ICS
• Platforms
• Contributors

The Structure of the ICS

Attached is the ER Diagram for our ICS

Platforms

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

Contributors

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