Use an ER Diagramming tool such as a Lucid Chart or handwriting, to create an ER model for the following scenario.

Scenario: The Choice Hotels International has asked you to design a database that will keep track of the Guest, motel location, rooms, and reservations made by the guest.

Entities and attributes:

GUEST: The guest entity holds all information about the guest. It must store the guest$\_$Name, guest$\_$ID$,$ mobileNumber, and physical$\_$address.

ROOM: The room entity holds all about the room. It must store the room$\_$Number, room$\_$Type $($single king, single queen, double queen, etc.$),$ price, and amenities.

LOCATION: The LOCATION entity holds all information about the physical address where the rooms are available. It must store the location$\_$ID$,$ landmark, and physical$\_$address.

MEMBERSHIP: The membership entity holds the information about the membership of guests. It must store the Membership$\_$ID$,$ Membership$\_$Type, StartDate, and EndDate.

RIDES: The Rides entity holds the information about the rides a guest books from the Airport or bus station. It must store the Ride$\_$ID$,$ Customer$\_$ID$,$ PickupLocation, DropOffLocation, PickupTime, and DropOffTime.

Relationships:

Each guest can reserve zero or many rooms, and rooms can be reserved by zero or many guests $($reserved by many guests on different dates$).$

Each location may have zero or many rooms, but each room belongs to only one location.

Each guest can have one membership, and each membership is linked to only one guest.

Each guest can take multiple rides, but each ride is associated with only one guest.

Notes:

Please identify the primary and foreign keys in the entities.

Please check the rubrics before turning in this assignment.

Differentiate strong and weak relationships in the ER diagram using the appropriate representation.

For all addresses, in this assignment and future assignments, use the following format unless specifically indicated otherwise:

address$\_$line$\_1$

address$\_$line$\_2$

City

state$\_$or$\_$region

postal code

country

You must use Northwest Online to turn this assignment in via upload.

To Submit:

Download the Lucid Chart file as an image file $($either $.$jpeg or $.$png$)$ or take a photo of your handwriting.

Rename the file as your Lastname$\_$Assignment$01.$png $($where LastName is your LastName$)$ and submit the renamed image file.