This video goes over the various aspects of an orphanage database system, from the conceptual model (ER Diagram and entities) to the logical table derivation to the SQL implementation.
Note: This database implementation is a final project for a database course.