I am beginner in php, finished learning PHP with MySQL course. I want to start with making a live project. I want to make a Hotel management application/software for one of my friend's hotel at my place, for free of cost. I have noted down all the maximum possible information about the hotel and present ongoing manual process, including, number of room, number of floors, different rooms with different facilities and cost of the rooms based on the facilities provided, room vacancies status [presently maintained in a book]etc,. Now my big question is, how do i design/convert this real time problem/scenario in to a php application. How many tables should i take or for what data i have to take tables in database. And coming to coding part, where do i start, do i have to use classes or anything else. I need the flow of software design, including the database design also. Please any experts please guide me. Thanks a lot in advance.