Different stages of ddlc, Database Management System

Assignment Help:

Different stages of DDLC?


Related Discussions:- Different stages of ddlc

What are referential integrity constraints, What are referential integrity ...

What are referential integrity constraints? A value that appears in single relation for a given set of attributes also appears for a particular set of attributes in another rel

What is a primary key, What is a primary key? Primary key is chosen by ...

What is a primary key? Primary key is chosen by the database designer as the principal means of identifying an entity in the entity set.

Extended star schema model, A customer places orders for parts and belongs ...

A customer places orders for parts and belongs to a particular industry group. An individual order is taken by a particular sales representative on a specific date and the sales re

Queries, Write a query that display ename annual salary and comm from emp t...

Write a query that display ename annual salary and comm from emp table

Basic set operation, These are the binary operations; i.e., each is applied...

These are the binary operations; i.e., each is applied to two relations or sets. These two relations can be union compatible excluding in case of Cartesian product. Two relations R

Briefly describe concurrency execution, Briefly describe concurrency execut...

Briefly describe concurrency execution? Lock - based protocols Locks There are several modes in which a data item may be locked in this section we restrict our attention

Linear commit protocol, With the linear commit protocol, sites are connecte...

With the linear commit protocol, sites are connected in a chain, and the subtransaction at the left-hand end of the chain initiates the protocol. Propose a crash recovery protocol

Using column aliases-data manipulation language, Using Column aliases E...

Using Column aliases Example: To print column names as NAME and ANNUAL SALARY SELECT ENAME "NAME", SAL*12 "ANNUAL SALARY" FROM EMP;

What are the requirements of algorithm designer, What are the Requirements ...

What are the Requirements of algorithm designer Algorithm designer should: i) Select proper algorithm so as to minimize implementation cost ii) Find most appropriate d

Define direct file organization, Define Direct file organization? The d...

Define Direct file organization? The direct file organization is employed to enhance the performance in accessing the records than sequential file organization. In direct file

12/5/2013 4:55:37 AM

This information be able to be used to found relationships between current applications and to identify uses of application information. It helps to identify future system requirements and to assess economic benefits of database system.


Feasibility Study- Afeasibility study engages preparing report on these following points: 

1. Technological feasibility- Is suitable skill offered to support database development?
2. Operational feasibility- Does a company have personnel, budget and internal expertise to create a database system successful?
3. Economic feasibility- Can benefits are identified? Determination desired system be cost-beneficial? Could costs and benefits be measured?


Requirements Definition- It involves defining scope of database identifying management and functional area information requirements and establishing hardware or software requirements.
Information requirements are determined from questionnaire responses, interviews with managers and clerical clients and reports and forms currently life form used.

Conceptual Design- conceptual design stage produces conceptual schema for database. Specifications are developed to a point where implementation is able to begin. Throughout this stage, detailed models of user view are created and integrated into conceptual data model recording all corporate data elements to maintain in database.

Implementation- During database implementation, DBMS is selected and acquired. Then detailed conceptual model is converted to implementation model of DBMS, data dictionary built, database populate, application programs developed and customers trained.

Database Evaluation & Maintenance- Evaluation involves interviewing users to determine but any data needs are unmet. Changes are made as needed. Over time system is maintained via introduction of enhancements and adding up of programs and data elements as business requests change and expands.

Write Your Message!

Captcha
Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd