DBMS
Drawing and Reading ER Diagrams
A complete guide to ER notation and a repeatable eight step method for turning a written requirement into a correct, readable ER diagram.
DBMS
A complete DBMS path: database fundamentals, architecture, data models, the ER model, the relational model, relational algebra, functional dependencies, normalisation, transactions, concurrency control, recovery, storage, indexing, query processing, distributed databases, NoSQL, security, administration, performance and exam preparation.
59 notes in 21 topics
Topics in DBMS
DBMS Fundamentals 9
Database Architecture 4
Data Models 5
ER Model 9
ER Design Projects 5
Relational Model 6
Relational Algebra 6
Functional Dependencies 5
Normalisation 9
Transactions 0
Concurrency Control 1
Recovery 0
Storage and File Organisation 0
Indexing 0
Query Processing 0
Distributed Databases 0
NoSQL and Modern Databases 0
Database Security 0
Database Administration 0
Database Performance 0
Practice and Exams 0
Notes
DBMS
Extended ER: Generalisation, Specialisation and Aggregation
The extended ER model adds inheritance to ER. Specialisation splits an entity into subclasses, generalisation combines subclasses into a superclass, a...
DBMS
Converting an ER Diagram into Relational Tables
Seven rules turn any ER diagram into a relational schema: entities become tables, one to many puts a foreign key on the many side, many to many become...
DBMS
ER Design Project: College Database
A complete college database designed from a written requirement: entities, attributes, relationships, cardinality, participation, the ER diagram and t...
DBMS
ER Design Project: Hospital Database
A hospital database designed end to end, including a weak entity for prescription lines, a ternary relationship for treatment, and the privacy decisio...
DBMS
ER Design Project: Banking System
A banking database with a generalisation hierarchy for account types, a many to many customer to account relationship, and a transaction model that ne...
DBMS
ER Design Project: Library System
A library database that separates a title from a physical copy, models issue and return correctly, and shows why the obvious single book table quietly...
DBMS
ER Design Project: E-commerce System
An e-commerce database covering customers, products, carts, orders and payments, including why an order line must copy the price it was sold at rather...
DBMS
Relations, Tuples, Attributes and Domains
The relational model has exactly four structural terms. A relation is a set of tuples, a tuple is one fact, an attribute is a named column and a domai...
DBMS
Relation Schema and Relation Instance
A relation schema is the fixed definition of a relation; a relation instance is the set of tuples in it right now. A relational database schema is the...
DBMS
Keys in the Relational Model
Super key, candidate key, primary key, alternate key, composite key, foreign key and surrogate key, defined formally with a worked method for finding...
DBMS
Entity, Referential and Domain Integrity
The three integrity rules of the relational model: a primary key may not be null, a foreign key must match an existing primary key or be null, and eve...