i am making the hotel reservation system database.cosidering the following
customer(name,phone,address,city,creditcard no,etc)
reservation(check in date, check out date, price, customer name, no of rooms)
room (room no,room type, price)'
but i am not satisfied with it.i have to keep record of hall and table reservation as well .
i want to differentiate b/w resident customer and non resident customer .
plz any one guide me to build the complete ERD for my database i will be very thankful
plz help me as i have just started database