Implementing user-defined Integrity Constraint in MYSQL
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2015, Vol 3, Issue 6
Abstract
The methods with which we can maintain correctness of any specific table in data base management system are Integrity constraints. The general idea of this paper is to investigate and observe user-defined integrity constraint handling or integrity control in relational database management systems. Every business applications run among the rules which are defined previously, these rules are also valid and appropriate to business data and they should not be violated. MySQL presented a unique and special feature called data constraint or integrity constraint that was applied with the formation data structure. Constraints are business rules, which are imposed on data being stored in a table. Due to their carelessness or lack of knowledge Integrity control deals with the avoidance of semantic errors made by users; Integrity rules used by the integrity control subsystem so that it verify the database and operations on the database. In today's database systems and functions for implementing user-defined integrity constraints triggers are being applying in a variety of important ways. The most important use of triggers is still to implement a variety of integrity constraints taken by the application, and we have disagreed that additional uses of triggers than one might think are in fact maintaining constraints of one sort or another.
Authors and Affiliations
Deepika, Mr. Anil Arora
Keywords
Related Articles
- EP ID EP20890
- DOI -
- Views 261
- Downloads 5
LED Based Energy Efficient Wireless Street Light Control and Monitoring System
Lighting systems, particularly within the public sector, are still designed per the previous standards of reliability and that they don't usually profit of latest technological developments. Use of renewable energy sour...
An Interactive Online Employee Training and Tracking System
Employee training is essential for an organization’s success. When any company recruit students from the campus, it never place directly on working before providing any training to them. The company trains their employe...
Utilization of Waste Material in Concrete Paver Blocks: A Review
Interlocking Concrete Block has been presented in India in development, 10 years prior, for particular requirement to be specific footpaths and parking areas and so on. Presently Interlocking Concrete Block Pavement is...
Wide Bandwidth CMOS Low Noise Amplifier Using Matched Coplanar Waveguide Line for Wireless Communication
In this work, the simulation analysis of low noise amplifier and rectangular micro-strip patch antenna is proposed. In this, two different modules are proposed and analysed through Agilent ADS tool. Firstly, a rectangul...
Experimental Investigation on Four Stroke Single Cylinder Petrol Engine Using Water Cooling
In internal combustion engines, water injection, also known as anti-detonate injection, is spraying water into the cylinder or incoming fuel-air mixture to cool the combustion chambers of the engine, allowing for greate...