Discuss SDLC methodogies and how it can help database develo

Discuss SDLC methodogies and how it can help database development.

Solution

SDLC:

SDLC stands for system development life cycle,sdlc is a process used in the creation and maintenance and development of an information system.This process is used for creation and updating database system.

SDLC has six phases:

1)planning phase

2)Analysis phase

3)Design phase

4)Implementation phase

5)Maintenance Phase

Planning phase:

this phase is responsible for creating the system to determine what the system needs to do for the organization.

in this phase asking some questions like a)what do we need this system for b)what will the system do for the organization

2)Analysis phase:

In this phase business requirements are gathered in this phase.stake holders and users are held in order to determine the requirements like:

a)who is going to use the system?

b)how will they use the system?

c) What data should be input into the system?

3) Design phase:

In this phase the system and software design is prepared from the requirement specifications which were studied in the first phase.Technical design requirements are prepared in this phase by lead development staff that can include architects and lead developers

4)Implementation phase:

The Implementation Phase is the final phase of the SDLC and it involves the actual construction and installation of a system. This phase also includes the maintenance of the system and any future updates or expansion of the system.

a)Physical installation of the server hosting the database

b)Installation of the database onto the system

c)Installation of the Database Management System

d)Initialization and continuous operation of the database and DBMS

e)Maintaining the hardware and software hosting the database

5)Maintenance:

This means installing the software on user machines. At times, software needs post-installation configurations at user end. Software is tested for portability and adaptability and integration related issues are solved during implementation.

SDLC methodologies :

various SDLC methodologieshave been developed to maintain the process involved,including the

1)waterfall model,

2)RAD(rapid application development)

3)JAD(JOINT APPLICATION DEVELOPMENT)

4)Spiral model

1)waterfall model:

Waterfall model is the simplest model of software development paradigm. It says the all the phases of SDLC will function one after another in linear manner. That is, when the first phase is finished then only the second phase will start .This model is when developers already have designed and developed similar software in the past and are aware of all its domains.

2)Rapid application development model (RAD):

The basic approach of this model is to let the user try the application before it is finally delivered. The users provide feedback based upon their hands-on experience with the system

Iterative Model:

The Iterative model is repetition incarnate. Instead of starting with fully known requirements, you implement a set of software requirements, then test, evaluate and pinpoint further requirements. A new version of the software is produced with each phase, or iteration. Rinse and repeat until the complete system is ready.

Spiral model:

Spiral model is a combination of both, iterative model and one of the SDLC model. It can be seen as if you choose one SDLC model and combine it with cyclic process .

SDLC methodology follows the following steps: