Elmasri, Ramez A.2023-10-042023-10-04198412137831https://hdl.handle.net/10657/15149The purpose of this thesis is to design and implement a view definition and query translation system for Views on the Entity Category Relationship (ECR) model using GORDAS, a high level database language. Currently there are two possible approaches for schema design: top-down and bottom-up. Here the bottom-up approach is adopted. This means the external schemas/views are built upon the existing conceptual schema. In our implementation, GORDAS is extended to support view definitions for the ECR model. The technique of query modification is used to translate GORDAS queries against an ECR external schema into equivalent GORDAS commands against an ECR conceptual schema. The approach is based on that proposed for relational query languages, with differences due to the ECR model's support for entity sets and functional interrelationships.application/pdfenThis item is protected by copyright but is made available here under a claim of fair use (17 U.S.C. Section 107) for non-profit research and educational purposes. Users of this work assume the responsibility for determining copyright status prior to reusing, publishing, or reproducing this item for purposes other than what is allowed by fair use or other copyright exemptions. Any reuse of this item in excess of fair use or other copyright exemptions requires express permission of the copyright holder.Database managementComputers--Access controlThesisreformatted digital