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.