Page 77 - CITS - Computer Software Application -TT

COMPUTER SOFTWARE APPLICATION - CITS

Database Schema Designs

Creating a schema design constitutes the initial phase in establishing a solid groundwork for data administration.
Inefficient schema designs prove challenging to oversee and result in heightened memory consumption and
resource utilization. The logical course of action is contingent upon the demands of the business. Opting for
the appropriate database schema design is essential to simplify the project lifecycle. Presented herewith is an
assortment of well-known database schema designs.
1 Flat Model
2 Hierarchical Model
3 Network Model
4 Relational Model

5 Star Schema
6 Snowflake Schema
1 Flat Model
A flat model schema embodies a 2-dimensional array where each column holds identical data types, and items
within a row possess interrelatedness. It can be likened to a solitary spreadsheet or a database table devoid
of interconnections. This schema structure proves optimal for modest applications devoid of intricate data
structures.

64

CITS : IT&ITES - Computer software application - Lesson 18 - 36