science and technology

Table and it's operations Table/Entity To represent this information one can use DBMS modeling. In a DBMS a group of similar information or data which is of interest to an organization is called an Entity. Entity information is stored in an object called Table. For example, a client is considered an entity. Information about the client entity can be stored in a client_master table. A table is really a two dimensional matrix that consists of rows and columns. Attributes/Columns/Fields Each entity can have a number of characteristics. A client can have characteristics like name, address, telephone number, fax number, balance due etc. The characteristics of an entity are called  Attributes.  The values for these characteristics are called  Attribute Values. When entity information is stored in a table, the attributes associates with the entity are stored in the table columns / table fields. The client_master table can have columns like name, address, telep

The rename operation with select statement This is a mechanism used for renaming both relations and attributes, this meaning is highly useful when one has to compare a set of tuples of the same relation with other tuples of the relation. It has the following general format: Old_name as new_name, The as clauses can appear in both the select and from clauses. For example if we want the attribute name loan_no to be replaced with the name loan_id, we can write a query as select distinct cust_name, borrowers.loan-no as loan_no From  borrowers,loan Where borrower.loan_no=loan.loan.no AND Branch_name=”KR CIRCLE” Tuple variables To define tuple variables, we use AS clause, Tuple variables are defined in the from clause via the use of the AS clause. A tuple variable in SQL must be associated with a particular relation. To illustrate we write the, query “For all customers who have a loan from the bank, find their names and loan numbers” as select distinct cust_name, B.loa

The while statement In some cases, the number of times the body of a loop would be executed is not known in advance, or depends only on the truth or falsity of an expression. In such cases, the for loop could not be used. Hence the while loop could be used instead. The syntax of the while loop is as follows: While (test_expression) { // block of statements } A while loop will begin by checking to see if the test_expression is true. It the test_expression is true the body of the loop will be executed, and then the test_expression will be checked again and if the test_expression is true the body of the loop will be executed again. This will continue until the value of the test_expression turns up false, and the loop body will not be executed – control will pass to the statements following the while loop. The sum example discussed in the previous section could be rewritten using while loop as follows: int sumSoFar =0; int i=0; // while (test_expression) while(I <

The switch construct The switch statement is very similar to the if-else-if ladder of section statements. Here is its general form: switch (expression) { case constant_1: statement_1 or block_1; break; case constant_2: statement_2 or block_2; break; case constant_3: statement_3 or block_3; break; // More cases may follow default statement_X or block_X; } In the switch construct, as in the if-else-if construct, multiple possible blocks of code are being selected from, and only one of them will typically be executed. The presence of the keyword break allows the execution to come out of the switch statement. Omission of break takes control through the next case statements irrespective of whether the value of case matches or not. This can also be used constructively when same operation has to be performed on a number of cases. Each case or possible block of code is initiated by the appearance of the case reserved word, and is terminated by the appearance of the

The if-else statement in C++ The if then else statement is used when the question is not whether to execute a statement or statements, but which statement or statements to execute. The simplest if-else construct consists of two options, and its format is: If (logical expression) statement 1 or block 1; else statement 2 or block 2; next_statement If logical expression is TRUE, statement1 (or block1) is executed and then next_statement is executed. If logical expression is FALSE, statement2 (or block2) is executed and then next_statement is executed. For e.g., the following program segment informs the user concerning the existence of real solutions in the quadratic equation. Let a, b, c be the coefficients of the quadratic equation. Then if the roots are real, the discriminate d=b 2 -4ac will be greater than or equal to zero.i.e., D=b*b-4*a*c; If(d>=0) then Message: “roots are real” else Message: “roots are imaginary” For e.g., The following program segme

If statement The if section structure is used to select or determine a course of action that depends on the values of program variables. A very simple example of the need for such a structure would be a program to find the roots of quadratic equation based on the values of coefficients of the equation. Depending on the value of a, b, and c in the quadratic equation there are either 0, 1,0r 2 roots of the equation. The procedure followed is to evaluate the discriminate and based on its value we would assign 0, 1, or 2 to the variable indicating the number of roots of the equation. The simple if statement is used when a course of action consists of (a) executing a statement or block of statements, or (b) NOT executing the statement or block of statements. The syntax of If statement is: If (logical expression) statement 1; next_statement If the logical expression is TRUE, statement is executed and then next_statement is executed. If the logical expression is FALSE, stat

The for statement The syntax of the for statement is: For (initialization; test expression; update expression) { // Boby of loop – block of statements } The three parts of the for statement determine the loop actions. First, the loop initializes the relevant variables. Then there is a test expression, evaluated as true or false. If the test expression is TRUE (this means the test expression is non-zero) the sequence of instructions which forms the body of the loop is executed. Finally, expressions are updated and the process returns to the test expression part of the loop. (The initialization in a loop takes place only when the program enters the loop.) The sum program can be rewritten using for statement as follows: int sumSoFar = 0; //(Start of loop; test condition; increment the loop variable;) for ( int i=1; I < =100; I = i+1)  { sumSoFar = sumSoFar +I; // This is the body of the loop } Example of for loop Here are some examples of simple for loops wi