Describe a database using life cycle concepts
Describe a database using life cycle concepts (that is, life cycle of a database)
The database lifecycle is a process that includes the creation of a database, resource allocation, managing the database schema and data. Additionally, the process also includes the performance of the backup, the recovery tasks and decommissioning of the databases.
The first phase of the development is the planning phase. In this phase, the individual designing the database determines what they have, what they want to have and develop a reasonable procedure on how to develop the database. A feasibility study may be needed to ascertain the cost, availability of the required materials.
The second stage in the lifecycle is the requirements phase. In this phase, a list of the high-quality requirements is put together. According to Singh (2011), the chief requirement in this phase is the determination of what has to be achieved and how it will be achieved. The third phase is the theoretical design phase. In this stage of the process, reports, web pages and forms are designed. The process is normally documented. The rules of the business model are also documented in this section.
The fourth stage is the logical design phase. At this stage, the technical designs of the database are worked out, and the tables and the database are normalized. The physical design phase is the fifth phase whereby the design that had been created in the logical phase is converted into implementable designs in terms of software and hardware. This point also allows for the creation of the indexed databases.
In the construction phase, the system is coded, and the various tests are conducted. Stress testing is also done to ensure that the database can hold up during extreme pressure plans. The last phase is the ongoing support phase where the already developed system is maintained.
References
Singh, S. K. (2011). Database systems: Concepts, design and applications. Delhi: Dorling Kindersley (India.
