Relational Database Application Lifecycle

College
Essay
Miscellaneous
Pages 3 (753 words)
Download 0
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…

Introduction

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
Not exactly what you need?

Related papers

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:…
Distributed Database
Best customers are those who subscribe to 7day, 52week, EZPay {automatic payment from credit card} subscriptions.…
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.…
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.…
Database paper
Prevention of unauthorized access and efficient solutions for failure recovery are also provided by a database server.…
Database management
2B. The Relational model for the above ERD follows : CREATE TABLE players ( playerid number primary key, name varchar(30), bdate date, schoolid number references school(schoolid), yr_joined number, grad_school number references school(schoolid)
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).…