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
how to develop Inventory System
Moderator: General Moderators
Re: how to develop Inventory System
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:
The RentedVideos table would need:
(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:
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
The RentedVideos table would need:
- rentedID, customerID, videoID, hiredDate, returnDate
- customerID, firstName, lastName, addressID, maximumRentals, creditDebit, banned
(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