Software Quality Metrics
Database design
Logical Layout
5.
6.
Introduction
1.
Identification of Requirements
2.
Requirements Analysis
3.
Conceptual Design
4.
Conclusions
10.
Maintenance and Evolution
9.
Physical Design
7.
Implementation
8.
Table of Contents
The design of a database is a fundamental process for the development of any information system, it implies a series of steps and phases to create an efficient and coherent data structure. Good database design can improve system performance, reduce data errors and redundancies, and improve maintainability.
1. Introduction
The first step is to identify the system requirements, that is, the data that must be stored and how it must be used. Factors such as the size of the database, the number of users, the types of data, and the amount of information that must be stored must be considered.
2.Identification of Requirements
Once the requirements have been identified, the information must be analyzed to determine how the data should be organized and what relationships exist between them. This phase includes the creation of data flow diagrams, entity-relationship diagrams, and other data models.
3. Requirements analysis
In this phase, a conceptual data model is created that describes the structure of the database and the relationships between the entities. This model does not take into account the physical implementation of the database.
4. Conceptual design
4. Conceptual design
Once the conceptual model has been created, it must be converted into a logical model. In this phase, the database schemas, attributes, and data types to be used are determined.
5. Logical Design
5. Logical Design
This phase determines the technical details of the database, such as the type of database management system to use, how the tables and indexes will be created, and how The data will be stored on disk.
6. Physical Design
6. Physical Design
7. Implementation
The last phase of database design involves the maintenance and continuous evolution of the database. This involves making adjustments to the database structure as system needs change and making updates to ensure that the database continues to function correctly over time.
After the physical design has been created, the database can be deployed. This involves creating the database structure, loading the data, and testing to ensure everything works correctly.
8. Maintenance and Evolution
Database design is a critical process that must be carried out carefully to ensure that system requirements are met and business objectives are achieved.
If the data is not organized properly, it can be difficult to find and retrieve, which can negatively affect decision making and the general operation of the system.
The design of the database is important because it directly affects the quality of the information that is stored in it.
10. Conclusiones
Thank you
