- Library Home /
- Search Collections /
- Open Collections /
- Browse Collections /
- UBC Theses and Dissertations /
- Design of relational database schemas : the traditional...
Open Collections
UBC Theses and Dissertations
UBC Theses and Dissertations
Design of relational database schemas : the traditional dependencies are not enough Ola, Adegbemiga
Abstract
Hitherto, most relational database design methods are based on functional dependencies (FDs) and multivalued dependencies (MVDs). Full mappings are proposed as an alternative to FDs and MVDs. A mapping between any two sets, apart from being one-one, many-one, or many-many, is either total or partial on the source and target sets. An 'into' mapping on a set, expresses the fact that an element in the set may not be involved in the mapping. An 'onto' mapping on a set is total on the set. A many-many (into,onto) mapping from set A to set B is written as A[sup=i] m----n B[sup=o]. The mappings incorporate more semantic information into data dependency specification. It is shown, informally, that the full mappings are more expressive than FDs and MVDs. Transformation rules, to generate Boyce-Codd normal form and projection-join normal form schemas from the full mappings, are defined. The full mapping/transformation rules provide a discipline for modeling nonfunctional relationships, within a synthetic approach.
Item Metadata
Title |
Design of relational database schemas : the traditional dependencies are not enough
|
Creator | |
Publisher |
University of British Columbia
|
Date Issued |
1982
|
Description |
Hitherto, most relational database design methods are based
on functional dependencies (FDs) and multivalued dependencies
(MVDs). Full mappings are proposed as an alternative to FDs and
MVDs. A mapping between any two sets, apart from being one-one,
many-one, or many-many, is either total or partial on the source
and target sets. An 'into' mapping on a set, expresses the fact
that an element in the set may not be involved in the
mapping. An 'onto' mapping on a set is total on the set. A
many-many (into,onto) mapping from set A to set B is written as
A[sup=i] m----n B[sup=o].
The mappings incorporate more semantic information into data dependency specification. It is shown, informally, that the full mappings are more expressive than FDs and MVDs. Transformation rules, to generate Boyce-Codd normal form and projection-join normal form schemas from the full mappings, are defined. The full mapping/transformation rules provide a discipline for modeling nonfunctional relationships, within a synthetic approach.
|
Genre | |
Type | |
Language |
eng
|
Date Available |
2010-03-31
|
Provider |
Vancouver : University of British Columbia Library
|
Rights |
For non-commercial purposes only, such as research, private study and education. Additional conditions apply, see Terms of Use https://open.library.ubc.ca/terms_of_use.
|
DOI |
10.14288/1.0051825
|
URI | |
Degree | |
Program | |
Affiliation | |
Degree Grantor |
University of British Columbia
|
Campus | |
Scholarly Level |
Graduate
|
Aggregated Source Repository |
DSpace
|
Item Media
Item Citations and Data
Rights
For non-commercial purposes only, such as research, private study and education. Additional conditions apply, see Terms of Use https://open.library.ubc.ca/terms_of_use.