I have this idea which I need some help with. Currently I am developing a mysql database with a java interface. It is a hotel management system, and for billing purpose. I have the following tables.
Bill (BillID, ResvID, IssueDate, ToTalBill, ChargedTo)
Employee (EmpID, Name, Age, Nationality, NatId, Mobile, Telephone, Email, Position, Language, Salary, JoinDate)
as per the requirements, the ID number of the employee (UserID or EmpID) should be printed on the bill.
Any suggestions or ideas about implementing this ?Thanks,
You have no direct link between the bill and the employee.
There is a ResvID, which I'm guessing is a reservation ID - does that link to a table that has a link to employee?In fact which employee should it use? The one who made the reservation, the one who confirmed it, the one who checked in the guest, the one who printed the bill? You need more information.
answered Jan 04 '12 at 02:27 AM
Kev Riley ♦♦