Database design process

Abstract Database Systems has an ideal practical approach to provide a solid foundation for good database design techniques. Database design is more about art than science. Properly designed databases should follow regular forms and relationship models, but you need to come up with a design that reflects the business you are trying to model. This article describes the design process of the database project. One important thing to remember when completing the design process is that the level of structural integrity and data integrity is directly proportional to the integrity of the design process.

Some principles guide the database design process. The first principle is that duplicate information (also called redundant data) wastes space and is more likely to cause errors and inconsistencies, which is not good. The second principle is that the accuracy and completeness of information is important. If the database contains incorrect information, the report extracting information from the database also contains incorrect information. Therefore, the decisions you make based on these reports will be misunderstood.

Database design is the process of generating a detailed data model of the database. This data model contains all the necessary logical and physical design choices and physical storage parameters necessary to generate the design in the data definition language and can be used to create a database . The full attribute data model contains detailed properties for each entity. The term database design can be used to describe various parts of the overall database system design. In principle, and most accurately, it can be thought of as the logical design of the underlying data structure used to store the data. In the relational model, these are tables and views. In the object database, entities and relationships are mapped directly to object classes and naming relationships.

In designing the logical and physical structure of the database, the contractor must consider the impact on the database of the selected architecture (and vice versa) and confirm that the database design is consistent with the architecture Yes. The design of the database is a part of each design review, the level of detail determined by the maturity of the design work at that time. The contractor shall submit the database design document (DID - MISC - xxxx) to the government. A preliminary version of this document will be posted on the (first) PDR and the final version of this document should be posted on the (first) CDR