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 274
- Downloads 5
Analysis of Speed-Flow Relationship of Heterogeneous Traffic – A Case Study of Selected Stretch of Dakor Road
The developing cities have generated the high levels of travel demand by motor vehicles in the cities. This has resulted in changing in nature of traffic characteristics on road network and ultimately it affects the cap...
Evaluation of C.I Engine Performance and Emission Characteristics Fueled with Cng and Ethanol Blends as Alternative Fuel
Environmental air pollution and global warming are alarming concern world wide. Increasing air pollution, rapid growth of industrialisation and the global trend of urbanisation have totally disturbed the eco balance of...
Combined Beamforming with Space Time Frequency Coding for Mimo-OFDM Systems
Multiple antennas can be used in wireless systems to attain good quality of service and high data rate communication. Recently, efficient space-time-frequency (STF) codes have been developed to improve the diversity gai...
Intelligent Train Engine and Running System
This paper is an attempt to improve the currently running railway system by automation of the rail engine and the unmanned railway crossing gates. This system is designed to automatically change speed in accordance to t...
A model based testing method for Software Security Assurance
The importance of software security assurance is growing, but traditional development techniques have not kept pace with this need. New cost-effective tools for software quality and security assurance (SSA) are needed....