Data Integrity is the assurance of accuracy and consistency of data over its entire life-cycle, and is a critical aspect to the design, implementation and usage of any system which stores, processes, or retrieves data. It also defines integrity constraints to enforce business rules on the data when it is entered into an application or a database.... Read More

OLTP stands for Online Transaction Processing. And is a class of software applications capable of supporting transaction-oriented programs. An essential attribute of an OLTP system is its ability to maintain concurrency... Read More

Triggers may implement DML by using INSERT, UPDATE, and DELETE statements. These triggers that contain DML and find other triggers for data modification are called Nested Triggers.... Read More

We have four types of SQL Queries: DDL (Data Definition Language): the creation of objects DML (Data Manipulation Language): manipulation of data DCL (Data Control Language): assignment and removal of permissions TCL (Transaction Control Language): saving and restoring changes to a database Let’s look at the different commands under DDL: Command Description CREATE Create objects in the database ALTER Alters the structure of the database object DR... Read More

#include stdio.h> #include conio.h> int fact(int); int main() { int factorial, num; printf("Enter the value of num :"); scanf("%d", &num); factorial = fact(num); printf("Factorial is %d", factorial); return (0); } int fact(int n) { if (n == 0) { return (1); } return (n * fact(n - 1)); } ... Read More

Program : To obtain solution of second order quadratic equation #include <stdio.h> #include <math.h> int main() { float a, b, c; float desc, root1, root2; printf("\nEnter the Values of a : "); scanf("%f", &a); printf("\nEnter the Values of b : "); scanf("%f", &b); printf("\nEnter the Values of c : "); scanf("%f", &c); desc = sqrt(b * b - 4 * a * c); root1 = (-b + desc) / (2.0 * a); root2 = (-b - desc) / (2.0 * a); ... Read More

C Program to calculate sum of 5 subjects and find percentage #include <stdio.h> int main() { int s1, s2, s3, s4, s5, sum, total = 500; float per; printf("\nEnter marks of 5 subjects : "); scanf("%d %d %d %d %d", &s1, &s2, &s3, &s4, &s5); sum = s1 + s2 + s3 + s4 + s5; printf("\nSum : %d", sum); per = (sum * 100) / total; printf("\nPercentage : %f", per); return (0); } Output : Enter marks of 5 subjects : 80 70 90 8... Read More

#include <stdio.h> int main() { int num, rem, rev = 0; printf("\nEnter any no to be reversed : "); scanf("%d", &num); while (num >= 1) { rem = num % 10; rev = rev * 10 + rem; num = num / 10; } printf("\nReversed Number : %d", rev); return (0); } Output : Enter any no to be reversed : 123 Reversed Number : 321 ... Read More

#include <stdio.h> int main() { int gross_salary, basic, da, ta; printf("Enter basic salary : "); scanf("%d", &basic); da = (10 * basic) / 100; ta = (12 * basic) / 100; gross_salary = basic + da + ta; printf("\nGross salary : %d", gross_salary); return (0); } Output : Enter basic Salary : 1000 Gross Salart : 1220 ... Read More

An electric power distribution company charges its domestic consumers as follows Consumption Rate of Units Charge ------------------------------------ 0-200 Rs.0.50 per unit 201-400 Rs.100 plus Rs.0.65 per unit excess 200 401-600 Rs.230 plus Rs.0.80 per unit excess of 400. ------------------------------------ Write a C program that reads the customer number and power consumed and prints the amount to be paid by the customer. P... Read More