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
Recommended Answers
Jump to PostConsider the following tutorials:
All 3 Replies
tinstaafl
1,176
Posting Maven
Dani
4,084
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.