Star schema

Star schema is a way to organize information in a database. A star schema is made up of a few different parts: a central table with information in it, and several "satellite" tables that have more detailed information about the items in the central table. For example, say you have a table of customers with information like their name, email address, and phone number. You could also have satellite tables with more detailed information about each customer, like their address, how much money they spend each month, and when they last ordered something. With a star schema, it's easier to find and use the information that you need.