Different stages of ddlc, Database Management System

Assignment Help:

Different stages of DDLC?


Related Discussions:- Different stages of ddlc

Define the concept of design documentation, Design Documentation  The ...

Design Documentation  The Design Document shall be an extension of Requirements Analysis Design. "The Design Document will comprise a revised and much more detailed descrip

What are the time stamps associated with each data item, What are the time ...

What are the time stamps associated with each data item? W-timestamp (Q) denotes the largest time stamp if any transaction that implemented WRITE (Q) successfully. R-timesta

Describe the static hash file with buckets and chaining, Describe the stati...

Describe the static hash file with buckets and chaining and show how insertion, deletion and modification of a record can be performed. In static hash file organization, the wo

What are the technique to define a schema completely, What are the techniqu...

What are the technique to define a schema completely ? A schema is completely define by DDL and DML query language.

Single valued normalisation, Single Valued Normalisation  Codd in the y...

Single Valued Normalisation  Codd in the year 1972 formed three normal forms (1NF, 2NF, and 3NF). These were based on functional dependencies between the attributes of a relati

What is database trigger, What is database Trigger? A database trigger ...

What is database Trigger? A database trigger is a PL/SQL block that can explained to automatically execute for insert, update, and delete statements against a table. The trigge

Explain the concept of deadlock, Question: In a multi-user database env...

Question: In a multi-user database environment, locking mechanisms can be used to solve the three basic problems of concurrency. On the other hand, however, locking may also le

Database ass1, #quCreate a database design specification (Enhanced Entity R...

#quCreate a database design specification (Enhanced Entity Relationship Diagram (EERD) and Relational Data Model (RDM)) from the given business description. The RDM must be in 3rd

Compare the two log based recovery schemes, Compare the two log-based recov...

Compare the two log-based recovery schemes in terms of ease of implementation and overhead cost.    Ans:  There are two types of log based recovery techniques: deferred update

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