schema modeling techniques skip headers the following topics provide information about schemas in a data warehouse schemas in data warehouses a schema is a collection of database objects including tables views indexes and synonyms there is a variety of ways of arranging schema objects in the purpose of normalization normalization is the process of structuring and handling the relationship between data to minimize redundancy in the relational table and avoid the unnecessary anomalies properties from the database like insertion update and delete it helps to divide large database tables family tree you may have seen photos of some of your female ancestors wearing a piece of camphor glass jewelry or you might have inherited a piece but did you know about this once very popular style of jewelry camphor glass is clear glass that has been treated with hydrofluoric acid vapors to