Posts

Question

 1. To print your name 2. To print your mailing address 3. To print your name 4. To print your mailing address 5. To do arithmetical operations 6. To do arithmetical operations by getting input value from the keyboard or user 7. To find the area of a circle 8. To find the area of a triangle 9. To find the volume of the sphere 10. To find the volume of the cylinder 11. To convert farenheit to celcius scale 12. To find the square root for a given number 13. To identify the number as even or odd 14. To identify the given year is leap or not 15. To identify the bigger of two numbers 16. To identify the biggest of three numbers 17. To identify the given number as one digit, two digit, three digit or more than three digit 18. To count the number of digits present in a number 19. To identify the given character as vowel or not 20. To check whether a string is palindrome or not 21. To sort words in alphabetic order 22. To reverse a number 23. To compute the simple interest 24. To check ...
Image
  1)Create a database named "Employee" CREATE database Employee; 2) Create a table named "payroll" CREATE TABLE payroll(name varchar(20),emp_id varchar(10),mobile int(10),email varchar(20),salary int(10),pf int(10),total_work_days int(10),emp_work_days int(10),extra_shifts int(12)) INSERT INTO `payroll` (`name`, `emp_id`, `mobile`, `email`, `salary`, `pf`, `total_work_days`, `emp_work_days`, `extra_shifts`) VALUES ('princy', '21ER', '45645456', 'princy@gmail.com', '20000', '10000', '30', '27', '2'), ('james', '13ER', '65766564', 'james@gmail.com', '50000', '1200', '31', '28','3'),('rosy','24ER','78878787','rosy2gmail.com','23000','1230','31','20','1'),('tina','24ER','76656545','tina@gmail.com','26000','2000...

Good

 ADBMS Lab MYSQL Database Queries Create Database Mysql>CREATE DATABASE sjcds; Show Database mysql> SHOW DATABASES; Use Database mysql> USE emplyeedb; Drop Database DROP DATABASE [IF EXISTS] database_name; Create Table mysql> CREATE TABLE employee_table( id int NOT NULL AUTO_INCREMENT, name varchar(50) NOT NULL, degree varchar(35) NOT NULL, age int NOT NULL, PRIMARY KEY (id) ); Show Tables mysql> SHOW TABLES; Alter table ALTER TABLE cus_tbl ADD mobile int(10) NOT NULL; Drop Table mysql> DROP TABLE orders; Truncate Table TRUNCATE TABLE table_name; Rename Table RENAME TABLE stu_table TO student_table; Insert Table CREATE TABLE People(     id int NOT NULL AUTO_INCREMENT,     name varchar(45) NOT NULL,     occupation varchar(35) NOT NULL,     age int,     PRIMARY KEY (id) ); INSERT INTO People VALUES (102, 'Joseph', 'Developer', 30), (103, 'Mike', 'Leader', 28), (104, 'Step...
Image
 22

INTRO To Latex

Image
LaTeX is one of the efficient methods for publishing journals and papers in today's society, It is essential to study latex like other coding programmes  First step : \documentclass{article} This is the first step as like as in #include in C, Inside the braces we can use many extensions but mostly we use article   step 2 : Using packages \usepackage{amsmath,amssymb} this is the package for math mode typing also there are many packages, table for tabulation and table making,and graphicx for picture installation.   Step 3 : then we shall begin the document with the command. \begin{document}           ..............     \end{document}  On giving begin document automatically \end {document} will appear,if not we have to put \end{document} in the end of the problembetween begin and end document we've to create the program or the content Step 4 :    We can use the facilities which are available ...