ENHANCE ENTITY RELATIOSHIP DIAGRAMThe entity type PERSON has the following attributes: SSN, name, address (City/State/Zip), date of birth, age, and contact number. The entity also has the three subtypes: CAMPER, BIKER, AND RUNNER. Draw a separate diagram segment for each of the following situations: 1. At a given time, a person must be exactly one of three subtypes.2. A person may or may not be one of these subtypes. However, a person who is one of these subtypes cannot at the same time be one of the other subtypes.3. A person may or may not be the one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time. 4. At a given time, a person must be at least one of these subtypes. The entity type PERSON has the following attributes: SSN,name, address (City/ state/ Zip), date of birth, age andcontact number. The entity also has the three subtypes :CAMPER, BIKER, and RUNNER. Draw a separate diagram segmentfor each of the following situations:1. At a given time, a person must be exactly one of thesesubtypes2. A person may or may not be one of these subtypes.However, a person who is one of these subtypes cannot atthe same time be one of the other subtypes3. A person may or may not be one of these subtypes. Onthe other hand, a person may be any two (or even three)of these subtypes at the same time.4. At a given time, a person must beat least one of these subtypes.PRACTICEEXERCISE

Note: As you have asked a multipart question, as per our policy, we will solve the first three parts…

Answered: ENHANCE ENTITY RELATIOSHIP DIAGRAM The…

Computer Networking: A Top-Down Approach (7th Edition)

7th Edition

ISBN:9780133594140

Author:James Kurose, Keith Ross

Publisher:James Kurose, Keith Ross

Chapter1: Computer Networks And The Internet

Section: Chapter Questions

Problem R1RQ: What is the difference between a host and an end system? List several different types of end...

See similar textbooks

Related questions

Question

ENHANCE ENTITY RELATIOSHIP DIAGRAM

The entity type PERSON has the following attributes: SSN, name, address (City/State/Zip), date of birth, age, and contact number. The entity also has the three subtypes: CAMPER, BIKER, AND RUNNER. Draw a separate diagram segment for each of the following situations:

1. At a given time, a person must be exactly one of three subtypes.

2. A person may or may not be one of these subtypes. However, a person who is one of these subtypes cannot at the same time be one of the other subtypes.

3. A person may or may not be the one of these subtypes. On the other hand, a person may be any two (or even three) of these subtypes at the same time.

4. At a given time, a person must be at least one of these subtypes.