Academic Integrity: tutoring, explanations, and feedback — we don’t complete graded work or submit on a student’s behalf.

Database System Life Cycle The Database System Life Cycle, otherwise known as th

ID: 3706065 • Letter: D

Question

Database System Life Cycle

The Database System Life Cycle, otherwise known as the System Development Life Cycle (SDLC), consists of five important steps:
  1. Investigation.
  2. System Design.
  3. Development.
  4. Execution.
  5. Maintenance.

  • Summarize each step and describe how they work together.
  • Explain how you have used, or can use, the cycle in another context. For example, how can these steps be used when buying a car or planning a trip?
  • Use a table to show parallels between developing a database and performing the task you chose.

Database System Life Cycle

The Database System Life Cycle, otherwise known as the System Development Life Cycle (SDLC), consists of five important steps:
  1. Investigation.
  2. System Design.
  3. Development.
  4. Execution.
  5. Maintenance.

  • Summarize each step and describe how they work together.
  • Explain how you have used, or can use, the cycle in another context. For example, how can these steps be used when buying a car or planning a trip?
  • Use a table to show parallels between developing a database and performing the task you chose.
The Database System Life Cycle, otherwise known as the System Development Life Cycle (SDLC), consists of five important steps:
  • Summarize each step and describe how they work together.
  • Explain how you have used, or can use, the cycle in another context. For example, how can these steps be used when buying a car or planning a trip?
  • Use a table to show parallels between developing a database and performing the task you chose.

Explanation / Answer

Database System life cycle:-

Investigation:-

During investigation step, the database designers have to talk to the customers (database users) to understand the proposed system and obtain and document the data and functional requirement.
The requirements should not describe how the data is processed, but it should include what are the attributes,data items,what constraints apply and relationships betwwen the data items.
The aim of investigation is to obtain a detailed description of the data that will suit user requirements so that both high and low level properties of data and their use are dealt with.
These include properties such as the possible range of values that can be permitted for attributes (e.g., in the school database example, the student course code, course title and points).

Business tool which are specific to investigation which includes:
Requirements gathering
Structured analysis

System Design:-

System Design requires the necessary specifications, features and operations that will satisfy the functional requirements of the proposed system.
This is the step for end users to discuss and determine their specific business information needs for the proposed system.
During this phase they have to consider the essential components such as hardware and/or software structure i.e. networking capabilites, processing for the system to accomplish its objectives.

Development:-

The Development phase is when the real work begins—in particular, when a programmer, network engineer and/or database developer do work on the project.
This work includes using a flow chart to ensure that the process of the system is properly organized.
The development phase marks the end of the initial section of the process.
This phase signifies the start of production.
The development stage is also characterized by instillation and change.

Execution:-

The Execution phase is where the majority of the code for the program is written.
Additionally, this phase involves the actual installation of the newly-developed system.
This step puts the project into production by moving the data and components from the old system and placing them in the new system.
Both system analysts and end-users should now see the realization of the project that has implemented changes.

Maintenance:-

This phase involves maintenance and regular required updates.
This step involves if user wish, to boost performance, add new capabilities or meet additional user requirements.