This assignment explores the concepts of database normalization and design. It begins by illustrating functional dependencies through a dependency diagram and then proceeds to decompose relations into third normal form. The assignment further defines a relational schema with referential integrity constraints and presents an Entity Relation Diagram. Finally, it provides references for further study on database technology.