// ⌨️ © Created and designed🔒 by D-key aka Gaurav Nath on 20/05/2018. // Copyright © 2018,Gaurav Nath aka D-key, // All Rights Reserved.(Licensed Apache) //🙏 Thank You Everyone and Sololearn for COTD (24-08-2018). //📣📣📣IMPORTANT NOTE:- 🔔🔔👉👉PLEASE SEE THAT PRESSING THE BLANK SUBMIT BUTTON DOESNOT GIVE THE OUTPUT.IT GIVES ONLY THE EXAMPLE OF GIVING INPUT.TO GET THE OUTPUT ONE MUST TYPE THEIR VALUES IN ORDER TO CREATE A DATABASE.🔔🔔👈👈 /* 👇👇INPUT INSTRUCTION:- THIS IS JUST AN EXAMPLE ONE CAN GIVE THEIR OWN VALUES IN THE CONSOLE. Y 2 JULY SALARY 45000 MARCH OTHER 400 👆👆 */ /* 🔔🔔 👉👉 press submit button blank(without typing anything) to get details of input instruction.👈👈(NOTE:- PRESSING THE BLANK SUBMIT BUTTON DOESNOT DISPLAYS THE OUTPUT. IT JUST GIVES AN EXAMPLE TO GET THE OUTPUT ONE MUST TYPE THE VALUES AS SHOWN IN THE EXAMPLE OR ABOVE) 👉👉 DEFINED VALUES FOR AMOUNTS AGAINST EACH CRITERIAS ARE:- AMOUNT CRITERIA 4000 SALARY 1200 ENTERTAINMENT 800 OTHER IF ONE TYPES THE CORRECT AMOUNT FOR THE MONTH THEN DATA IS CONSISTENT OR ELSE NOT.THIS CALLED DATA VALIDATION METHOD OF CHECKING DATA CONSISTENCY OF DATA. 👈👈 */ /* EXTENDED CONCEPT [FACTS FOR LEARNING CONCEPT AND ONLY POINT NO. 3 DOESNOT IMPLY IN THE TECHNIQUE I HAVE USED HERE]:- 1) The main class sets of data defines an injective relation to parent record.So that its one to one and unique function. 2) The trigger data is set to any one of the datas whos data dependency is not an image of the function class record. 3) The anamoly to any fields can be set of data which are equal to statistical minimum average to set the tupled datas of criss crossed database.This kind of database is used by high intelligence security to prevent data leakage.*/ // TO GET AN EXAMPLE OF THE SEQUENCE OF INPUT PLEASE PRESS THE SUBMIT BUTTON BLANK (WITHOUT ANY INPUT). // This is a database manipulation program to check the data inconsistency of data and with input data validation before recording. // The target data is the field that specifies amount criteria in which data consistency paranoia is triggered. //I have also include data validation of characters by input validation. //This is a file database manipulation system using structure pointer of file type. //👉👉For more better result and its working and database storage, compile using gcc or tcc compiler and run the object file in DOS in PC or run it in any IDE. //👉👍👍AND OF COURSE "TO BE LEARNT AND TO LEARN .... SOLOLEARN.WE ALL LEARN DAY BY DAY."✌️✌️✌️✌️ /* 👉👉 📣📣 🔔🔔 👉👉 FOR SIMPLE UNDERSTANDING OF THE WORKING:- Hello everyone this is how the code works in simple. It works with data structures in C.Consider a database where you need to input data.So it creates a database. now there are three columns.So for each criteria has a fixed amount and they are written in file as databass.So if they enter amount beyond these limits or lower than these limits,then it triggers data consistency check and the datacons() function tries to find that. This is to front-end and back-end in system.This design checks the consistency of data from the data structure. 🔌💻 👉👉 FOR ADVANCE USE OF THIS PROGRAM:- This same code can be used in any User system or PC.For that one just needs to compile the program with compiler and Run it in the CLI (command line interface) terminal.It will create a file name "record.dat" with .dat extension and will write the data in the file for real.You can double click on the file in the PC and check the content of the file.The CLI console acts as an front end and the file system database acts like the back-end.And in between you have the event handler to handle system files.So whenever you interact with the console to inout data like amount and other data.It gets manipulated in the files.Just like you have it for other applications like create a file and save option to save the file.But the function of this program is database.And this program checks for data consistency fron the file and it where ever inconsistency is found it displays.The inputs instruction are the same here.However I have created it only for data validation and data consistency.This applies to minimum scripting for the user purpose only.Real time.🔔🔔 📣📣 👈👈 */ /*👉👉SOME WORKING CONCEPT OF THE PROGRAM :- 1) To prevent the bss ds area of the program global uninitialised variables were not used though they would be automatically initalised to 0 by kernel in ds w/r area memory.As to prevent the increase of byte size. 2) The size of structure assumes all the local variables(members) inside the structure.So that each varible can be used with just a single structure variable. 3) fread (&empdat, sizeof(empdat),1,fp2) The fread statement read x bytes (size of empdat) from the file pointer into memory address &empdat. Only one block is requested.Example,if we change the one into ten then it will read in ten blocks of x bytes at once. 4) The fwrite function works the same way,but moves the block of bytes from memory to the file. Generally, it moves the pointer in sizeof(struct empdat) increments to keep the pointer at record boundaries. 5) The binary mode (rb/ab) are used over the text mode in order to prevent the conversion of line feed '\n' to '\n'+ carriage return '\r'. */ //IF YOU LIKE UPVOTE AND SHARE YOUR COMMENTS BELOW.I WOULD LIKE TO THANK YOU FOR TAKING TIME AND COMING HERE.YOUR PRESENCE AND TIME IS MOST VALUABLE AND GREATLY APPRECIATED AS IT CAN BE.THANK YOU.☺️✨ #include #include #include #include #include #define salarylimit 4000 #define enterntlimit 1200 #define otherlimit 800 #define maxenum 100 // Function prototype int create(int); int recdis(); int datacons(); int tribute_alan_turing_gen(); // Create data structure struct employee { int amount; char crit[25]; char month[25]; }empdat; // Initiate timeout count of negative database. int timeout=0; int timein =0; // Function create database + data validation. int create(int j) { int sc; FILE *fp1; fp1 = fopen ("record.dat","a"); scanf("%s",empdat.month); scanf("%s",empdat.crit); scanf("%d",&empdat.amount); // data validation check before creating record. if((strcmp("salary",empdat.crit)==0||strcmp("SALARY",empdat.crit)==0||strcmp("Salary",empdat.crit)==0 || strcmp("entertainment",empdat.crit)==0||strcmp("ENTERTAINMENT",empdat.crit)==0||strcmp("Entertainment",empdat.crit)==0||strcmp("other",empdat.crit)==0||strcmp("OTHER",empdat.crit)==0||strcmp("Other",empdat.crit)==0)&&(strcmp("JANUARY",empdat.month)==0 || strcmp("january",empdat.month)==0 || strcmp("January",empdat.month)==0 || strcmp("FEBRUARY",empdat.month)==0 || strcmp("february",empdat.month)==0 || strcmp("February",empdat.month)==0||strcmp("APRIL",empdat.month)==0 || strcmp("april",empdat.month)==0 || strcmp("April",empdat.month)==0 ||strcmp("APRIL",empdat.month)==0 || strcmp("april",empdat.month)==0 || strcmp("April",empdat.month)==0 ||strcmp("MARCH",empdat.month)==0 || strcmp("march",empdat.month)==0 || strcmp("March",empdat.month)==0||strcmp("MAY",empdat.month)==0 || strcmp("may",empdat.month)==0 || strcmp("May",empdat.month)==0 ||strcmp("JUNE",empdat.month)==0 || strcmp("june",empdat.month)==0 || strcmp("June",empdat.month)==0 ||strcmp("JULY",empdat.month)==0 || strcmp("july",empdat.month)==0 || strcmp("July",empdat.month)==0||strcmp("AUGUST",empdat.month)==0 || strcmp("august",empdat.month)==0 || strcmp("August",empdat.month)==0 ||strcmp("SEPTEMBER",empdat.month)==0 || strcmp("september",empdat.month)==0 || strcmp("September",empdat.month)==0 ||strcmp("OCTOBER",empdat.month)==0 || strcmp("october",empdat.month)==0 || strcmp("October",empdat.month)==0 ||strcmp("NOVEMBER",empdat.month)==0 || strcmp("november",empdat.month)==0 || strcmp("November",empdat.month)==0 ||strcmp("DECEMBER",empdat.month)==0 || strcmp("december",empdat.month)==0 || strcmp("December",empdat.month)==0)) { for(sc=1;sc<=j;++sc) { if(strcmp("salary",empdat.crit)==0||strcmp("SALARY",empdat.crit)==0||strcmp("Salary",empdat.crit)==0) { strcpy(empdat.crit,"SLR"); } if(strcmp("entertainment",empdat.crit)==0||strcmp("ENTERTAINMENT",empdat.crit)==0||strcmp("Entertainment",empdat.crit)==0) { strcpy(empdat.crit,"ENT"); } if(strcmp("other",empdat.crit)==0||strcmp("OTHER",empdat.crit)==0||strcmp("Other",empdat.crit)==0) { strcpy(empdat.crit,"OTR"); } if(strcmp("JANUARY",empdat.month)==0 || strcmp("january",empdat.month)==0 || strcmp("January",empdat.month)==0) { strcpy(empdat.month,"JAN"); } if(strcmp("FEBRUARY",empdat.month)==0 || strcmp("february",empdat.month)==0 || strcmp("February",empdat.month)==0) { strcpy(empdat.month,"FEB"); } if(strcmp("MARCH",empdat.month)==0 || strcmp("march",empdat.month)==0 || strcmp("March",empdat.month)==0) { strcpy(empdat.month,"MAR"); } if(strcmp("APRIL",empdat.month)==0 || strcmp("april",empdat.month)==0 || strcmp("April",empdat.month)==0) { strcpy(empdat.month,"APR"); } if(strcmp("MAY",empdat.month)==0 || strcmp("may",empdat.month)==0 || strcmp("May",empdat.month)==0) { strcpy(empdat.month,"MAY"); } if(strcmp("JUNE",empdat.month)==0 || strcmp("june",empdat.month)==0 || strcmp("June",empdat.month)==0) { strcpy(empdat.month,"JUN"); } if(strcmp("JULY",empdat.month)==0 || strcmp("july",empdat.month)==0 || strcmp("July",empdat.month)==0) { strcpy(empdat.month,"JUL"); } if(strcmp("AUGUST",empdat.month)==0 || strcmp("august",empdat.month)==0 || strcmp("August",empdat.month)==0) { strcpy(empdat.month,"AUG"); } if(strcmp("SEPTEMBER",empdat.month)==0 || strcmp("september",empdat.month)==0 || strcmp("September",empdat.month)==0) { strcpy(empdat.month,"SEP"); } if(strcmp("OCTOBER",empdat.month)==0 || strcmp("october",empdat.month)==0 || strcmp("October",empdat.month)==0) { strcpy(empdat.month,"OCT"); } if(strcmp("NOVEMBER",empdat.month)==0 || strcmp("november",empdat.month)==0 || strcmp("November",empdat.month)==0) { strcpy(empdat.month,"NOV"); } if(strcmp("DECEMBER",empdat.month)==0 || strcmp("december",empdat.month)==0 || strcmp("December",empdat.month)==0) { strcpy(empdat.month,"DEC"); } } //create data in binary append mode fp1= fopen ("record.dat","ab"); fwrite (&empdat,sizeof(empdat),1,fp1); fclose(fp1); } else { // return error for invalid input printf("\n\n ERROR_Set_Overflow ( 0xFF).\n\nData validation failed!! \n\nInappropriate characters in data fields....Please type correctly"); exit(0); } } //display data created int recdis() { FILE *fp2; // read data in binary read mode fp2 = fopen ("record.dat", "rb"); while(fread (&empdat, sizeof(empdat),1,fp2)) { printf("\n\n %s %s $ %d ", empdat.month,empdat.crit,empdat.amount); } printf("\n\n********************************************"); fclose(fp2); } //Check data consistency from data validation.This is the function that will check data consistency. int datacons() { FILE *fp; int s; printf("\n\n******************Byte-Corp*****************"); //read file in binary mode fp = fopen ("record.dat","rb"); printf("\n\n MONTH | EMP_PURPOSE | AMOUNT"); while(fread (&empdat,sizeof(empdat ),1,fp)) { s = empdat.amount; if(s !=salarylimit && strcmp("SLR",empdat.crit)==0) { timeout++; printf("\n\n %s %s $ %d ", empdat.month,empdat.crit,empdat.amount); } if(s!=enterntlimit && strcmp("ENT",empdat.crit)==0) { timeout++; printf("\n\n %s %s $ %d ", empdat.month,empdat.crit,empdat.amount); } if(s!=otherlimit && strcmp("OTR",empdat.crit)==0) { timeout++; printf("\n\n %s %s $ %d ", empdat.month,empdat.crit,empdat.amount); } } printf("\n\n%d Inconsistent values found",timeout); printf("\n\n********************************************\n\n"); fclose(fp); } int tribute_alan_turing_gen (int secran) { int l,tanran; for(l=1;l<10;++l) { secran=rand()%maxenum; tanran=secran+1; } return tanran; } //driver program for the functions. int main() { char c; int m,i,counter,bonran,tanran; scanf("%c",&c); printf("\n\n First do you wanna create employee database and check data consistency? (Y/N) :- %c",c); if (c== 'y' || c== 'Y' || c== 'n' || c== 'N') { if (c == 'y' || c== 'Y') { srand(time(0)); scanf("%d",&counter); printf("\n\n Please wait...Modelling //path/Record"); tanran = tribute_alan_turing_gen (bonran); printf("\n\n Creating Record....loading....%d%%",tanran); printf("\n\n******************Byte-Corp*****************"); printf("\n\n MONTH | EMP_PURPOSE | AMOUNT"); for(i=1;i<=counter;++i) { m=i; create(i); } recdis(); printf("\n\n%d Data record created\n\n\n\n",m); tanran=tribute_alan_turing_gen (bonran); printf("\n\n Checking Data Consistency....Loading %d%%",tanran); datacons(); } else if (c == 'n' || c == 'N') { printf("\n\n Thank you for using.Have a Nice day."); exit (0); } } else { printf ("\n\n===========================================" "\n\nNOTE:- THIS IS NOT THE OUTPUT OF THE PROGRAM.THIS IS JUST AN EXAMPLE SECTION OF GIVING INPUTS.FOLLOW THE STEPS GIVEN BELOW TO INPUT THE DATA AS PER PRIORITY ORDER OF SEQUENCE" "\n\n===========================================" "\n\n\n Please type Y or N followed by inputs.Refer the example given below to give input in the order as its shown." "\n\n IMPORTANT NOTE:- User can input any values for any field provided they write full name of the month with or without the uppercase and full name of the criteria with or without uppercase and also amount in numbers only." "\n\n INPUT DETAILS ORDER :-" "\n\n 1) Y/N" "\n\n 2) Number of data record to be created" "\n like 1 or 2" "\n\n 3) Month (in full name)" "\n\n 4) Criteria Salary,entertainment,other" "\n all case insensitive but need to type" "\n it in full name" "\n\n 5) Amount in numbers" "NOTE:- DATA IS CONSISTENT FOR:- AMOUNT 4000 for CRITERIA SALARY, AMOUNT 800 for CRITERIA OTHER and AMOUNT 1200 for CRITERIA ENTERTAINMENT \n\nThe example given below is just a demonstration of giving the input in the order of sequence.And it doesnot imply that user must give these values only.USERS HAVE CHOICE :-)"); printf("\n\n Example/Demo(Input order):- "); printf("\n\n Y "" <====This means option yes or no" "\n\n 1 "" <====This means how many records ""\n to create" "\n\n JANUARY "" <====This means any month" "\n\n salary "" <====This means the 4 " "\n criteria which consist of" "\n \"salary\" " "\n \"entertainment\" and " "\n \"other\"" "\n\n 45000 "" <====This means any amount" "\n but note that it is fixed " "\n for each criteria like :- " "\n\n salary = 4000" "\n\n entertainment = 1200" "\n\n other = 800" "\n\n OR you can input for the given way below in the next run" "\n\n Y"" <====This means option yes" "\n\n 2 "" <====This means its going create ""\n 2 records.So you need to ""\n type for all the values for ""\n the 2 record considering ""\n each value.Its shown below ""\n as how many records are " "\n needed to be typed.One can ""\n give their own choice here" "\n\n december"" <====This means any month." "\n One can type their " "\n own choices of months" "\n\n Other"" <==== This means any " "\n criteria of record as " "\n explained above." "\n One can type their own " "\n choice of the defined " "\n criterias" "\n\n 5000"" <==== This means amount.Data ""\n will be inconsistent if" "\n you type beyond the" "\n defined limits.So here data" "\n is inconsistent" "\n\n July "" <====This means any " "\n month.One can type their " "\n own choices of months" "\n\n ENTERTAINMENT"" <==== This means any " "\n criteria of the record" "\n as explained above." "\n\n 1200"" <==== This means amount.Data ""\n will be consistent if " "\n you type within limits." "\n\n OR you can input the other way also for the next run.Its given below." "\n\n N <==== This means if you type N " "\n the program exit" "\n\n For data deduplicate or to find duplicate data,type any two or more records of similar type" "\n\n So run the program in any combinatorics provided one stays with the rule of giving input in rhe prescribed order and prevent typing error or else one may get the error print message." "\n\n if you like then upvote and share your comments below. I would like to thank you for taking time and coming here by having a look at the program.Your presence and time are most valuable and greatly appreciated as it can be.Thank you!! :-)" "\n\nThank You Sololearn and everyone for COTD on 24-05-2018" "\n\n Copyright 2018, Gaurav Nath aka D-key,All Rights Reserved (licensed Apache)"); exit(0); } fflush(stdout); return 0; }

Paranoia: Data Consistency Database