Database Reference
In-Depth Information
COMPANY
CompanyName
City
Country
Volume
PHONE
CompanyName
PhoneNumber
Figure 5-25
Data Model for the Form
with a Multivalued Attribute
in Figure 5-24
Figure 5-26
Data Entry Form with
Separate Multivalued
Attributes
COMPANY
CompanyName
City
Country
Volume
PHONE
CompanyName
PhoneNumber
CONTACT
CompanyName
Contact
Figure 5-27
Data Model for the Form
with Separate Multivalued
Attributes in Figure 5-26
We can extend this strategy for as many multivalued attributes as necessary. The
COMPANY data entry form in Figure 5-26 has multivalued Phone and multivalued Contact
attributes. In this case, we just create a separate ID-dependent entity for each multivalued
attribute, as shown in Figure 5-27.
In Figure 5-27, PhoneNumber and Contact are independent. PhoneNumber is the phone
number of the company and not necessarily the phone number of a contact. If PhoneNumber
Search WWH ::
Custom Search