Database Design, Implementation, and Management

Only available on StudyMode
  • Download(s) : 305
  • Published : March 9, 2011
Open Document
Text Preview
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, suitable software application should be integrated into the database environment to support more advanced features and services. Following a well-structured database lifecycle will contribute to a reliable and satisfactory performance of the database system.

Database system and its management is a quite broad principle. This dissertation focuses on the process of a database application lifecycle. The whole process would be applied to establish a gymnasium management database system. The first two parts introduce the basic concepts concerning database environment. The next four parts present the most important stages in a database lifecycle – its requirement identification, design, implementation, and management – by showing what shall be done, the process of doing so, as well as the techniques which could be taken advantage to attain the best results. The last part introduces a backup-and-restore strategy for this database system.

【Key Words】
database management system; database application lifecycle; database design; database backup-and-restore; gymnasium database system; Microsoft SQL Server 2005

数据库的设计、实现和管理
—— 健身房数据库系统

【摘 要】进入21世纪以来,很多企业开始利用数据库对与企业运营相关的各项数据进行高效的操作和管理。一个合适的数据库管理系统可以提供一系列功能帮助企业进行数据管理。 建立数据库的过程是一个数据库应用周期,其特点是耗时较长,并且需要大量的时间、精力和资源来完成。一个优秀的数据库管理员应该不断完善企业的数据库系统,以满足公司不断增长的数据处理需求。另外,随着科技的不断更替,数据库系统应及时融入新的软件应用程序,使其可以提供更多高端的服务。利用一个结构清晰的数据库应用周期可以使开发出的数据库系统提供稳定而高效的服务。 本文的研究重点为数据库应用周期。全文通过利用周期内各个阶段可以使用的技术和操作设计并实现了一个小型健身房数据库管理系统。本文前两部分介绍了和数据库环境相关的基本概念;后面的四个章节分别研究了数据库应用周期中最核心的阶段——需求分析、设计、实现、和管理——并介绍了每一阶段的目的、步骤、以及所使用的技术。最后提出了一个合理的数据库备份和还原策略。

【关键词】数据库管理系统;数据库应用周期;数据库设计;数据库备份与还原;健身房数据库系统;Microsoft SQL Server 2005 Contents

1. Introduction1
2. Database Management System2
2.1 Database and Database Management System2
2.2 Database Application Lifecycle错误!未定义书签。 3. Database Requirement Identification错误!未定义书签。 3.1 The Process of Database Requirement Identification错误!未定义书签。 3.2 Requirement Specification for the Target Gymnasium错误!未定义书签。 4. Database Design错误!未定义书签。

4.1 Conceptual Database Design错误!未定义书签。
4.1.1 Relation Modeling错误!未定义书签。
4.1.2 Entity-Relationship Modeling错误!未定义书签。 4.1.3 User Transactions Validation错误!未定义书签。 4.2 Logical Database Design错误!未定义书签。
4.2.1 Validate Relations Using Normalization错误!未定义书签。 4.2.2 Build and Validate Global Logical Data Model错误!未定义书签。 4.3 Physical Database Design错误!未定义书签。
5. Database Implementation错误!未定义书签。
5.1 DBMS Selection错误!未定义书签。
5.2 Database Implementation错误!未定义书签。
5.3 Database Testing错误!未定义书签。
6. Database Management错误!未定义书签。
7. Conclusion错误!未定义书签。
References4
Acknowledgement6
Appendix7
Appendix A. Data Dictionary7
Appendix B. Source Code错误!未定义书签。
List of Figures

Figure 1. Database application lifecycle ….………………………………………….. 8 Figure 2. Data collection for gymnasium management database system …...………. 12 Figure 3. Data flow diagram for gymnasium’s membership management …………...13 Figure 4. Example of ER diagram ……………………………………………….…...17 Figure 5. Microsoft SQL Server Management Studio ……………………….…….....24 Figure 6. Report generated using Report Services in SQL Server 2005 ……………...24 Figure 7. Example of creating database ……………………………………………....25 Figure 8. Example of...
tracking img