There are several different methodologies that can be used for designing a database schema; no one is the best for all occasions. This unit demonstrates two different techniques for designing relational tables and discusses when each should be used. These two techniques presented are (1) traditional Entity‐Relationship (E‐R) modeling and (2) a hybrid method that combines aspects of data warehousing and E‐R modeling. The method of choice depends on (1) how well the information and all its inherent relationships are understood, (2) what types of questions will be asked, (3) how many different types of data will be included, and (4) how much data exists.
[1]
E. F. Codd,et al.
The Relational Model for Database Management, Version 2
,
1990
.
[2]
E. Myers,et al.
Basic local alignment search tool.
,
1990,
Journal of molecular biology.
[3]
Ian Abramson,et al.
Oracle8 i data warehousing
,
1998
.
[4]
W. H. Inmon,et al.
Building the Operational Data Store
,
1995
.
[5]
M. Ashburner,et al.
Gene Ontology: tool for the unification of biology
,
2000,
Nature Genetics.
[6]
Stéphane Bressan,et al.
Introduction to Database Systems
,
2005
.