Abstract
Several query languages have been proposed in which users graphically manipulate Entity-Relationship (ER) diagrams to formulate queries. In this paper we present a method of implementing an ER query and update language as an interface for a relational Database Management System. The approach is based on interactive manipulation of ER database schemas and generation of SQL expressions for an underlying relational database. The graphical query and update formulation process is formally defined. We assume that the information reflecting the current state of the query and update formulation process is maintained in a formal model. The model described in other publications is significantly modified and extended. The information included in the extended model allows an ER diagram corresponding to the current state of the query to be displayed on the terminal screen. It is also used to generate an equivalent SQL expression for a relational database. The integrity constraints for the formal model are specified.
Talk to us
Join us for a 30 min session where you can share your feedback and ask us any queries you have
Disclaimer: All third-party content on this website/platform is and will remain the property of their respective owners and is provided on "as is" basis without any warranties, express or implied. Use of third-party content does not indicate any affiliation, sponsorship with or endorsement by them. Any references to third-party content is to identify the corresponding services and shall be considered fair use under The CopyrightLaw.