titancompu
New member
- Local time
- Today, 01:16
- Joined
- Apr 27, 2007
- Messages
- 1
I'm working on implementation of a database as a final. My database looks something like the following:
Customers ------------------------- Vehicles
-
-
-
Reservation
-
-
-
Room ------------- Room_Amenities (Associative) ------------ Amenities
My instructor specifically made me create the associative table with multiple amenities assigned to each room. For example room one might have C for coffee machine, and V vibe bed. Each amenity has a price. I need to create a tabular form that displays the Customer info from the customer table, and in a seperate tab, shows their room number and amenities. Is this even feasible?
Customers ------------------------- Vehicles
-
-
-
Reservation
-
-
-
Room ------------- Room_Amenities (Associative) ------------ Amenities
My instructor specifically made me create the associative table with multiple amenities assigned to each room. For example room one might have C for coffee machine, and V vibe bed. Each amenity has a price. I need to create a tabular form that displays the Customer info from the customer table, and in a seperate tab, shows their room number and amenities. Is this even feasible?