Relational Database Application Lifecycle - Essay Example

Only on StudentShare

Extract of sample
Relational Database Application Lifecycle

After modeling the entities with their attributes and defining the relationships between attributes, we have to normalize the model (normalization of data is a process of removing data anomalies and adjusting relations to have several desirable characteristics).
Testing needs to be done to identify and remove errors in the design and implementation of the database, structure and constraints e.t.c. There are two main tasks involved; validation and verification.
Validation checks whether the right solution has been developed to meet the specific requirements while verification checks whether the database has been implemented correctly according to the functional requirements set.
After the database becomes functional the maintenance phase comes into play to ensure smooth working, identification and resolution of problems and further improvements if necessary are made in this stage. (Sumathi & Esakkirajan, 2007)
As the name suggests the above mentioned process is not linear rather it is cyclic. This means that movement can take place to and fro from any stage of the cycle. ...
Download paper


The feasibility stage determines identifies and, clarifies the scope, and initial estimated for time, cost, and need for the system. If the project is approved, it is time to move on to the next stage of requirement collection.
Requirements are decided after mutual consultation and agreement among all the users as to what data is to be stored along with the meaning and interpretation of the data elements…
Author : robelbridgette

Related Essays

Database Management: Application in School Environment
It allows us to access our Microsoft Access database and any other ODBC compliant data source. The various departments who have access and benefiting from these database are the following:
2 pages (502 words) Essay
Distributed Database
Best customers are those who subscribe to 7day, 52week, EZPay {automatic payment from credit card} subscriptions.
12 pages (3012 words) Essay
Database Systems
Conflicts may occur which likely to generate erroneous outcomes. Notice the precedence graphs are acyclic, that is, they do not have loops. Thus, they cannot represent cyclic computations. Since many of the computations in operating systems are cyclical, this is a strong restriction.
3 pages (753 words) Essay
rdms. phase 1 db2
The second phase focuses on the design of the database model that will support company operations and objectives. In the process of database design, concentration must be placed on the data characteristics required to build the database model. Two views of the data within the system are available the business view of data and the designers' view. RDBLC's second phase also includes data definition. It is also important to note thatthe database design is not a sequential process it is rather an iterative process with continuous feedback.
8 pages (2008 words) Essay
Relational Database
The data stored in such databases includes the past data and archives too along with the current one.
8 pages (2008 words) Essay
Describe the architecture of a relational database, including how the data is organized. Explain a relational DBMS. What are some of the limitations of a relati
Each column has a column name and contains values that are bound by the same type and size. For example, a column in the table S_DEPT specifies the names of the departments in the organization.
6 pages (1506 words) Essay
Database application, Planning, Design, and Implementation
273). To build huge groups of data functional, individuals and organizations make use of computers and effiecient data management systems. Similar to a warehouse, a database is a storage area for group of similar and associated data or facts. On the other hand, a database management system (DBMS) is software tool that facilitates multiple users to store, retrieve, and perform operations on data or facts into functional information (Norton, 2001, p. 272).
1 pages (251 words) Assignment
Got a tricky question? Receive an answer from students like you! Try us!