Question :: Composite Vs. Multi Valued Attributes
Answer:
Composite :
Composite attributes can be divided into subparts. For example, an attribute name
could be structured as a composite attribute consisting of first-name, middle-initial,
and last-name.
Multivalued:
There may be instances where an attribute has a set of values for a specific
entity. Consider an employee entity set with the attribute phone-number. An
employee may have zero, one, or several phone numbers, and different employees
may have different numbers of phones. This type of attribute is said to be
Composite Attributes : Attribute Divided into sub parts. Eg. Name (First name,
Middle Name, last name)
Multivalued Attributes : Attribute having more than one values. Eg. Phone
Number.
Is it possible for an attribute to be both composite and multivalued?
ReplyDeleteI guess, but that's not really important. Ultimately, multi-valued attributes become a weak entity and then a table with a foreign key relation to the original entity.
DeleteYes, but you have to decide that if its sub-parts more than 3 or 4 than consider as "Multi-valued" attribute or if their sub-parts are 3 or 4 then use it as "Composite" attribute.
DeleteYes this is possible.
DeleteLike email- it is both multivalued and composite
I guess ye it is possible... As for example when we think of an address then it can be a multivalued as it can be contact address, current or a permanent address and it can be composite too as it me made up of different entities...example postal address, lane number, street name, reference point, house number, etc.
DeleteSo in my view an attribute can be both multivalued and composite as well.
Thanks a lot, that's most helpful
ReplyDeleteI "Address" a composite attribute or multi valued attribute?
ReplyDeletef you see in the link below it can be both, i am confused too :/
Deletehttp://users.cms.caltech.edu/~donnie/dbcourse/intro0607/lectures/Lecture17.pdf
This comment has been removed by the author.
ReplyDeleteThanks A Lot !!!
ReplyDeleteit is multi valued attribute
ReplyDeletePhone number is it composite or multivalued
ReplyDeleteI believe Phone Numbers and Addresses are both composite and multi-valued. Phone numbers are composite because the first three numbers of your phone number are the area code, the next three numbers are the exchange code, and the last four are the subscriber line code, a.k.a you. It is also multi-valued because you can have multiple phone numbers.
Deletephone number is simple attribute
DeleteThank you for beautiful answer which helps to clear the confusion
ReplyDelete21st century educational leadership should be equipped to deal with the myriad changes bombarding the educational arena. As technology, culture, politics, economy, and social factors continue to modify the educational environment, academic-qualification should no longer be the measuring stick by which leaders are prepared. The need to develop adaptive-competent qualified leaders becomes necessary. acim blog
ReplyDeleteIf essay writing is your passion then one thing which bothers you is to make it readable. Once you sit to write you keep on writing to maintain the flow. But once you are finished you want to check whether it is presentable or not. everything you need to know about notebook printing
ReplyDeleteFree Plagiarism Remover Site
ReplyDeleteYes thank you
ReplyDeleteEducating the best and the brightest in this brave new world will take a new and improved educational paradigm. Allowing our educational tools to age in the corner of the classroom will be the mistake that may cost us our future. Throwing away masses of children to inequitable access will ensure that we languish at the bottom of the global pool of employable workers for decades to come. authors a course in miracles
ReplyDeletehi please visit for breaking and tech news about world
ReplyDelete