Review of Integrity Constraint in MySQL
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2015, Vol 3, Issue 6
Abstract
For the semantic correctness of database records, Integrity constraints or data constraints are proper representations of invariant conditions. Constraints can be articulated in declarative languages such as data log, predicate logic, or SQL. All business applications run with predefined rules and these rules are also valid to business data and they should not be violated. MySQL has a special feature call data constraint or integrity constraint that was useful at the time of creation of data structure. Business rules, which are imposed on data being stored in a table, are called constraints. for permanent storage ,Constraints super control the data being entered into a table. In this paper we have to learning the two types of data constraints that can be applied to data being inserted into a Mysql table. 1). I/O constraint and 2). Business constraint.
Authors and Affiliations
Deepika Last Name, Anil Arora
Keywords
Related Articles
- EP ID EP20870
- DOI -
- Views 296
- Downloads 4
Implementing an Embedded based Smart Street Light Controlling System through Piezo Electric Effect
electricity has become one of the major need of present day civilization and its demand is increasing quickly. Therefore we’d like a non-conventional method of power generation. This paper focuses on the need of automat...
slugDesign Formulation and Optimum Load Carrying Capacity of Hydrodynamic Journal Bearing By using Genetic Algorithm
The ever increasing demand of lower initial costs for bearing, to withstand competition, has prompted engineers to apply optimization methods in bearing design. The optimization scheme that optimizes load carrying capac...
Smart Garbage Collection System
Waste collection and disposal is a complex process that requires the use of money and elaborate management of logistics. This paper will elaborate the structural design working and overall hierarchical description of th...
Ground Bouncing Noise Reduction in Combinational Circuits
As technology scales into the nanometer regime ground bounce noise and noise immunity are becoming important metric of comparable importance to leakage current, active power, delay and area for the analysis and design o...
Analysis of Preamble and Synchronization Errors Estimation in Wireless OFDM Communications
Global mobile data usage increase by almost threefold [4] in the year 2010 . This increased data usage is from the rise in the number of consumer electronic devices that rely on wireless standards such as IEEE802.11 (Wi...