data model for a hotel

(i have the diagram in the attachment . )

IST-7000 Data Management - Week 1 – Databasesearch Assignment – Data Development Team

Name:______________________________

Please review the attached data model and answer the following questions.

Please provide all associated links and references:

1. Please provide definitions of each of the following components:

a. Entities: List a minimum of 5 entities

b. Attributes: List ALL attributes of at least 2 entities

c. Relationships - List relationships based on the following requirements:

i. List a minimum of four relationships. Choose at least one example of one-to-many, one example of one-to-one and one example of many-to-many.

ii. Provide the minimum and maximum cardinality

iii. Define the relationship type (one-to-many, one-to-one, many-to-many)

d. Primary keys: List ALL primary keys in the diagram.

Identify each of the components from the data model above:

2. Review data models at the attached website (see resources [url removed, login to view]). Select a basic data model from this website. Provide a graphic of the data model and identify the following information:

a. Entities: List a minimum of 3 entities

b. Attributes: List ALL attributes of at least 2 entities

c. Relationships - List relationships based on the following requirements:

i. List a minimum of two relationships.

ii. Provide the minimum and maximum cardinality

iii. Define the relationship type (one-to-many, one-to-one, many-to-many)

d. Primary keys: List ALL primary keys in the diagram.

3. Provide three advantages/reasons to develop a data model.

Microsoft Office

Project ID: #8039244

About the project