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. ...Show more

Summary

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
Save Your Time for More Important Things
Let us write a custom essay on your topic
"Relational Database Application Lifecycle"
with a personal 20% discount.
Find out more

Related Essays

Database Management: Application in School Environment
The actual mechanics of locating and processing of data elements carried out by a database processing programs. The chart below demonstrates the sequence of processing. In an environment like a school, we are using DAO (Data Access Objects), ODBC (Open Database Connectivity) with the Jet Database Engine to access data from a variety of databases.
2 pages (500 words) Essay
Distributed Database
The questions identified encompass business processes related to new subscriber acquisition, demographic household maintenance, subscriber account maintenance, subscription marketing, and customer list profiling. 1.We profile our "best subscribers" to pull lists of "like" non-subscribers that we could touch in some way.
12 pages (3000 words) Essay
Database Systems
(RENAME(alecturerId, aunitCode, ayear)( UnitDelivery)) JOIN aunitCode = cunitCode JOIN ayear
3 pages (750 words) Essay
rdms. phase 1 db2
(Rob & Coronel, 2002) The initial study is conducted to identify and clarify the scope and initial estimate for time, cost, and the need for the system. So, in addition to examining the current system's operation within the company, the designer must determine how and why the current system fails and gather information and other requirements for the new system.
8 pages (2000 words) Essay
Relational Database
Today, with the increasing data requirements and storage needs, the databases have gone a step further. The emergence of data warehouses or advanced
8 pages (2000 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
A table represents an entity. For example, the S_DEPT table stores information about the departments of an organization. A Column is a collection of one type of data in a table. Columns represent the
6 pages (1500 words) Essay
Database application, Planning, Design, and Implementation
The most apparent instance of a non computerized database is a telephone directory. On the other hand, telephone companies at the present time make use of an electronic database program to turn out their
1 pages (250 words) Assignment
Find out how much would it cost
to get a custom paper written by a pro under your requirements!
Win a special DISCOUNT!
Put in your e-mail and click the button with your lucky finger
Your email
YOUR PRIZE:
Apply my DISCOUNT