prathmeshyelne has Published 58 Answers

What is Normalization in SQL ?

SQL
Published on 14-Dec-2021 16:47:00
Normalization is used to decompose a larger, complex table into simple and smaller ones. This helps us in removing all the redundant data. Generally, in a table, we will have a lot of redundant information which is not required, so it is better to divide this complex table into multiple smaller tables which contains only unique information. First normal form: A relation schema is in 1NF, if and only if : – All attributes in the rela... Read More

How to create a database in SQL?

SQL
Published on 14-Dec-2021 16:43:51
A database is a repository in sql, which can comprise of multiple tables. This will be the command to create a database in sql: CREATE DATABASE database_name. ... Read More

How to delete a row in SQL ?

Published on 12-Dec-2021 20:58:57
We will be using the DELETE query to delete existing rows from the table: DELETE FROM table_name WHERE [condition]; We will start off by giving the keywords DELETE FROM, then we will give the name of the table, after that we will give the WHERE clause and give the condition on the basis of which we would want to delete a row. For example, from the employee table, if we would like to delete all the rows, where the age of the employee is ... Read More

How to change a table name in SQL ?

Published on 12-Dec-2021 20:48:01
This is the command to change a table name in SQL: ALTER TABLE table_name RENAME TO new_table_name; We will start off by giving the keywords ALTER TABLE, then we will follow it up by giving the original name of the table, after that, we will give in the keywords RENAME TO and finally, we will give the new table name. For example, if we want to change the “employee” table to “employee_information”, this will be the command: AL... Read More

How to delete a table in SQL ?

Published on 12-Dec-2021 20:41:30
There are two ways to delete a table from sql: DROP and TRUNCATE. The DROP TABLE command is used to completely delete the table from the database. This is the command: DROP TABLE table_name; The above command will completely delete all the data present in the table along with the table itself. But if we want to delete only the data present in the table but not the table itself, then we will use the truncate command: DROP TABLE table_n... Read More

How to check the type of triangle using C

Published on 12-Dec-2021 17:04:29
C Program to check the type of triangle #include <stdio.h> #include <math.h> int main() { int side1, side2, side3; //Change values accordingly side1 = 5; side2 = 4; side3 = 3; if ((side1 + side2 > side3 && side1 + side3 > side2 && side2 + side3 > side1) && (side1 > 0 && side2 > 0 && side3 > 0)) { if (side1 == side2 &&am... Read More

How to Calculate Area of Circle using C Programming

Published on 12-Dec-2021 13:16:37
C Program to Calculate Area of Circle Shape : Circle Formula : Π * r * r Definition : 1. Ellipse in which the two axes are of equal length 2. Plane curve generated by one point moving at a constant distance from a fixed point 3. You can compute the area of a Circle if you know its radius. Program : #include <stdio.h> int main() { float radius, area; printf("\nEnter the radius of Circle : "); scanf("%d", &... Read More

How to Calculate Area of Rectangle using C Program

Published on 12-Dec-2021 13:06:07
C Program to Calculate Area of Rectangle Shape : Rectangle formula : area = l * b Definition : 1. A plane figure with 4 sides and 4 right angles and having Equal Opposite Sides 2. Adjucent sides makes an angle of 90 degree 3. You can compute the area of a Rectangle if you know its length and breadth Program :  #include <stdio.h> #include <conio.h> int main() { int length, breadth, area; printf("\nEnt... Read More

How to Calculate Area of Right angle Triangle using C Language

Published on 12-Dec-2021 12:56:56
C Program to Calculate Area of Right angle Triangle Definition : Triangle having one angle of measure 90 degree is called Right angle Triangle. Sides of Triangle are : base , height , hypotenuse. You can compute the area of a Tr. if you know its any two sides. Program :  #include <stdio.h> int main() { int base, height; float area; printf("\nEnter the base of Right Angle Triangle : "); scanf(... Read More

How to Find Area of Scalene Triangle using C

Published on 12-Dec-2021 12:44:54
C Program to Find Area of Scalene Triangle : #include <stdio.h> #include <math.h> int main() { int s1, s2, angle; float area; printf("\nEnter Side1 : "); scanf("%d", &s1); printf("\nEnter Side2 : "); scanf("%d", &s2); printf("\nEnter included angle : "); scanf("%d", &angle); area = (s1 * s2 * sin((M_PI / 180) * angle)) / 2; printf("\nArea of Scalene Triangle : ... Read More