Entity Relationship model (conceptual model)
|
Available relations (logical model)
- hotel{hname, type, categorie, fax, description, street, nr, zip, city}
- hotelphoto{hname, photo}
- room_type{hname, ztype, count, price, photo, description}
- room{hname, ztype, znr, modem}
- interior{aname}
- hotel_int{aname}
- room_int{aname}
- person{pfirst, plast, telephone, mail}
- guest{pfirst, plast, rebate}
- bill{rnr, date, sum, payment, paid, hname, znr, ztype, pfirst, plast, start, end}
- address{street, nr, zip, city}
- hotel_has{hname, aname, price}
- room_type_has{hname, ztype, aname}
- live{pfirst, plast, street, nr, zip, city}
- book{hname, ztype, pfirst, plast, start, end}
|
