Page 1 of 1

how to develop Inventory System

Posted: Fri Dec 04, 2009 1:31 am
by myasirm
hi guys
i want to create a simple inventory system just for practice of php programing but i have no idea for inventory system so kindly help me how i start and which type of data base tables required and some forms details

thanks waiting for ur replies

Re: how to develop Inventory System

Posted: Fri Dec 04, 2009 2:20 am
by Weiry
The first system that comes to mind would be a video rental store.
You would need tables for customers, videos and rentedVideos (at minimum)

The Video table would need these details:
  • videoID, title, description, RRP, rentalCost, hiredOut, rentedID
(some video stores actually sell videos too, hence why the RRP)

The RentedVideos table would need:
  • rentedID, customerID, videoID, hiredDate, returnDate
The Customer table would need:
  • customerID, firstName, lastName, addressID, maximumRentals, creditDebit, banned
(creditDebit being if a customer is owed money or is required to pay money (- or +))
(banned being if the customer is still allowed to borrow videos)
(address could be optional if you want, it doesn't really affect the system)

The Address table would need:
  • addressID, address, suburb, city, postcode