Member Avatar for Tanuja

Please help me in developing supemarket management system with VB as front end and Oracle as database.

  • 3 Contributors
  • 4 Replies
  • 102 Views
  • 3 Days Discussion Span
  • Latest Post Latest Post by binoj_daniel

Dani AI

Generated

Short, practical plan for a VB + Oracle supermarket project (built from the thread and 's offer to help with a kick‑start).

Start with scope and architecture. Pick desktop (VB.NET WinForms) for a quick student demo or ASP.NET (VB) for a web demo; both work with Oracle but WinForms is easiest to layout and test. Use a simple 3‑tier design: UI (forms), Business Logic (validation, transactions), Data Access Layer (parameterized DB calls).

Minimal schema and core ideas. Essential tables: Products, Categories, Suppliers, Customers, Employees, Purchases, PurchaseDetails, Sales, SalesDetails, InventoryTransactions (history). Use Oracle SEQUENCEs for numeric keys and FOREIGN KEYs for relations. Keep an InventoryTransactions table so stock history is auditable rather than relying only on a running quantity. Encapsulate multirow operations (sale or purchase) in a single DB transaction and prefer stored procedures/packages for atomicity.

Suggested forms (5–15): Login, Dashboard, Product Master, Supplier Master, Customer Master, Purchase/GRN entry, Sales/POS entry, Inventory/Stock, Simple Reports (daily sales, low stock). Typical sale workflow: search product → verify qty → begin transaction → insert Sales and SalesDetails → insert InventoryTransactions → update Products.qty_on_hand → commit. Use SELECT ... FOR UPDATE or optimistic checks to prevent race conditions in concurrent use.

Connectivity and practical tips. Prefer Oracle Data Provider for .NET (ODP.NET) for production; use parameterized commands, explicit transactions, and proper exception handling with rollback. Example EZConnect style connection string:

User Id=MYUSER;Password=MyPass;Data Source=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=host)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL)));

Common pitfalls: forgetting commit/rollback, floating‑point rounding on prices (use DECIMAL/NUMBER with scale), missing indexes on FK/search columns, and SQL injection from string concatenation. Milestones: draft requirements → DDL and sequences → implement DAL → Product Master CRUD → Purchase → Sales/POS → Reports. offered to help with DB schema or WinForms layout; that is the logical next step.

Recommended Answers

All 4 Replies

Member Avatar for binoj_daniel

What help do you need?

Member Avatar for Tanuja

I want project in which front end is VB. 5-15 forms must be coded. I'm too confused regarding to connectivity,options in forms and other things. So if anyone can help me in getting project or guideline then plz reply me. Topic for project is Supermarket

Member Avatar for Rashakil Fol

Try make use brain.

Member Avatar for binoj_daniel

I can give you a kick start if thats what you are expecting? Do you need help in laying out the DB schema or thje winforms?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.