Consider the following database
Room (room_no,room_name,room_type,charges)
Guest(Guest_code, Gname,city)
The relationship is as follows: Room-Guest: one-to-one. room_type can have values as either ‘AC’ or
‘NonAC’.
Q 2) A Create the above database in PostGreSQL and insert sufficient records.

Creating the database on your database server isn't something we can do for you via a message forum. That's like saying, "Install this app on my phone." I can't exactly do it without physical access to your phone, of course. Do you have a specific question about how to do it?

I'll give you a clue - there is at least one table missing from the spec depending on the business rules used, and they want you to work that out and add it/them as well.
Think normalisation.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.