Please enable JavaScript.
Coggle requires JavaScript to display documents.
Relational Modeling - Coggle Diagram
Relational Modeling
Key Terms
Attribute
Relation
Table
Row
Column
Relation Schema
Degree
Attributes in a relationship
Cardinality
Rows in a relationship
ACID
Atomicity
what is a complete transaction
Consistency
maintain data correctness after transaction
Isolation
read data only after commit
Durability
ensure changes become permanent
Best Practices
Data represented in as a collection of relations
Cells should hold a single value
No rows can be identical
values of attributes should be of the same domain
Constraints
Domain Constraints
Key Constraints
Referential Constraints
Relational Model (RM) represents the database as a collection of relations.