Techniques for Performing User-Defined Integrity Constraint
Journal Title: International Journal for Research in Applied Science and Engineering Technology (IJRASET) - Year 2017, Vol 5, Issue 5
Abstract
Integrity constraints help us to maintain integrity i.e., correctness of the table in any database. Whenever a user creates a new database then wrong entry can be inserted in the table. To prevent these wrong entries we initiate data constraints while creating the new table. The integrity or data constraints are categorized into two methods – Input-Output Constraints and Business Rule Constraints. The input-output constraints are applicable on general table & common to all types of organizations. On the other hand business rule are specific to any specific business or organization. Business rules, which are enforced on data being stored in a table, are called constraints. Integrity control deals with the prevention of semantic errors made by users due to their carelessness or lack of knowledge; the integrity control subsystem uses integrity rules to verify the database and operations on the database. The business can also used user-defined constraints which are defined by the Oracle Trigger. Trigger helps a business to defined constraints which are not possible using built-in constraints. In this paper we defined various triggers to prevent business or an organization from entry or performing wrong operation in the table of any specific database.
Authors and Affiliations
Jyoti . , Sneha
Keywords
Related Articles
- EP ID EP24308
- DOI -
- Views 275
- Downloads 9
Mutual Authentication between IOT and Cloud Servers
Internet of Things (IoT) is an upcoming statement of belief where reference and communication technology connect multiple confined devices to the Internet for perfor ming idea exchange. Owing to the huge development abo...
Implementation of a High-Speed RSD Based ECC Processor with Vedic Multipliers
In this paper, an exportable application-specific instruction-set elliptic curve cryptography processor based on redundant signed digit representation is proposed. The processor employs extensive pipelining techniques f...
Study on Road Accidents and Safety Measures along Selected Roads in Tiruchirappalli, India
One of the undesirable features of road transport is its poor record of road safety. Majority of accidents are due to over speed of vehicles irrespective of speed limits in urban areas. Road accidents cause heavy loss t...
Hot Metal De-Sulphurisation by KR Process
The objective of this project is to present an analysis of the use of residual mixtures in the pig iron desulphurization process. This study involves the Effect of Aluminium dross, fluorspar, and lime. These mixtures we...
Exploring Agriculture Sector Using Crowdsourcing Predictors
India is a nation where agriculture is considered as a basic occupation and the largest source of national growth. Farmer is said to be man of nation. We consider this as our responsibility and prime duty to explore thi...