Per the text, the Database Life Cycle includes the Database Initial Study, Datab

Question

Per the text, the Database Life Cycle includes the Database Initial Study, Database Design, Implementation and Loading, Testing and Evaluation, Operation, and Maintenance and Evolution phases. However, the actual implementation of each of the phases will likely change, based on the size of the related organization or other organizational factors.

Select one (1) phase of the Database Life Cycle, and describe the manner in which the chosen phase would change based on the size of the organization.

Using the same phase that you selected in Part 1 of this discussion, describe the manner in which the phase would change, based on the distribution of the organization and the associated distributed database design.

Explanation / Answer

The life cycle of a relational computer file full of information is the cycle of development and changes that a relational goes through during the course of its life. The cycle usually consists of more than two, but not a lot of stages. There is a possibility that the computer file full of information designer/developer can go back to any of the previous stages. This represents an act of letting someone enter/speaking the truth about something bad that a full understanding of a problem, and its solution is likely to change and get better as the different stages of design and putting into use go ahead/move forward.

A this is usually a basic part of the information system, especially in business oriented systems. This way design is part of system development.The typical eleven stages involved in the life cycle of a relational are as follows:

Database Planning:

The Database planning includes the activities that allow the stages of the Database system development lifecycle to happen/be made real as efficiently and effectively as possible. This phase must be combined with other things with the overall Information System success plan(s)/way(s) of reaching goals of the organization.

The very first step in Database planning is to define the mission statement and goals for the (computer file full of information) system. That is the definition of:
the major aims of the Database system
the purpose of the Database system
the supported tasks of the Database system
the useful things/valuable supplies of the Database system

Systems Definition:

In the systems definition phase, the extent and/the range and edges/borders of the Database application are described. This description includes:links with the other information systems of the organization
the planned system is going to do now and in the future
the users are now and in the future.

Needed things Collection and Analysis:

During the needed things collection and analysis phase, the collection and analysis of the information about the part of the business/project to be served by the Database are completed. The results may include the description of the data used or created

Database Design:

The Database design phase is divided into three steps:
idea-based Database design
logical Databasedesign
physical Databasedesign

In the idea-based Databasedesign phase, the model of the data to be used independent of all physical (things to carefully think about) is to be built. The model is based on the needed things (detailed description of exactly what is required) of the system.

In the logical (computer file full of information) design phase, the model of the data to be used is based on a specific data model, but independent of a particular Database management system is built. This is based on the target data model for the (computer file full of information) e.g. relational data model.

In the physical Database design phase, the description of the use of the Database on secondary storage is created. The base relations, indexes, restrictions, security, etc. are defined using the SQL language.
Database Management System Selection

Application Design:

In the application design phase, the design of the user connecting point/way of interacting with something) and the application programs that use and process the Database are defined and designed.

Protyping:

The purpose of an early model is to allow the users to use the early model to identify the features of the system using the computer.There are flat/left-and-right and up-and-down early models. A flat/left-and-right early model has many features but they are not working. An up-and-down early model has very few features but they are working.

Putting into use:

During the putting into use phase, the physical (understanding/achieving a goal) of the Database and application designs are to be done. This is the programming phase of the systems development.

Data (changing from one form, state, or state of mind to another) and Loading:

This phase is needed when a new Database is replacing an old system. During this phase the existing data will be moved from one place to another into the new Database.

Testing:

Before the new system is going to live, it should be completely tested. The goal of testing is to find errors! The goal is not to prove the software is working well.
Operational Maintenance.

The operational maintenance is the process of watching/supervising and maintaining the Database system.

Watching/supervising means that the performance of the system is watched/followed. If the performance of the system falls below an acceptable level, tuning or reorganization of the Databasemay be needed/demanded.

Maintaining and upgrading the Database system means that, when new needed things arise, the new development lifecycle will be done.

Putting into use are used change, but very hard to change of every phase .
Putting into use :
The Putting into use Phase is the final phase of the SDLC and it involves the actual construction and installation of a system. The output of the database design phase is a series of instructions explaining/describing the creation of tables, attributes, domains, views, indexes, security
restrictions, and storage and performance guidelinesThis phase also includes the maintenance of the system and any future updates or (act of something getting bigger, wider, etc.) of the system.

Physical installation of the server hosting the database
Installation of the database onto the system
Installation of the database Management System
Initialization and continuous operation of the database and DBMS
Maintaining the hardware and software hosting the database
Updating the hardware physical hard drives, etc and software DBMS as needed

This phase is the longest phase as it has no defined endpoint, with the exception of the end of the system and its users.
a. Install the DBMS:
This step is needed/demanded only when a new dedicated instance of the DBMS is
necessary for the system. The DBMS may be installed on a new server or it
may be installed on existing servers. One current (popular thing/general way things are going) is called
virtualization. Virtualization is a way of doing things that creates logical
representations of figuring out/calculating useful things/valuable supplies that are independent of the
hidden (under) physical figuring out/calculating useful things/valuable supplies.

b. Create the (computer file full of information)(s):
In most modern relational DBMSs a new database putting into use needs/demands
the creation of special storage-related constructs to house the end-user
tables. The constructs usually include the storage group (or file groups), the
table spaces, and the tables.

c. Load or Convert the Data:
After the database has been created, the data must be loaded into the
database tables. Usually, the data will have to be moved from the prior
version of the system. Often, data to be included in the system must be
grouped from many sources. Data may have to be imported from other
relational database, non relational database, flat files, older/ related to things given to future people systems, or
even manual paper-and-pencil systems

Maintenance :
The database manager must be prepared to perform something commonly done maintenance activities within the database. Some of the needed/demanded occasional maintenance activities include:

serving to stop something bad before it happens maintenance backup . Corrective maintenance recovery .
able to change and get better maintenance improving performance, adding things/businesses and attributes, and so on

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.