Description
2.1 Relational Structure
- Relational data model
- Relational database concepts
- Tables, relations, tuples
- What is a tuple in DBMS
- Attributes and domains in DBMS
- Relational schema and instance
- What is a relation in a database
2.2 Keys
- Types of keys in DBMS
- Super key vs candidate key
- Primary key definition
- Foreign key explained
- Primary key vs foreign key
- Composite key
- Alternate key
2.3 Data Constraints
- Data integrity constraints in DBMS
- Domain constraints
- Referential integrity constraint
- Entity integrity constraint
- Database constraints
- SQL constraints (related but highly searched)
2.4 Entity Relationship Model
- ER model
- ER diagram symbols
- ER diagram tutorial
- Strong and weak entity sets
- Types of attributes in ER model (simple, composite, multivalued, derived)
- Cardinality in ER diagrams
- Relationship types in ER model (one-to-one, one-to-many, etc.)
2.5 Normalization
- What is normalization in DBMS
- Database normalization explained
- Functional dependencies
- Normal forms
- 1NF, 2NF, 3NF explained with examples
- BCNF (Boyce-Codd Normal Form) (often searched with 1NF, 2NF, 3NF)
- Data redundancy
- Anomalies in database (insertion, deletion, update anomalies)
Reviews
There are no reviews yet.