Final Logical Database Design

$1.$ Guest

o guest$\_$id $($PK$)$

o name

o email

o phone$\_$number

o address

$2.$ Room

o room$\_$id $($PK$)$

o room$\_$type

o capacity

o price

o description

o view

$3.$ Reservation

o reservation$\_$id $($PK$)$

o guest$\_$id $($FK$)$

o room$\_$id $($FK$)$

o reservation$\_$date

o check$\_$in$\_$date

o check$\_$out$\_$date

o status

$4.$ Amenity

o amenity$\_$id $($PK$)$

o amenity$\_$name

o description

$5.$ Service

o service$\_$id $($PK$)$

o service$\_$name

o cost

o description

$6.$ Room$\_$Amenity

o room$\_$id $($PK$,$ FK$)$

o amenity$\_$id $($PK$,$ FK$)$

$7.$ Reservation$\_$Service

o reservation$\_$id $($PK$,$ FK$)$

o service$\_$id $($PK$,$ FK$)$rethink your logical schema and transform it from an OLTP type of schema to an OLAP type of schema based on a dimensional data model. Next, you will need to add a temporal property to your data model, which means you must decide how to incorporate the notion of time