130 skills found · Page 3 of 5
funktechno / Sqltooling Drawio3rd plugins for sql tooling in drawio
NouraAlgohary / Entity Relationship Diagram ERD Entity Relationship Diagram examples with solutions.
38tter / MergrationGenerate migration files from your mermaid ER diagrams
eska-muc / DbvisualizerA tool for creating ER-Diagrams and textual reports on tables and columns of a database by reading metadata from any JDBC capable database.
Anjulcodewiz / Pharmacy Management SystemINTRODUCTION: The main aim of the project is the management of the database of the pharmaceutical shop. This project is insight into the design and implementation of a Pharmacy Management System. This is done by creating a database of the available medicines in the shop. The primary aim of pharmacy management system is to improve accuracy and enhance safety and efficiency in the pharmaceutical store. The aim of this project is to develop software for the effective management of a pharmaceutical store. We have developed this software for ensuring effective policing by providing statistics of the drugs in stock. Description on the topic: This program can be used in any pharmaceutical shops having a database to maintain. The software used can generate reports, as per the user’s requirements. The software can print invoices, bills, receipts etc. It can also maintain the record of supplies sent in by the supplier. Here, the admin who are handling the organization will be responsible to manage the record of the employee. Each employee will be given with a separate username and password. Problem Definition: The aim of the project is to create an effective software to help the pharmacist to maintain the records of the medicines, handle user details, generate invoice, check and renew validity and provide a scope of communication between users by using inbuilt messaging system. Pharmacy management system deals with the maintenance of drugs and consumables in the pharmacy unit. This pharmacy management system is user friendly. Objectives -> Primary objective •To gain practical experience by modeling a software based on real world problem. •To understand how to work on Front-end (Java) and Back-end (MySQL) by using server(wamp). -> Secondary objective •To develop an application that deals with the day to day requirement of any pharmacy. •To develop the easy management of the medicines (drugs). •To handle the inventory details like sales details, purchase details and stock expiry and quantity. •To provide competitive advantage to the pharmacy. •To provide details information about the stock on details necessary and help locate it in shop easily. •To make the stock manageable and simplify the use of inventory in the pharmacy. Hardware and software tools: The system services and goals are established by consultation with system user. They are then defined in details and serve as a system specification. System requirement are those on which the system runs. ⚙️ Hardware Requirements: o Computer with either Intel Pentium processor or AMD processor. o 1GB+ DDR RAM o 40GB hard disk drive 💻 Software Requirements: o Windows/ MacOS/ Linux operating system. o JRE and JDK. o MySQL server (WAMP or XAMPP or any) Chapter 2 - DESIGN Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. It helps produce database systems: o That meet the requirements of the users o Have high performance. Architecture Description The design of a DBMS depends on its architecture. It can be centralized or decentralized or hierarchical. The architecture of a DBMS can be seen as either single tier or multi-tier. ER Diagram image.png Fig 1: ER Diagram An entity–relationship model describes interrelated things of interest in a specific domain of knowledge (Refer Fig 1). It is composed of entity types and specifies relationships that can exist between instances of those entity types. Relational Schema Diagram image_1.png Fig 2: Relational Schema Relational schema is a collection of meta-data. Database schema describes the structure and constraints of data representing in a particular domain (Refer Fig 2). Chapter 3 - IMPLEMENTATION Description on Implementation The goal of this application is to manage the medicines and various function of the pharmacy. List of modules: o Login page o Home page o Company o Purchase o Drugs o Sales o User/Settings o Messaging Chapter 4 - Result and Discussion By using MySQL commands and its database this website Pharmacy management tends to store all the data received from the users including drugs sales details and the profit made by the owners are all in this data base. This website allows the user to generate invoices for sales, check expiry and quantity remaining of the drugs. It also provides user with options to renew validity and add more drugs into the store and update the database accordingly. By using xampp server these database commands are easily initiated into the database and the ER diagram with relational schema diagrams helps us to make the structure of the database faster and it was easier to make them understand the needs of the website. Login Information id :1 password: admin CONCLUSIONS AND FUTURE SCOPE o Detailed information gathering has to be done. Without that the purpose for using the software won’t be satisfied properly. o However, it can give good profits in the long run. o Implementing the software requires change in the business practices. o Efficient organization of all knowledge is the analysis company and easy analysis access and retrieval of information is possible. o In this project we can also include BAR CODE facility using the bar code reader, which will detect the expiry date and the other information about the related medicines. o Company using this software will always be able to plan in future and always be aware of their financial position in the market. o It leads to ease in functioning of business processes. o The project can be made more robust by including biometric verification. o There is also a scope to expand by implementing newer technologies like cloud etcetera.
zequel-labs / ZequelModern, open-source database management GUI. Query editor, data grid, schema browser, ER diagrams, import/export, SSH tunneling, and more.
jawira / Db DrawPHP library to generate ER database diagrams
vibhorag101 / ECommerce Grocery StoreBuilt an E-Commerce Store website using Flask, MySQL, Python and HTML/CSS. Users can purchase products and give reviews, Sellers can add their inventory, IT-Admin can add Delivery Boy and sellers. Used ER Diagram to formulate all the required entities. Ability to use coupon codes with various conditions was implemented.
Mr-Destructive / Django MermaidGenerate ER Diagram for your Django project in Markdown with Mermaid
ASHUTOSH-SWAIN-GIT / SkyforgeA platform where users can effortlessly design database schemas using ER diagrams(currently down )
ssuljic / Erd DesignerJavascript application for creating ER diagrams, and generating DDL SQL scripts for different DBMS's
qweeze / Pg DiagramA tool to convert postgresql schema to ER diagram
gman-au / Siren.NET EF Migration to Mermaid ER Diagram
tusharad / Sql2erGenerate ER-diagram using SQL file
neverinfamous / D1 ManagerSelf-hosted web app for Cloudflare D1 with visual schema design, ER diagrams, cascade simulator, circular dependency detection, undo/rollback & time-travel history, FTS5 tools, replication controls, analytics, Drizzle ORM integration, scheduled R2 backups, job tracking, webhook automation, and Zero Trust/GitHub SSO.
ryanrozich / Snowflake Dbml GeneratorAutomatically generate DBML files from Snowflake databases for quickly reverse engineer interactive ER diagrams and documentation from your Snowflake DB. Ideal for data engineers and analysts, it supports custom primary key configurations and relationship inference.
beyondcode / Invoker Er Diagram PluginGenerate ER Diagrams in Invoker
k1LoW / Setup TblsGitHub Action for tbls
hrkenshin / OpenGraphJavaScript graph visualization library for workflow, BPM, org charts, UML, ER, network diagrams.
fvitas / ErdesignerQuick and easy creation of beautiful ER Diagrams - https://fvitas.github.io/erdesigner
