UBC Theses and Dissertations

UBC Theses Logo

UBC Theses and Dissertations

An expert view creation system for database design Storey, Veda Catherine


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.

Item Media

Item Citations and Data


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.