Question

The database is to handle the bookings in a company that arranges one-day guided group tours from the different hotels in a resort town to various destinations. Specific details are:

1. Every hotel is described by: A unique hotel name, address, and phone number.
2. Every destination is described by: A unique destination name, and type.
3. Every guide is described by: A unique guide id, name, and all the languages that he/she speaks.
4. Every tour is described by: A date, number of passengers, and start time.
5. A tour is served by one guide only who, of course, may have served several tours over time
6. A tour involves residents from one hotel only, visits one destination only, and is done from start to finish within one day.
7. Several tours per day may start from a hotel to different destinations. However, no two tours will start from the same hotel to the same destination on the same day. Of course, there may be several tours from different hotels to the same destination on the same day.
8. Every tour, occurring on a particular day, has one guide assigned to it.
9. The database must also record the distance from every hotel to every destination.

6 of the below are correct circle them

1. The ER will have 2 regular entities and 2 weak entities.
	2.	The ER will have an M:N regular relationship that has no attribute associated with it.
	3.	The ER will have 2 identifying relationships.
	4.	The ER will have an 1:1 regular relationship.
	5.	The ER will have 3 regular entities and one weak entity.
	6.	The ER will have an 1:N regular relationship.
	7.	The ER will have an M:N regular relationship that has an attribute associated with it.
	8.	The ER will have one multi-valued attribute.
	9.	The ER will have a weak entity that has two owner entities.
	10.	The ER will have 4 regular entities.
	11.	The ER will have an M:N identifying relationship.
	12.	The ER will have a weak entity that has only one owner entity.
	13.	The ER will have 2 multi-valued attributes.

Answer 1

correct statements are,

3, 6, 7, 8,10, 13

1. The ER will have 2 regular entities and 2 weak entities.

2.	The ER will have an M:N regular relationship that has no attribute associated with it.
	3.	The ER will have 2 identifying relationships.
	4.	The ER will have an 1:1 regular relationship.
	5.	The ER will have 3 regular entities and one weak entity.
	6.	The ER will have an 1:N regular relationship.
	7.	The ER will have an M:N regular relationship that has an attribute associated with it.
	8.	The ER will have one multi-valued attribute.
	9.	The ER will have a weak entity that has two owner entities.
	10.	The ER will have 4 regular entities.
	11.	The ER will have an M:N identifying relationship.
	12.	The ER will have a weak entity that has only one owner entity.
	13.	The ER will have 2 multi-valued attributes.