Which of the following is necessarily true about the City and State entity sets

Question

Which of the following is necessarily true about the City and State entity sets and their relationship In? Explain your answer.

1. Which of the following is necessarily true about the City and State entity sets and their relationship In? Explain your answer. (15 points) a. Each City can be In at most one State. b. No two Cities In the same State can have the same name. c. No two States can have governors with the same name. d. No two cities can have the same name. e. Two Cities with the same name cannot be In two different States. name naimc mayor governo Cities InStates

Explanation / Answer

a.) True.

As the cities entity is a weak entity but consists of name as the primary key and hence , there can be only one city in one state or can be in none.

b.) True.

As the cities name consists of the primary key then the values must be unique and hence, repeating names cannot be done here.

c.) False.

As governor consists of no primary key. Hence, there can be governors with the same name.

d.) False.

As cities is an weak entity it can consist of repeating values and making the cities as primary key can make the statement true.

e.) Fales.

As cities is an weak entity an hence, there can be two cities with same name without but in two different states..,

Rate an upvote.....THankyou

Hope this helps.....

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.