Open Collections

An expert view creation system for database design

University of British Columbia

The process of generating user views during logical database design is formalized and expressed as a set of rules which comprise the knowledge base of an expert system. This system, called the View Creation System, engages the user in a dialogue to determine information requirements. These requirements are then translated into a set of Fourth Normal Form relations representing a view. The data model on which the system is based is the Entity-Relationship Model. Using this model, the system elicits entities, attributes and relationships while trying to detect and rectify inconsistencies and ambiguities in the user's input. With the aid of the user, functional dependencies are isolated and resolved before the final set of relations is produced.

Text

2010-08-07

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.

http://hdl.handle.net/2429/27203

Business Administration

University of British Columbia

Graduate