|
|
 |
Database Design and Implementation
Information is increasingly being recognized as an organizational resource on par with
financial and human resources. It is a critical input to managerial decision-making.
Managers need high quality information to manage change in a turbulent and highly competitive
global environment. Information is based on systems for storage, maintenance, and timely
retrieval of relevant data presented in an appropriate format. These storage, maintenance,
and retrieval systems are an organization's memory. The organization relies on them, just as
individuals rely on their personal memory, to continue as a going and viable entity. The
specific objectives of this course are:
- Comprehend the concepts of database design and
management, especially those associated with logical data
modeling and relational data model.
- Understand the fundamental objectives of data management
and recognize the contribution of specific data
management design decisions towards meeting these
objectives.
- Be able to apply the principles of logical data modeling.
- Understand the issues affecting the retrieval of data
from a relational database and how retrieval constraints
can be overcome by selectively deNORMALIZING the data
model for implementation.
- Develop an appreciation for the magnitude of data
retrieval problems through the techniques of Data Volume
Analysis (DVA) and Data Usage Analysis (DUA).
- Be able to explain the special design issues associated
with data administration, security, backup, recovery etc.
- Demonstrate, as a member of a group or as an individual,
the ability to apply the principles of data modeling and
database design to develop a working database
application.
- Understand the new directions in DBMS.
- Demonstrate the ability to synthesize data from several
sources, including using the emerging standards on the
Internet, i.e. XML.
We will occasionally tackle small problems in groups during class.
Book
Kroenke, Modern Database Management, 1998 edition.
Other Readings
- Simsion Graeme, Data Modeling: Testing the
Foundations, Database Programming & Design, February
1996.
- Navathe Shamkant B., Evolution of Data
Modeling for Databases, Communications of the ACM,
September 1992, 35/9, pages 112-122.
- McGovern David, The Relational Model Turns
25, DBMS, October 1994, pages 46-60.
- Premerlani William J. and Blaha Michael
R., An Approach for Reverse Engineering of Relational
Databases, Communications of the ACM, May 1994, 37/5.
- Stonebraker Michael R., A New Direction in
DBMS, DBMS, February 1994.
- Young Casey, So You're not
Rumpelstiltskin, Database Programming & Design, July
1996.
Journals
- ACM Transactions on Database Systems,
Association of Computing Machinery, New York, Quarterly.
- Database Programming & Design, Miller
Freeman Publications, San Francisco, CA
Trade Journals
- Database Newsletter, DBMS, Database
Review, InfoDB, Database Advisor, Database
go back
|
|
