The importance of the data design and modeling phase to the development of any database?

Explain the importance of the data design and modeling phase to the development of any database?

?A database is a set of related data processed by a computer. The term "database" has two different meanings: the first is data stored on a computer and related by certain characteristics; the second meaning is a computer program designed to manage this data. The software used to create, store, and process databases is called a database management system (DBMS). One of the most widely used DBMS is Microsoft Access, and the main reason for its popularity is that this system is part of the Microsoft Office suite of programs. However, this DBMS is only suitable for organizing not very large DBs, consisting of tens or hundreds of thousands of records, and it is not used by a very large number of users. The following data organization models (DB types) are distinguished according to the way in which the data is combined into a whole: hierarchical model; network model; relational model; object model.

Hierarchical model is such a DB in which entities of the subject area form a hierarchical structure (tree). A network model creates relationships between independent data elements. In such a model, each record can have relationships with any other records stored in the database.

The object model uses objects that are characterized not only by attributes that define their properties, but also by sets of actions applied to them. Recently, perhaps the most popular databases in which data is organized according to the relational model are relational databases.

?The main goal of database design is to create complete, as normal as possible, non-redundant and conceptually, logically and physically non-contradictory database models. The result of DB design is a logical database structure implemented in the chosen relational database management system (e.g. M Access, MySQL, etc.).

?The creation of a database begins with the creation of an information model of the environment in which the initial data are collected and the results of problem solving are used. It explains how the environment can be divided into smaller elements, how to describe such elements, their properties and interactions, and many other tasks of a similar nature are solved. Efforts are being made to create such an environmental information model that could be used to select and design a data storage structure.

Can this process be omitted during development, or would that have adverse consequences on the project?

In response to the question: "Can this process be skipped during development, or will it have negative consequences for the project?" You can say no because the process of creating a relational model consists of several steps, which are especially important to perform correctly: Identify all attributes that will be used in the database. Identify relevant entity types. Identify table relationships.

In the process of designing a database, it is necessary to concentrate on the characteristics of the data required to construct the DB model. In order to create an accurate data model, the designer must collect detailed and well-understood data of the company or organization.

As for the logical design, it is done after the DB model (hierarchical, network, relational) has already been determined. It applies to the selected model and is software dependent. Logical design refers to the transfer of a schematic design to an internal model. The logical model of the relational DB includes the design of tables, indexes, virtual tables, and transactions.

?And in terms of physical design, it is the process of defining data storage and data characteristics that affect the location of data storage on the device and the performance of the system. Physical design is better described as technical work. It is very important in hierarchical and network models. A relational DB is more isolated from the physical arrangement of details.

?It can be concluded that he data design and modeling phase to the development of any database is very important. You can't omit this process during development.

References:

Chudinov, I. L., Osipova, V. V.?& Bobrova, Y. V.?(2017).?The methodology of database design in organization management systems.?Journal of Physics: Conference Series, 803(1).?IOPscience.??https://dx.doi.org/10.1088/1742-6596/803/1/012030

Database design basics.?(2021). Microsoft.?https://support.microsoft.com/en-us/office/database-design-basics-eb2159cf-1e30-401a-8084-bd4f9c9ca1f5

GoSparker. (2016, January 10).?Database design tutorial [Video]. YouTube.?https://www.youtube.com/watch?v=I_rxqSJAj6U&t=40s?

Learn DBMS: Simply easy learning.?(2021). Tutorialspoint.?https://www.tutorialspoint.com/dbms/index.htm

Watt, A., & Eng, N. (2014).?Chapter 4: Types of data models. In?Database Design, 2nd Edition. Opentext. Licensed under CC BY 4.0.?https://opentextbc.ca/dbdesign01/?

?Watt, A., & Eng, N. (2014).?Chapter 5: Data modeling. In?Database?Design, 2nd Edition. Opentext. Licensed under CC BY 4.0.?https://opentextbc.ca/dbdesign01/?

?Watt, A., & Eng, N. (2014).?Chapter 6: Classification of database management systems. In?Database Design, 2nd Edition. Opentext. Licensed under CC BY 4.0.?https://opentextbc.ca/dbdesign01/?

?Watt, A., & Eng, N. (2014).?Chapter 7: The Relational Data Model. In?Database Design, 2nd Edition.?Opentext. Licensed under CC BY 4.0.?https://opentextbc.ca/dbdesign01/?

?What is a relational database management system??(2021). Codecademy.?https://www.codecademy.com/articles/what-is-rdbms-sql