Erstellt von Tramaine Wanzo
vor fast 7 Jahre
|
||
Subtype
Supertype
Attribute Inheritance
Relationship Inheritance
Total Specialization Rule
Partial Specialization Rule
Disjoint Rule
Overlap Rule
Generalization
Specialization
Subtype Discriminations
Disjoint
Overlapping
Entity
Strong entity
Weak entity
Relationship
Degree of a relationship
Unary relationship
Binary relationship
Ternary relationship
cardinality constraints of a relationship
minimum cardinality
maximum cardinality
associative entity
Ternary relationships
attribute
Optional attribute
Multivalued attribute
Composite attribute
Derived attribute
Identifier
Logically
Metadata
DBMS, Database Management System
The five phases of database development is:
An Entity-relationship Model (E-R model)
primary key
Foreign key
Domain Constraints
Entity integrity
Referential integrity
one-to-many relationship
(Map Binary Relationships to Relations)
Many-to-Many relationship
(Map Binary Relationships to Relations)
One-to-one relationship
(Map Binary Relationships to relations)
Referential Integrity constraint