Explore Relational Database Component (Part 1)
Thursday, February 13, 2014 • 12:48:00 AM • 0 comments
Assalamualaikum
Conceptual : an object about which data is collected it may be a person, place, event, actual physical object, or simply a concept.
Business Rule : a policy, procedure or a standart that an organization uses and which diabetes certain controls on the data, often implemented in database as constraints.
Relationships :
- maximum cardinality : the maximum number of instances one entity can be associated with.
- minimum : the minimum number of instances one entity can be associated with
- transferable ; a relationship is transferable if the parent may change over time.
One-To-One :
- conditional in one direction : means that a corresponding record may or not be found in the optional side of the relationship
- condition in both directions : means that corresponding records may or not be found on both sides of relationship
- mandatory in one direction : that corresponding records must be found on both sides of the relationship
One-To-Many :
- indicates that a record in one table may be related to many (usually 0 +) record in one table.
Many-To-Many :
- not natively supported in relational databases, but there are way to convert them into sending that can be handled
Intersection:
- two related entities in a many-to-many relationship in which inly makes sense when associated with both related entities, intersection data can be placed (mapped) into a separate table to help relational databases handle into relationship
Recursive :
- refers to relationship between instance of the same ensity type.
Ina, The Shining Star
Disclaimer
Hi, im Ina. Steal anything what u can steal :D.
Taggie Board
» Kindly no advertisement
» Harsh word not allowed :)
Back to past
Credits
» Template : Aulia Septiya
» Edited/Picture : Me
» Helped : Ayem, AskarrPink, Ziera
» Header & Cursor : Ziera
» Background : Qihah
» Font : Google
» Best view in Google Chrome
