Database Design, Implementation, and Management

2233 Words Mar 21st, 2011 9 Pages
ABSTRACT

Database Design, Implementation, and Management

— Gymnasium Database System

As the world entering into a digital era, most of organizations use different kinds of database environment to achieve efficient management. A suitable database management system provides a set of tools for an organization to efficiently track and manage its data.

The development of a database follows a database application lifecycle. It is a rather long process and requires a considerable amount of time, energy, and resources as well. A database administrator is obliged to strive for the perfection of the database to address the increasing amount of information to be dealt with. Apart from that, since new technology keeps emerging,
…show more content…
Example of creating procedure ……………………………………......…..25
Figure 11. The process of Test First Development …………………………………...27
Figure 12. Full&Log backup strategy ………………………………………… ..…... 31
List of Tables

Table 1. Example of entity types …………………………………………………….15
Table 2. Example of relationship types …………………………………………...…15
Table 3. Example of attribute list ……………………………………………………16
Table 4. Example of transaction list …………………………………………………18
Table 5. Example of physical data model ……………………………………………22

1. Introduction

For any organization the collection and storage of data have always been a primary concern. Large organizations nowadays use a database system to address this task. However, the earliest solution is a file-based system, and it is still in use in many small firms today.

File-based system is a set of application programs that provides services for users to keep and process data. Each program is independent and can define and manage its own data. When users need to look up some information, they go to the filing system and search from the first entry until the desired result is found.

Although the file-based system can be an effective approach sometime, it does suffer from two detrimental problems:

← Isolation of data. When stored in a file-based system, data is kept within separate files in an isolated manner. It would be a rather difficult task when users want to access relevant information from two different files. ←
Open Document