DBMS-FINAL

1. This phase is concerned with analyzing potential application areas, performing preliminary cost-benefit studies, determining the complexity of data and process.

• Validation and acceptance testing

• Feasibility analysis

• Requirements collection and analysis

• Design

2.This phase has two aspects the design of the database system and design of the application system

• Implementation

• Validation

• Design

• Maintenance

3. The information system is implemented, the database is loaded, and the database transactions are implemented and tested.

• Testing

• Implementation

• Deployment

• Operation

4. Detailed requirements are collected by interacting with potential users and user groups to identify their particular problem and needs.

• Requirements collection and analysis

• Maintenance

• Design

• Feasibility Analysis

5. This may be preceded by conversion of users from an older system as well by user training.

• Validation and acceptance testing

• Deployment,

  operation and maintenance

• Implementation

• Design

6.The acceptability of the system ,meeting users requirements and performance criteria is validated.

• Requirements Collection

• Design

• Deployment,

  operation and maintenance

• Feasibility Analysis

7. A complete logical and physical design of the database system on the chosen DBMS prepared.

• Application Conversion

• Database design

• System Definition

• Loading or data conversion

8. Any software applications from a previous system converted to the new system.

• System Definition

• Database implementation

• Application conversion

• Testing and Validation

10.It involved process, techniques.

• Testing and validation

• Operation

• maintenance

• Monitoring

11.

• Foreign Key

• Primary Key

• Candidate Key

• Super key