Home
Discuss the difference between a composite key and a composite attribute.How would each be indicated in an ERD? |
[Improve]
Attribute is the property of entity.The composite attribute is like address(where street no,house no,town name all include).Composite key is also an attribute,but only which attribute are work as a unique identifier.
Example:> In an ERD if vendor placed with orders then
order(order day, order number)
vendor(vendor code,vendor address)
Here, order and vendor both are entity and order number,
vendor code both are Composite key(because those are
unique)but vendor address is a Composite attribute and order day(may be not unique)is an attribute only.
So, we can conclude that all attribute not Composite key.
First answer by ID3411169125. Last edit by Suman680. Contributor trust: 0 [recommend contributor]. Question popularity: 2 [recommend question].
Answers.com > Wiki Answers > Categories > Technology > Computers > Computer Programming > Database Programming > Discuss the difference between a composite key and a composite attribute.How would each be indicated in an ERD?
Our contributors said this page should be displayed for the questions below. (Where do these come from ) |
| If any of these are not a genuine rephrasing of the question, please help out and edit these alternates. |
Composite key in oracle? What is a composite key in DBMS? Difference between key and composit key? Difference between composite and primary key? How would a composite key be indicated in an ERD? What two attributes must be contained in the composite key? What is the difference between a composite key and composite attribute? What is the difference between composite key and a composite attribute? Discuss the difference between a composite key and a composite attribute? Discuss the difference between a composite key and a composite attributehow would each be indicated in ERD?
