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.
Komlika_1 0 Newbie Poster
tinstaafl 1,176 Posting Maven
Dani 4,329 The Queen of DaniWeb Administrator Featured Poster Premium Member
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?
john_111 88 Junior Poster in Training
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.