![]() ![]() ![]() Normalization procedures include 1NF (first normal form), 2NF, 3NF, etc.ġNF: Eliminate repeating groups of attributes into entities and implement a primary key for each entity. This is performed by creating relationships among tables through primary and foreign keys. Normalization is the process of reducing data redundancy while maintaining data integrity. ![]() This model carries the actual design blueprint for the database implementation by DBA and database developers. This model describes schema details, columns, data types, constraints, triggers, indexes, replicas, and backup strategy. This is the final stage of a data model which not only relates to a specific database management system, but also states the operating system, storage strategy, data security, and hardware. In addition to entity names and entity relationships, the model defines attributes, primary keys, and foreign keys in each entity. It is a staging model and it can be both user- and system-oriented. This model is used for the implementation of the database management system and it focus on the logical structure of the data. It defines entity names and entity relationships but does not focus on technical problems, computer systems, or database management systems. This model is used to describe the conceptual structure of the business data strategy in the initial stage of design. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |