- NoSQL
- Not based on SQL or relational design theory
- Design supports for fast transactions
- Relational Databases (RDB)
- RDB terminology
- Rows – tuples
- Columns – attributes/properties
- Tables – relations/entities/objects
- Views and results
- Relationship
- Primary key – Key in the current table. Each table has a unique primary key.
- Foreign key – ID in the other table that we may use in our query to bring the table together.
- Join – we can join tables together by having the foreign key in the current table that matches the primary key in another table to bring them together.
- Normalization
- Process for evaluation and correcting structures
- Determines the best assignments of attributes to entities
- What properties/entities should be in the table
- Works through a series of stages called Normal Forms (NF)
- 1NF à 2NF à 3NF à 4NF (optional)
- Higher the normal form (closer to 4NF)
- Slower reads
- Faster writes
- Process for evaluation and correcting structures
- RDB terminology
1 Comment
AWS Database Design – Techyul · January 24, 2022 at 10:38 pm
[…] Database […]