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 288
- Downloads 4
Implementation of Fuzzy Logic Based On Photovoltaic Maximum Power Point Tracking For PMDC Motor
This paper presents implementation of maximum power point tracking (MPPT) method employed in photovoltaic system to extract maximum solar energy and utilise it for driving pmdc motor. In this we use fuzzy logic techniqu...
Thermal comfort increase using up cycled PET bottles shutters technology
An appropriate technology based on up-cycled PET water bottles utilization is presented. The bottles constitute the main constructive element of a shutters system. The most relevant expected application is to meliorate...
slugObtaining an Accurate and Comprehensive Data Mining Model
It is important for shareholders and potential investors to use relevant financial information to enable them to make good investment decisions in the stock market. Predicting stock performance is certainly very complic...
Opportunities for Female Entrepreneurs in India
In today’s world, women entrepreneurs are playing very vital role and they have become important part of the global business environment and it’s really important for the sustained economic development and social progre...
Design and Fabrication of Metal Strip Cutting Machine
Metal cutting is the basic process in any steel industries, ship building and bridges. Usually the industries cut the metal manually by using chop saw. It takes lot of time to measure the required length of the metal st...