The story
From the resemblance to a star shape with a fact table at its center.
Etymology from Wiktionary, CC BY-SA 4.0.
star schema
Today it means: A denormalized database schema consisting of one or more fact tables referencing any number of dimension tables. Full definition →