ECSL database design

A full relational database design exercise for a fictional "Electronic Corporation of Sri Lanka," built the way a real schema gets built rather than sketched: an ER diagram first, functional dependencies worked out explicitly, then normalized tables derived from them rather than guessed at. SQL DDL carried real integrity constraints, not just column types, and the brief required more than 20 queries against the finished schema, enough to actually exercise joins, aggregates, and constraint behavior rather than proving the tables merely existed.

It's pure database-design coursework, no application layer on top, and deliberately so: the module wanted the modeling discipline isolated from any UI or business-logic work that might paper over a weak schema underneath. A useful foundation for every database-backed project that came after it in the degree.