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...
ER Design Projects
Guided ER designs for college, hospital, banking, library and e-commerce databases.
5 notes
Notes
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...